最新的SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 - A00-215免費考試真題

You have three datasets: 'ORDERS', 'CUSTOMERS', and 'PRODUCTS', all sharing the same 'CUSTOMER ID' and 'PRODUCT ID' variables. You need to create a combined dataset with customer information and product details for every order in 'ORDERS'. What is the correct sequence of MERGE statements to achieve this?

You are analyzing a dataset containing customer purchase dat
a. You need to create a frequency report that shows the number of customers who made purchases in each month. You need to suppress the cumulative frequencies and percentages, but you want to see the percentage of customers who purchased in each month relative to the total number of customers. Which PROC FREQ statement achieves this?

You are tasked with generating a report with PROC REPORT that includes a footnote explaining the source of the dat a. How can you add the footnote using the FOOTNOTE statement?

You are analyzing a dataset 'CustomerSurvey' with variables 'AgeGroup', 'Satisfaction', and 'Gender'. You need to create a two-way table showing the distribution of 'Satisfaction' across different 'AgeGroup's. However, you only want to include customers whose 'Gender' is 'Female'. Which PROC FREQ statement, with the CROSSLIST option, correctly produces this table?

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?

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?

You have a dataset named 'CUSTOMERS' containing customer information. You need to create a sorted dataset named 'CUSTOMERS SORTED' based on the 'STATE' variable, but only for customers who are 'Active'. Which PROC SORT statement achieves this?

Consider a dataset 'Sales' with variables 'Region', 'Product', and 'Sales_Amount'. You need to create a new dataset 'Summary' that reports the total sales for each region and product combination, but only for regions where the total sales exceed $10,000. Which SAS code would you use to achieve this?

You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'ORDER DATE', and 'ORDER AMOUNT'. You need to calculate the total order amount for each customer and then calculate the average order amount across all customers. Which code snippet achieves this correctly?

You have a SAS dataset named 'PRODUCTS' with variables 'PRODUCT ID', 'PRICE', and 'QUANTITY'. You want to generate a report with a column named 'Unit Cost' that calculates the product of 'PRICE and 'QUANTITY' and then use a label for the calculated column. Which code snippet correctly uses the LABEL statement to achieve this?

You have a dataset 'Sales' with variables 'Region', 'Product', and 'Quantity'. You want to create a two-way frequency table showing the distribution of 'Product' across different 'Region's. Which PROC FREQ statement with the CROSSLIST option correctly produces this table, where the rows represent 'Region' and columns represent 'Product'?

You have a dataset with a variable 'AMOUNT' containing numeric values with decimals. You need to create a new variable 'ROUNDED AMOUNT' by rounding the 'AMOUNT' values to the nearest hundredth using the ROUND function. Which code snippet achieves this correctly?