最新なSASInstitute A00-215問題集（390題）、真実試験の問題を全部にカバー！

質問 1：
You have a dataset with customer information, including their purchase history. You need to identify the top 10 customers with the highest total purchase amount and display their information in descending order of their total purchase amount. Which code snippet correctly uses PROC SORT to achieve this? (Assume you have a variable named 'TotalPurchaseAmount' in our dataset)
A.

B.

C.

D.

E.

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

質問 2：
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. Check the macro definition for any typos or missing statements.
C. Use the %SYSEVALF function to evaluate expressions within the macro.
D. Examine the log for any error messages.
E. Use the %PUT statement to print the values of macro variables at different stages of the macro execution.
正解：A,E
解説: (Pass4Test メンバーにのみ表示されます)

質問 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.

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

質問 4：
You are working with a dataset containing a variable 'START DATE' that stores dates in the format 'YYYY-MM- DD'. You need to create a new variable 'DAYS SINCE START' that calculates the number of days since the start date for each record. Which SAS code snippet correctly achieves this?
A.

B.

C.

D.

E.

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

質問 5：
You have a dataset with a variable 'SalesAmount' representing the sales revenue for each customer. You want to assign a descriptive label to each 'SalesAmount' based on its value: 'Low' for values below $1000, 'Medium' for values between $1000 and $5000, and 'High' for values above $5000. How would you accomplish this using the FORMAT statement?
A.

B.

C.

D.
E.

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

質問 6：
You have a dataset with a variable 'STATUS' containing values 'Active', 'Inactive', 'Pending'. You want to create a custom format 'statusfmt' to display these values as 'A', 'P' respectively, but also handle any unknown values as 'U'. Which PROC FORMAT code achieves this?
A.

B.

C.

D.

E.

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