Online Access Free A00-215 Exam Questions

You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', 'CITY', and 'STATE'. You need to sort the data in descending order of 'CITY' and then by 'STATE' in ascending order. Which PROC SORT statement will achieve this sorting?

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

You are tasked with importing a CSV file containing financial dat
a. The file has a header row, but some columns have missing values represented by empty strings. You want to import these missing values as SAS missing values (.) rather than empty strings. Which PROC IMPORT option would you use to achieve this?

• A.GUESSINGROWS=MAX
• B.OUT=dataset
• C.REPLACE-YES
• D.MISSING-YES
• E.DBMS=CSV

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?

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

You have a dataset with a variable 'Product' containing product names. You want to create a format that labels all product names starting with 'A' as 'Alpha Products', all product names starting with 'B' as 'Beta Products', and all other product names as 'Other Products'. Which PROC FORMAT code snippet achieves this?

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

You need to create a report that shows the average sales amount for each product in a dataset called 'SALES'. The report should include a header that states 'Average Sales by Product', and you want to suppress the observation numbers. You also want to ensure that the report is formatted with the average sales amount rounded to two decimal places. Which PROC PRINT statement with LABEL and NOOBS options would achieve this?

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