A00-215 Exam Question 126
You have a dataset with customer demographics and sales dat
a. You want to calculate the average customer age and average purchase amount, displaying both to one decimal place. Which PROC MEANS statement would achieve this with the MAXDEC= option?
a. You want to calculate the average customer age and average purchase amount, displaying both to one decimal place. Which PROC MEANS statement would achieve this with the MAXDEC= option?
A00-215 Exam Question 127
You have a dataset 'sales data' with variables 'Product', 'Quantity', and 'Price'. You want to calculate the total revenue for each product and create a new dataset 'revenue_data' with variables 'Product' and 'TotalRevenue'. You need to use the 'SUM' function within a DO loop. Which SAS code snippet correctly accomplishes this?
A00-215 Exam Question 128
Consider the following SAS code:

In the output of the PROC PRINT, how will the missing value in the 'age' variable for Jane be represented?

In the output of the PROC PRINT, how will the missing value in the 'age' variable for Jane be represented?
A00-215 Exam Question 129
You are working with a SAS dataset 'SALES' containing sales data for different products. The dataset has variables 'PRODUCT ID', 'SALES DATE', 'SALES AMOUNT', and 'REGION'. You need to create a new dataset named 'SALES QI' that includes only sales records for the first quarter (January, February, March) of the year and renames the 'SALES DATE' variable to 'SALES DATE QI'. Which code snippet correctly achieves this?
A00-215 Exam Question 130
You have a dataset with a variable 'SALES' containing sales values. You need to create a new variable 'SALES CATEGORY' that categorizes sales as follows: - 'High' if SALES is greater than or equal to 10000 - 'Medium' if SALES is greater than or equal to 5000 but less than 10000 - 'Low' if SALES is less than 5000 Which code snippet correctly achieves this using the INT function?
