Online Access Free A00-215 Practice Test

You are running a SAS program that reads data from a file and performs calculations. The following error message appears in the SAS log:

Which of the following is the most likely cause of this error, and where would you look in your code to find the issue?

• A.A missing comma separating variables in the INPUT statement
• B.An incorrect variable name in the INPUT statement
• C.A missing quotation mark in a character variable assignment.
• D.A missing closing parenthesis in a function call.
• E.A missing semicolon at the end of a statement within the DATA step.

You have a SAS dataset 'CUSTOMERS' with variables 'CUSTOMER D', 'JOIN DATE' (numeric, date format), and 'LAST PURCHASE DATE' (numeric, date format). You need to create a new variable 'CUSTOMER AGE that calculates the number of days since the customer joined, and another variable 'DAYS SINCE LAST PURCHASE' that calculates the number of days since their last purchase. Which SAS code snippet correctly accomplishes this?

• A.
• B.
• C.
• D.
• E.

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.
• B.
• C.
• D.
• E.

You have a SAS dataset named 'CUSTOMERS' with variables 'CustomerlD', 'Name', 'Address', and 'City'. You want to create a new dataset 'CUSTOMERS CITY' that contains only unique city names from the 'CUSTOMERS' dataset. Which SAS code snippet correctly performs this task?

• A.
• B.
• C.
• D.
• E.

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.
• B.
• C.
• D.
• E.