A00-215 Exam Question 86
You have a dataset 'sales_data' with variables 'Region', 'Product', and 'Sales'. You want to create a frequencyreport that displays the frequency counts for each region and product combination, but you only want to see the counts for those combinations where the sales value is greater than $10,000. How would you modify the PROC FREQ statement to achieve this?
A00-215 Exam Question 87
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?
A00-215 Exam Question 88
You have a dataset 'CustomerData' containing 'CustomerlD', 'Age', 'Income', 'PurchaseAmount', and 'PurchaseDate'. You want to analyze the average purchase amount for customers in different age groups. You need to group customers based on their age into three categories: 'Young' (18-30), 'Middle-Aged' (31-50), and 'Senior' (51+). Which code snippet would you use to correctly group customers and calculate the average purchase amount for each age group using PROC MEANS?
A00-215 Exam Question 89
You are creating a report using PROC PRINT that displays customer demographics and purchase history. You want to include a title that dynamically updates with the current date and time. Which of the following code snippets correctly utilizes the TITLE statement to achieve this?
A00-215 Exam Question 90
You have a SAS dataset named 'ORDERS' with the following structure: Order ID,Customer ID,Order Date,T0tal Amount You need to export this data to a CSV file named 'orders_export.csv' with the following requirements: 1. The data should be sorted by 'Order Date' in ascending order. 2. The 'Order Date' column should be formatted as 'YYYY-MM-DD'. 3. The 'Total Amount' column should be formatted as a comma-separated numeric value with 2 decimal places. Which of the following PROC EXPORT statements would achieve this correctly?