SASInstitute A00-215 問題集

質問 1：
You need to create a report with PROC REPORT where the footnote is displayed at the bottom of each page, instead of the bottom of the entire report. Which option(s) can be used to achieve this?
A.

B.

C.

D.

E.

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

質問 2：
You have an Excel file named 'sales_data.xlsx' with multiple sheets. You want to import data from the sheet named 'QI _ Sales' into a SAS dataset. Which LIBNAME statement should you use to achieve this?
A.

B.

C.

D.

E.

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

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

質問 4：
You want to permanently assign a label to a variable named 'Revenue' to improve the clarity of output reports. Which of the following options correctly uses the 'ATTR' statement to achieve this? Assume you have created a new variable named 'Revenue' with values.
A.

B.

C.

D.

E.

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

質問 5：
You have a dataset 'CustomerData' containing 'CustomerlD', 'Age', 'Income', 'PurchaseAmount', and 'PurchaseDate'. You want to analyze the average purchase amount for customers in different age groups. You need to group customers based on their age into three categories: 'Young' (18-30), 'Middle-Aged' (31-50), and 'Senior' (51+). Which code snippet would you use to correctly group customers and calculate the average purchase amount for each age group using PROC MEANS?
A.

B.

C.

D.

E.

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

質問 6：
You are working with a SAS report generated using ODS. You need to export this report to both PDF and RTF formats. The RTF file should be named 'report.rtf' and the PDF file should be named 'report.pdf. Which of the following code snippets correctly achieves this?
A.

B.

C.

D.

E.

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

質問 7：
You are working with a dataset named 'work.customer' that contains a variable called 'age' representing the age of customers. You want to create a new variable 'age_group' based on the following criteria: 'age_group' = Young' if 'age' is less than 30 'age_group' = 'Middle' if 'age' is between 30 and 50 (inclusive) 'age_group' = 'Senior' if 'age' is greater than 50 Which SAS code snippet correctly creates the 'age_group' variable?
A.

B.

C.

D.

E.

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

質問 8：
You have a dataset named 'SALES' with variables 'Region', 'Product', and 'Quantity'. You want to create a new variable 'SalesValue' based on the following logic: If 'Product' is 'A', then 'SalesValue' = 'Quantity' , 10; If 'Product' is 'B', then 'SalesValue' = 'Quantity' , 15; Otherwise, 'SalesValue' = 'Quantity' , 20. Which code snippet correctly implements this logic in the DATA step?
A.

B.

C.

D.

E.

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