SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 - A00-215 Exam Questions

QUESTION NO: 1
You have a SAS dataset 'PRODUCT SALES' with variables 'PRODUCT ID', 'SALES DATE', 'QUANTITY SOLD', and PRICE'. You need to create a new dataset 'MONTHLY SALES' that only includes observations where 'SALES DATE' falls within the month of June (regardless of year) and the 'PRICE' is greater than 100. Which code snippet would you use to achieve this?

QUESTION NO: 2
You have a SAS dataset called 'product _ info' with variables 'Product ID', 'Product Name', and 'Price'. You want to export this data to a CSV file called 'products.csv' but need to ensure that the data is exported in a specific order: Product _ Name, Product ID, and Price. Which PROC EXPORT statement correctly accomplishes this?

QUESTION NO: 3
You are tasked with generating a series of reports for different departments, each with its unique title and a consistent footer containing the report generation date. How can you achieve this using the TITLE statement effectively? Select all that apply.

QUESTION NO: 4
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.

QUESTION NO: 5
You have a dataset with a variable named 'SALES AMOUNT representing the sales value. You want to create a new variable 'SALES CATEGORY' that categorizes sales into 'Low', 'Medium', and 'High' based on the following criteria: Low: SALES AMOUNT < 1000 Medium: 1000 <= SALES AMOUNT < 5000 High: SALES AMOUNT >= 5000 Which of the following DATA step code segments will correctly accomplish this task?

QUESTION NO: 6
Which of the following SAS code snippets will result in a syntax error? Select all that apply.

QUESTION NO: 7
You need to import a CSV file containing financial data into a SAS dataset. The file has a header row and uses a comma as the delimiter. Which code snippet correctly imports the data into a SAS dataset named "financial data"?

QUESTION NO: 8
You have a dataset with a character variable 'PRODUCT ID' that stores product identifiers in the format 'ABC- 12345'. You need to create a new variable 'PRODUCT TYPE' that stores the first three characters of the 'PRODUCT_ID' variable. The 'PRODUCT TYPE' variable should have a length of 3 bytes. Additionally, if the 'PRODUCT ID' variable is missing, the 'PRODUCT TYPE' variable should be assigned the value 'N/A'. Which code snippet correctly creates the 'PRODUCT TYPE' variable?

QUESTION NO: 9
You are working with a dataset containing customer demographics. You want to create a custom format that labels missing values for the 'Age' variable as 'Unknown'. Which PROC FORMAT code snippet correctly defines the custom format using the keyword 'OTHER' for this scenario?

QUESTION NO: 10
You have a dataset named 'SALES' with variables 'ORDER D', 'PRODUCT ID', 'SALES DATE', 'QUANTITY, 'PRICE', 'DISCOUNT'. You want to create a new dataset named 'SALES SUMMARY' that contains only the orders placed in the month of January 2023, and includes the variables 'ORDER ID', 'PRODUCT ID', and 'TOTAL VALUE'. The 'TOTAL VALUE' is calculated as 'QUANTITY ' PRICE ' (1 - DISCOUNT)'. Which of the following DATA step code snippets would achieve this?

QUESTION NO: 11
You have a dataset 'SalesData' with variables 'Region', 'Product', 'Sales', and 'Discount'. You need to create a new variable 'SalesCategory' that classifies sales based on the following logic: 1. If 'Sales' is greater than 1000 and 'Discount' is greater than 0.1, then assign 'High Sales with Discount'. 2. If 'Sales' is greater than 1000 and 'Discount' is less than or equal to 0.1, then assign 'High Sales without Discount'. 3. If 'Sales' is less than or equal to 1000 and 'Discount' is greater than 0.1, then assign 'Low Sales with Discount'. 4. If 'Sales' is less than or equal to 1000 and 'Discount' is less than or equal to 0.1 , then assign 'Low Sales without Discount'. Which of the following DATA step code snippets will achieve this correctly?