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

出題：1

Which of the following statements is TRUE regarding the creation of the PDV?

A. The PDV is created when a SAS data set is first read into the DATA step.

B. The PDV is created at the start of the DATA step execution and remains throughout the entire execution.

C. The PDV is dynamically created and modified as the DATA step reads observations and performs operations.

D. The PDV is created at the time of the first SET statement in the DATA step.

E. The PDV is created at the time of the first OUTPUT statement in the DATA step.

正解：C 解答を投票する

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

出題：2

Consider the following SAS code:

What is the correct syntax to refer to the variable 'calculated _ age' in the 'proc print' step to display its values?

正解：E 解答を投票する

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

出題：3

You have a dataset 'PRODUCTS with variables 'PRODUCT ID', 'PRICE', and 'QUANTITY SOLD'. You need to calculate the total revenue for each product, then find the product with the highest revenue, and output its product ID and revenue. Which code snippet achieves this correctly?

正解：A 解答を投票する

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

出題：4

You have a SAS dataset with a variable 'DATE VALUE representing a date value stored as a numeric value. Which of the following options are valid ways to convert the 'DATE VALUE' variable to a SAS date format 'Y YYY- MM-DD'?

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

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

出題：5

You have a SAS dataset named 'SALES' with a variable 'REGION' that contains region codes. You want to generate a report that displays the region codes as 'East Coast', 'West Coast', 'Midwest', and 'South' based on their corresponding numeric values. Which code snippet correctly uses the LABEL statement to achieve this?

正解：D 解答を投票する

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

出題：6

You have a dataset with customer orders, and you need to analyze the order frequency of each customer. You decide to use PROC SORT to group orders by customer ID and then count the number of orders per customer. What additional step is required to make it easier to count the number of orders per customer after sorting?

A. Use a DATA step after PROC SORT to create a new variable that counts the number of orders per customer.

B. Use the NODUPKEY option in PROC SORT

C. Use the OUT= option in PROC SORT to create a new dataset

D. Use the FIRSTOBS= option in PROC SORT to start counting from the first order.

E. Use the BY statement in PROC SORT with the DESCENDING option

正解：B 解答を投票する

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

出題：7

You have a dataset named 'SALES' with 'PRODUCT ID', 'SALES DATE', and 'QUANTITY SOLD' variables. You need to create a new dataset that summarizes the total quantity of each product sold in the last two weeks. How would you use the IN= option and a temporary dataset to achieve this?

正解：D 解答を投票する

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

出題：8

You have two SAS data sets, 'SALES' and 'ORDERS', both stored in the same library named 'SALES DATA. You need to combine the data from these two data sets into a new data set called 'SALES ORDERS' using the 'SET' statement. Which of the following statements will correctly combine the data from both 'SALES' and 'ORDERS' data sets into the new data set?

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

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

出題：9

You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', and 'CITY'. You want to create a new dataset 'NEW CUSTOMERS' containing only the records where the 'CITY' variable is missing (missing value). Additionally, you want to add a new variable named 'STATUS' with a default value 'NEW' for all observations in the 'NEW CUSTOMERS' dataset. Which SAS code snippet would achieve this?

正解：A 解答を投票する

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

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