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

質問 1：
Consider the following SAS code:

What is the purpose of the statement options nodate nonumber;?
A. It specifies the output format for the printed data.
B. It prevents the creation of the output dataset.
C. It changes the default input delimiter.
D. It alters the default data type for the variables.
E. It suppresses the printing of the date and time in the log.
正解：E
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
You have a dataset containing sales data for different products across various regions. You need to calculate the total sales for each product within each region, but only for the first three sales transactions for each product within each region. How would you achieve this using the DATA step, incorporating the FIRST. and LAST. variables within BY group processing?
A. data sales_summary; set sales; by product region; if first-product then if _N <= 3 then output; run;
B. data sales_summary; set sales; by product region; if first.region then if first.product then if _N_ <= 3 then total sales+sales amount; run;
C. data sales_summary; set sales; by product region; if first.product then if _N_ <= 3 then total_sales+sales_amount; run;
D. data sales_summary; set sales; by product region; retain total_sales 0; if first-product then if _N_ <= 3 then total sales+sales amount; run;
E. data sales_summary; set sales; by product region; if first-region then if first.product then if _N_ <= 3 then total sales-sales amount; run;
正解：E
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
You are working with a dataset containing customer addresses. You need to ensure that the addresses are stored in a way that avoids unnecessary whitespace. Which of the following code snippets correctly uses the LENGTH statement to achieve this, taking into consideration the removal of leading and trailing whitespaces?
A.

B.

C.

D.

E.

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

質問 4：
You are tasked with creating a report that displays the sales figures for different products. The sales data is stored in a dataset named 'SALES' with variables 'Product', 'Quantity', and 'Price'. You want to create a new variable called 'SalesValue' by multiplying 'Quantity' and 'Price', and then present the 'SalesValue' in a formatted way using the following conditions: - For 'SalesValue' less than 100, display the value with a '$' prefix and two decimal places. - For 'SalesValue' between 100 and 1000, display the value with a 'K' suffix and one decimal place. - For 'SalesValue' greater than 1000, display the value with an 'M' suffix and no decimal places. Which of the following code snippets correctly implements the required formatting using the FORMAT statement for temporary attributes?
A.

B.

C.

D.

E.

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

質問 5：
You have a SAS dataset called 'SALES' with the following variables: 'PRODUCT', 'SALES AMOUNT', 'SALES DATE'. You need to create a new dataset called 'SALES SUMMARY that only contains the 'PRODUCT' and 'SALES AMOUNT' variables, and filter the data to include only sales from the year 2023. Which of the following SAS code snippets would correctly accomplish this?
A.

B.

C.

D.

E.

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

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