A00-215試験無料問題集（390題）「SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 認定」

出題：1

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 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

You have a dataset 'ORDERS' with variables: 'Order ID', 'Product', 'Quantity', 'Price', 'Customer_lD', 'Order Date'. You want to create a new dataset 'ORDER SUMMARY' that includes only the variables 'Product', 'Quantity', and 'Price' for orders placed in 2022. Additionally, you need to create a new variable named 'Total_Value' which is the product of 'Quantity' and 'Price'. Which code snippet achieves this correctly?

正解：C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

You are generating a report using PROC REPORT and want to add a footnote at the bottom of each page that explains the data source. Which of the following FOOTNOTE statement options is most appropriate for achieving this?

A. FOOTNOTE / AT PAGE 'This report is based on data from the Sales database: 1;

B. FOOTNOTE 'This report is based on data from the Sales database: / AT PAGE 1;

C. FOOTNOTE 'This report is based on data from the Sales database.';

D. FOOTNOTE / 'This report is based on data from the Sales database.' /;

E. FOOTNOTE AT PAGE / 'This report is based on data from the Sales database: 1;

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You are analyzing a SAS dataset named 'CUSTOMER DATA' with several variables including 'CUSTOMER ID', 'NAME', 'AGE', 'CITY', and 'INCOME'. You want to create a new variable called 'INCOME GROUP based on the 'INCOME' variable, where 'INCOME GROUP is a character variable with values 'LOW', 'MEDIUM', and 'HIGH' based on income ranges. Which of the following SAS code snippets correctly defines the 'INCOME GROUP' variable with the desired character values?

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Consider two datasets, 'EMPLOYEES' and 'DEPARTMENTS', both containing a 'DEPARTMENT ID' variable. You want to combine these datasets horizontally, but only for employees in 'EMPLOYEES' whose 'HIRE DATE' is before 01JAN2010. How would you modify the MERGE statement to include this condition?

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

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. Logic error; use PUTLOG to print the line number and the contents of the problematic statement.

B. Logic error; use PUTLOG to print the value of variables involved in the calculation.

C. Logic error; use PUTLOG to print the contents of the input CSV file.

D. Syntax error; use PUTLOG to print the entire SAS program's code.

E. Syntax error; use PUTLOG to print the line number of the statement causing the error.

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

In a DATA step, a programmer uses a 'retain' statement to initialize a variable to a specific value. When does the 'retain' statement take effect during the execution of the DATA step? Choose the most accurate statement.

A. The 'retain' statement takes effect at the beginning of each iteration of the DATA step, before processing each observation.

B. The ' retain' statement takes effect only at the end of the first iteration of the DATA step, after the first observation is processed.

C. The 'retain' statement takes effect only at the end of the last iteration of the DATA step, after all observations have been processed.

D. The 'retain' statement takes effect only at the beginning of the first iteration of the DATA step, before any input from the input dataset.

E. The 'retain' statement takes effect throughout the DATA step, both at the beginning and the end of each iteration.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

You have a SAS dataset named 'SALES' with a variable 'ORDER DATE' representing the order date in a numeric date format. You need to create a new variable 'MONTH NAME' that displays the full month name corresponding to the 'ORDER DATE'. Which SAS code snippet achieves this?

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

You have a dataset named 'CUSTOMERS' containing customer information. You need to create a sorted dataset named 'CUSTOMERS SORTED' based on the 'STATE' variable, but only for customers who are 'Active'. Which PROC SORT statement achieves this?

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

You have a dataset named 'ORDERS' with variables 'ORDER ID', 'CUSTOMER ID', 'ORDER DATE', and 'PRODUCT ID'. You need to sort the dataset based on 'ORDER DATE' in descending order, but only for orders where 'PRODUCT ID' is either 'A 123' or 'B456'. You also need to create a new dataset named 'SORTED ORDERS' containing the sorted dat a. Which PROC SORT statements would achieve this? (Select all that apply)

正解：A,B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

You are analyzing survey data where respondents were asked to rate their satisfaction with a product on a scale of 1 to 5. You want to create a two-way table that shows the frequency distribution of satisfaction ratings by gender. You also want to include the row percentages for each satisfaction rating within each gender category. Which of the following PROC FREQ statements would achieve this?

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：12

You have a dataset with a variable 'AMOUNT' containing numeric values with decimals. You need to create a new variable 'ROUNDED AMOUNT' by rounding the 'AMOUNT' values to the nearest hundredth using the ROUND function. Which code snippet achieves this correctly?

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：13

You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', 'CITY', and 'STATE'. You want to create a new dataset 'NEW CUSTOMERS' containing only observations from the 'CUSTOMERS' dataset where the 'STATE' is either 'CA' or 'NY'. You also want to add a new variable called 'REGION' to the 'NEW CUSTOMERS dataset, assigning 'West' for CA customers and 'East' for NY customers. Which of the following DATA step code snippets will achieve this?

正解：B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：14

You are reviewing a SAS program that generates a report. The log contains the following messages:

Based on these log messages, what can you conclude about the report generated by the program?

A. The report contains 5 columns and 20 rows.

B. The report contains 20 columns and 5 rows.

C. The report is paginated, but the number of observations displayed per page is not specified.

D. The report consists of 20 pages, each page displaying data for 1 observation_

E. The report contains 20 pages, each page displaying data for all 20 observations.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

A00-215試験無料問題集「SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 認定」