SASInstitute A00-215 問題集

質問 1：
You're working with a dataset containing student records. You need to generate a report that shows the average grade for each student, but only for students who have taken at least two courses. Utilize the OUTPUT statement to control output timing and ensure only students with enough courses are included in the report. Which code snippet correctly implements this?
A.

B.

C.

D.

E.

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

質問 2：
You have a dataset 'SALES' with variables 'REGION', 'PRODUCT, and 'SALES AMOUNT'. You need to create a report that displays the top 5 regions with the highest total sales amount. Which PROC SORT statement will correctly sort the data in descending order of total sales amount for each region before generating the report?
A.

B.

C.

D.

E.

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

質問 3：
You have a dataset 'sales data' with variables 'Product', 'Quantity', and 'Price'. You want to calculate the total revenue for each product and create a new dataset 'revenue_data' with variables 'Product' and 'TotalRevenue'. You need to use the 'SUM' function within a DO loop. Which SAS code snippet correctly accomplishes this?
A.

B.

C.

D.

E.

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

質問 4：
You are tasked with developing a SAS program to analyze customer demographics. The program reads data from a CSV file and performs several calculations. You compile the program and encounter the following error message: ' 'ERROR 180-322: Statement is not valid or it is used out of context. '' What type of error is this, and what specific aspect of the PUTLOG statement would be most helpful in resolving this issue?
A. Syntax error; use PUTLOG to print the line number of the statement causing the error.
B. Logic error; use PUTLOG to print the contents of the input CSV file.
C. Logic error; use PUTLOG to print the value of variables involved in the calculation.
D. Logic error; use PUTLOG to print the line number and the contents of the problematic statement.
E. Syntax error; use PUTLOG to print the entire SAS program's code.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You are analyzing a dataset 'Products' with variables 'Product_Type' and 'Sales _ Amount'. You need to generate a frequency report for 'Product_Type' and include the 'Sales_Amount' sum for each type. Additionally, the report should display the product types in ascending order based on their sales amount. Which PROC FREQ statement accomplishes this?
A.

B.

C.

D.

E.

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

質問 6：
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 メンバーにのみ表示されます)

質問 7：
You are working with a dataset containing sales transactions. You need to create a summary table that shows the total sales for each quarter of the year. Which code snippet would you use to achieve this, incorporating the OUTPUT statement to control output timing?
A.

B.

C.

D.

E.

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

質問 8：
You have a dataset with a variable 'Product' containing product names. You want to create a format that labels all product names starting with 'A' as 'Alpha Products', all product names starting with 'B' as 'Beta Products', and all other product names as 'Other Products'. Which PROC FORMAT code snippet achieves this?
A.

B.

C.

D.

E.

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