SASInstitute A00-215 問題集

質問 1：
Which of the following statements about global SAS statements are true? (Select all that apply)
A. Global statements are executed before any other SAS program code.
B. Global statements are processed only once, regardless of how many times they are encountered in a SAS sessiom
C. Global statements are defined using the 'global' keyword.
D. Global statements are specific to the current SAS program and are not accessible from other programs within the same SAS session.
E. Global statements can be used to set options, define macro variables, and declare formats.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You have a SAS dataset called 'CUSTOMERS' with variables 'CustomerlD', 'Name', 'Address', 'City', 'State', 'Zip', 'Phone', and 'Email'. You need to create a new dataset called 'Customer Subset' containing only 'CustomerlD', 'Name', and 'Email' for customers residing in the state 'CA' and having a zip code starting with '902'. Which code snippet will achieve this correctly?
A.

B.

C.

D.

E.

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

質問 3：
You are working on a SAS program that uses a macro to perform a specific task. The macro runs without errors, but the results are not as expected. You suspect that there might be a logic error in the macro. Which of the following steps would be most helpful in identifying and resolving the logic error?
A. Run the macro in debug mode and step through each line of code.
B. Use the %PUT statement to print the values of macro variables at different stages of the macro execution.
C. Check the macro definition for any typos or missing statements.
D. Use the %SYSEVALF function to evaluate expressions within the macro.
E. Examine the log for any error messages.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You have a dataset named 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You need to sort the data first by 'REGION' in ascending order and then by 'PRODUCT' in descending order, creating a new dataset named 'SORTED SALES'. Which PROC SORT statement would achieve this?
A.

B.

C.

D.

E.

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

質問 5：
You have a SAS dataset named 'customer info' that contains detailed customer information. You need to export this data to an Excel file with specific formatting, including column widths, data types, and header labels. Which of the following code snippets correctly utilizes the LIBNAME statement and XLSX engine to achieve this objective?
A.

B.

C.

D.

E.

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

質問 6：
You are tasked with importing a CSV file containing customer data into SAS. The file has a header row and is separated by commas. The data includes a column named 'Date' which represents the date of purchase in the format YYYY-MM-DD. How would you import the file and convert the 'Date' column to a SAS date format? ' 'NOTE:'' The CSV file is named 'customer_data.csv' and is located in the directory 'C:\data\'.
A.

B.

C.

D.

E.

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

質問 7：
You have a CSV file named 'customer_data.csv' containing customer information. You need to import this data into a SAS dataset, selecting only specific columns and filtering based on a condition. Which code snippet correctly imports the data, performs the selection, and applies the filter?
A.

B.

C.

D.

E.

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

質問 8：
You have a SAS dataset named 'SALES' with variables 'REGION', 'PRODUCT', 'SALES AMOUNT', and 'SALES DATE'. You need to create a new dataset called 'REGIONAL SALES' that only includes the 'REGION' and 'SALES AMOUNT' variables for sales that occurred in the year 2023. Which code snippet will correctly achieve this?
A.

B.

C.

D.

E.

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