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

出題：1

Consider the following SAS code:

Which of the following statements are TRUE about the behavior of the PDV during the execution of the code? (Select all that apply)

A. The value of 'new_var' is assigned to the PDV only after the OUTPUT statement executes.

B. The PDV is populated with the values from the first observation of work.old_data when the SET statement is encountered.

C. The PDV is dynamically modified with the new_var value within the DO loop based on the IF condition.

D. The PDV is cleared after each observation is processed, and a new PDV is created for the subsequent observation.

E. The PDV contains all the variables from both work-old data and work. new data datasets.

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

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

出題：2

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

出題：3

Consider the following SAS code snippet. Which statements accurately describe the behavior of the PDV during the execution of this code?

A. The PDV is emptied after each observation is processed, and repopulated with the next observation from work.old_data.

B. The PDV contains all the variables from both work.old data and work. new data.

C. The PDV is initially populated with the values from the first observation of work.old_data.

D. The OUTPUT statement writes the current contents of the PDV to the work.new_data dataset only if the IF condition is TRUE

E. The value of new varl is calculated and stored in the PDV before the IF statement is evaluated.

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

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

出題：4

You have a dataset 'EMPLOYEES' with variables 'EMPLOYEE ID', 'DEPARTMENT', and 'SALARY'. You want to create a new dataset 'HIGHEST SALARY BY DEPT' that contains the highest salary for each department. However, you also need to create a variable called 'RANK' that indicates the rank of each employee's salary within their department, with the highest salary being ranked 1. Which of the following DATA step code snippets will achieve this correctly?

正解：C 解答を投票する

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

出題：5

You have a SAS dataset named 'ORDERS' with the following structure: Order ID,Customer ID,Order Date,T0tal Amount You need to export this data to a CSV file named 'orders_export.csv' with the following requirements: 1. The data should be sorted by 'Order Date' in ascending order. 2. The 'Order Date' column should be formatted as 'YYYY-MM-DD'. 3. The 'Total Amount' column should be formatted as a comma-separated numeric value with 2 decimal places. Which of the following PROC EXPORT statements would achieve this correctly?

正解：C 解答を投票する

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

出題：6

Your SAS program generates the following messages in the log:

Which of the following statements are true about this situation? Select all that apply.

A. The program encountered an error during data input

B. There is a logical error in the code that prevents data from being read.

C. The data set WORK.DATAI has data in it, but the program couldn't access it-

D. The data set WORKDATAI is empty

E. The program attempted to read from a data set named WORK. DATAI , but it doesn't exist.

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

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

出題：7

You have a dataset with a 'ProductStatus' variable containing values like 'Active', 'Inactive', 'Discontinued', or missing. You want to create a custom format to label missing values as 'Unknown' and combine 'Inactive' and 'Discontinued' as 'Not Active'. Which PROC FORMAT code snippet correctly defines this format?

正解：C 解答を投票する

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

出題：8

Which of the following SAS statements can be used to define a global macro variable that is accessible throughout the entire SAS session?

A. %global global_var = 'value',

B. %macro global_var; 0/01et global_var = 'value', %mend,

C. options global_var='value';

D. data _ null_; global_var = 'value'; run;

E. %let global_var = 'value',

正解：A 解答を投票する

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

出題：9

You are working with a SAS data set 'EMPLOYEES' and need to determine if any variables are defined as character variables, their lengths, and their formats. Which PROC CONTENTS options would you use to get this information? Select all that apply.

A. ALL

B. DATA-EMPLOYEE

C. OUT=OUTDS

D. FORMAT

E. NOPRINT

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

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

出題：10

You are analyzing a dataset containing sales data for different regions. You need to create a new variable 'SalesCategory' that classifies sales into three categories: 'High' if sales are above $10,000, 'Medium' if sales are between $5,000 and $10,000, and 'Low' if sales are below $5,000. Which code snippet correctly implements this logic in the DATA step?

正解：E 解答を投票する

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

出題：11

You have a dataset 'Transactions' with a variable 'TransactionDate' in a DATE format. You need to create a new variable 'DaysSinceLastTransaction' that calculates the number of days since the previous transaction for each record. Which SAS code snippet would correctly achieve this?

正解：C 解答を投票する

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

出題：12

You have a dataset with variables 'Region' and 'Sales'. You want to create a new variable 'TotalSales' that accumulates the sales for each region. Which code snippet would you use in the DATA step to achieve this?

正解：C 解答を投票する

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

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