A00-215 Exam Question 16

You want to examine the relationship between customer satisfaction (Satisfied, Neutral, Dissatisfied) and product category (Electronics, Clothing, Home Appliances) using a two-way table. You also want to calculate the chi- square statistic to assess the independence of these variables. Which PROC FREQ statement would accomplish?
  • A00-215 Exam Question 17

    You have a dataset 'SALES' with variables 'PRODUCT ID', 'SALES DATE', and 'QUANTITY SOLD'. You want to create two new datasets: 'SALES BY PRODUCT and 'SALES BY MONTH'. 'SALES BY PRODUCT' should contain the total quantity sold for each product, and 'SALES BY MONTH' should contain the total quantity sold for each month. Which of the following DATA step code snippets will achieve this correctly?
  • A00-215 Exam Question 18

    You have a dataset called 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You want to calculate the average sales amount for each region, but only for products with a sales amount greater than 1000. Which SAS code snippet would accomplish this?
  • A00-215 Exam Question 19

    You have a dataset 'CUSTOMER' with variables 'CustomerlD', 'Name', and 'City'. You want to create a new variable 'Region' based on the 'City' variable using the following rules: If 'City' starts with 'New', then 'Region' = 'Northeast'; If 'City' is 'Los Angeles', then 'Region' = 'West'; otherwise, 'Region' = 'Other'. Which code snippet correctly implements this logic in the DATA step?
  • A00-215 Exam Question 20

    You are analyzing a SAS dataset called 'EMPLOYEE DATA' containing information about employees. You want to check if the 'SALARY' variable has a defined format. Which of the following PROC CONTENTS options will help you determine this?