SASInstitute A00-215 問題集

質問 1：
You need to access data stored in a SAS dataset named 'SalesData' within a SAS library named 'MySalesLibrary'. Which LIBNAME statement would you use to assign the dataset to the SAS library?
A. LIBNAME MySalesLibrary 'SalesData' DATA,
B. LIBNAME MySalesLibrary 'SalesData' SASDATA,
C. LIBNAME MySalesLibrary 'SalesData-sas7bdat'
D. LIBNAME MySalesLibrary 'SalesData' ,
E. LIBNAME MySalesLibrary 'SalesData' FILE,
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You need to export a SAS dataset 'sales_data' to a CSV file, but you want to replace missing values with the string 'N/A'. Which option within the PROC EXPORT statement should you use?
A. FILL=N/A
B. REPLACE=N/A
C. DEFAULT=N/A
D. NULL=N/A
E. MISSING=N/A
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You are tasked with analyzing customer data, specifically identifying customers who have made more than 3 purchases in the last 6 months. You need to use the OUTPUT statement to create a new dataset containing only these high-frequency customers. Which code snippet would you use to achieve this?
A.

B.

C.

D.

E.

正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You are working with a dataset 'SALES DATA' containing sales information. You have variables 'PRODUCT ID' (character), 'SALES DATE' (numeric, in SAS date format), and 'UNITS SOLD' (numeric). You want to calculate the total units sold for each product within the past year. Which code snippet correctly achieves this?
A.

B.

C.

D.

E.

正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You have two SAS datasets, 'EMPLOYEES' and 'SALARY HISTORY', with common key variables 'EMPLOYEE ID' and 'DATE'. You want to merge these datasets, but only include records from 'SALARY HISTORY' that have a corresponding match in 'EMPLOYEES' for the same 'EMPLOYEE ID' and 'DATE'. You also want to ensure that if a 'SALARY HISTORY' record has no matching 'EMPLOYEE ID' in 'EMPLOYEES' for the same 'DATE', the record is excluded from the final dataset. Which of the following code snippets correctly implements this logic?
A.

B.

C.

D.

E.

正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You have a dataset with a variable 'START DATE' representing the start date ofa project. You want to create a new variable 'END DATE' which is set to the 1st of the month following 'START DATE'. Which code snippet correctly calculates 'END DATE'?
A.

B.

C.

D.

E.

正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You have a SAS dataset named 'CUSTOMERS' with the following structure: Customer_lD,First_Name,Last_Name,Email 123,John,Doe,[email protected] 456,Jane,Smith,[email protected] 789,Peter,Jones,[email protected] You need to export this data to a CSV file named 'customers_export.csv' with the following requirements: 1. The data should be exported in a specific order: 'Customer ID', 'Last Name', 'First Name', 'Email'. 2. The data should be delimited by a semicolon (;) instead of the default comma (,). 3. The 'Email' column should be enclosed in double quotes ("). Which of the following PROC EXPORT statements would achieve this correctly? (Select all that apply)
A.

B.

C.

D.

E.

正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You have a SAS data set named 'PRODUCTS' with variables 'ProductlD', 'ProductName', 'Price', and 'Category'. You need to create a new data set 'PRODUCT SALES' with only the products in the 'Electronics' category, and you want to include a new variable called 'TotalSales' calculated as 'Price 100' for each product. Which SAS code snippet achieves this?
A.

B.

C.

D.

E.

正解：E
解説: (Topexam メンバーにのみ表示されます)