A00-215 Exam Question 71
You have a dataset with a variable called 'PRODUCT ID' containing numeric values. You want to create a new variable called 'PRODUCT CATEGORY' based on the following logic: ' If 'PRODUCT_ID' is between 100 and 200, then 'PRODUCT CATEGORY' should be 'Electronics'. ' If 'PRODUCT is between 201 and 300, then 'PRODUCT CATEGORY' should be 'Clothing'. ' If 'PRODUCT ID' is outside these ranges, then 'PRODUCT CATEGORY' should be 'Other'. Which of the following SAS code snippets will correctly implement this logic?
A00-215 Exam Question 72
You have a dataset with a variable 'START DATE' representing the start date ofa project. You want to create a new variable 'END DATE' which is set to the 1st of the month following 'START DATE'. Which code snippet correctly calculates 'END DATE'?
A00-215 Exam Question 73
You have a dataset named 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You need to sort the data first by 'REGION' in ascending order and then by 'PRODUCT' in descending order, creating a new dataset named 'SORTED SALES'. Which PROC SORT statement would achieve this?
A00-215 Exam Question 74
You are generating a report using PROC REPORT with multiple columns. You want to add a title to the report that spans across all the columns. Which of the following TITLE statement options will achieve this?
A00-215 Exam Question 75
You have a dataset 'EMPLOYEES' with variables 'EMP ID', 'FIRST NAME', 'LAST NAME', 'SALARY', and 'DEPARTMENT'. You need to create a report that displays 'EMP D', 'FIRST NAME', 'LAST NAME', and 'SALARY' for employees in the 'Marketing' department. Additionally, you want to display a calculated variable 'ANNUAL SALARY' representing the employee's salary multiplied by 12. Which PROC PRINT statement accomplishes this?