SASInstitute A00-215 問題集

質問 1：
You are tasked with analyzing a dataset where the date variable 'TransactionDate' is stored as a numeric value representing the number of days since January 1, 1960. You need to display the date in the format 'MMDDYYI 0.' Which SAS code snippet accomplishes this task correctly?
A.

B.

C.

D.

E.

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

質問 2：
You have a SAS dataset named 'PRODUCTS' with variables 'PRODUCT ID', 'PRICE', and 'QUANTITY'. You want to generate a report with a column named 'Unit Cost' that calculates the product of 'PRICE and 'QUANTITY' and then use a label for the calculated column. Which code snippet correctly uses the LABEL statement to achieve this?
A.

B.

C.

D.

E.

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

質問 3：
You have two datasets, 'ORDERS' and 'PRODUCTS', both containing a variable 'PRODUCT ID'. You need to create a dataset 'ORDER SUMMARY that shows the total quantity ordered for each product, using the MERGE statement. Which of the following options correctly performs this task?
A.

B.

C.

D.

E.

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

質問 4：
You have a dataset with a variable called 'DateOfBirth' in the format 'MMDDYY'. You need to create a new variable 'Age' that calculates the patient's age in years based on today's date. Which code snippet correctly calculates the age and handles leap years accurately?
A.

B.

C.

D.

E.

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

質問 5：
You are analyzing a dataset 'SALES' containing 'PRODUCT', 'QUANTITY', and 'PRICE' variables. You want to create a new dataset 'HIGH SALES' containing only products with a total sales value (QUANTITY ' PRICE) greater than 1000. Which WHERE statement should you use?
A. WHERE SUM(QUANTITY ' PRICE) > 1000;
B. WHERE QUANTITY ' PRICE > 1000;
C. WHERE TOTAL_SALES > 1000; Assuming TOTAL_SALES is a calculated variable
D. WHERE (QUANTITY ' PRICE) > 1000;
E. WHERE SUM(QUANTITY ' PRICE) > 1000;
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You have a SAS dataset called 'SALES' with variables: 'Region', 'Product', 'Sales_Amount', 'Date', 'CustomerlD'. You need to create a new dataset called 'SALES SUMMARY' that contains only the variables 'Region', 'Product', and 'Sales_Amount' for observations where 'Sales_Amount' is greater than 1000. Which code snippet correctly achieves this?
A.

B.

C.

D.

E.

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

質問 7：
You have a CSV file named 'sales_data.csv' with a header row containing the following columns: 'customer_id', 'product_name', 'purchase_date', 'quantity', 'price'. You want to import this file into a SAS dataset named 'SALES' with the following data types: 'customer_id' as a numeric variable, 'product_name' as a character variable of length 50, 'purchase date' as a date variable, 'quantity' as a numeric variable, and 'price' as a numeric variable. Which PROC IMPORT statement correctly achieves this?
A.

B.

C.

D.

E.

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

質問 8：
You're working with a SAS program that includes a macro. The SAS log shows the following message:
What is the most likely reason for this warning, and how would you resolve it?
A. The macro variable &SIJM is not defined within the macro.
B. The macro is called before the variable SUM is created-
C. The macro variable &SIJM is not used within the macro.
D. The macro is called with a missing parameter
E. The macro variable &SIJM is used before it is defined in the current session.
正解：A
解説: (Topexam メンバーにのみ表示されます)