A00-215 Exam Question 31
You have a dataset named 'SurveyResponses' containing responses to a survey about customer satisfaction. The dataset includes variables 'Product' (character), 'Rating' (numeric), and 'Comments' (character). You need to generate a two-way frequency table showing the distribution of 'Rating' by 'Product' and also calculate the chi- square statistic to determine if there is a significant association between 'Rating' and 'Product'. Which of the following code snippets would achieve this task?
A00-215 Exam Question 32
You have a dataset containing product information, including a variable named 'Category' with values such as 'Electronics', 'Clothing', 'Food', and 'Furniture'. You want to create a report that displays the total sales for each category, but you want to group 'Food' and 'Furniture' together under a new label 'Home & Living'. Which approach would you use?
A00-215 Exam Question 33
You have a dataset with a variable named 'REGION' containing numeric values representing different geographical regions. You need to display these regions in a report using meaningful labels like 'North America', 'Europe', etc. Which code snippet correctly defines a custom format using PROC FORMAT to achieve this?
A00-215 Exam Question 34
You have a dataset with a variable 'PRICE' containing values like 12.99, 25.50, 18.75. You want to round these values down to the nearest dollar amount (e.g., 12.99 becomes 12). Which SAS function would you use?
A00-215 Exam Question 35
A dataset has a variable 'AGE' containing values like 25.3, 31.7, 42.1. You need to truncate these values to the nearest whole number, discarding any fractional part. Which SAS code snippet accomplishes this correctly?
