A00-215 Exam Question 26

You have three SAS data sets: 'CUSTOMERS', 'ORDERS', and 'PRODUCTS'. You want to combine them vertically to create a single dataset 'COMBINED DATA' where each observation represents either a customer, an order, or a product. How would you accomplish this using the SET statement?
  • A00-215 Exam Question 27

    You have a dataset 'CUSTOMER' with variables 'CUSTOMER ID', 'NAME', and 'STATE'. You need to sort the dataset based on 'STATE', but only for customers whose 'CUSTOMER ID' is greater than 1000. Which PROC SORT statement would achieve this?
  • A00-215 Exam Question 28

    You need to import a CSV file containing financial data into a SAS dataset. The file has a header row and uses a comma as the delimiter. Which code snippet correctly imports the data into a SAS dataset named "financial data"?
  • A00-215 Exam Question 29

    You have a dataset named 'Customer _ Data' with customer information, including their purchase history. You need to create a new dataset named 'Loyal_Customers' containing only customers who have made at least 5 purchases within the last year. Additionally, you need to retain only the CustomerlD and Total Purchases variables in the new dataset. Which code snippet correctly uses the OUTPUT statement to achieve this?
  • A00-215 Exam Question 30

    You have a SAS dataset 'CUSTOMERS' with variables 'CUSTOMER D', 'JOIN DATE' (numeric, date format), and 'LAST PURCHASE DATE' (numeric, date format). You need to create a new variable 'CUSTOMER AGE that calculates the number of days since the customer joined, and another variable 'DAYS SINCE LAST PURCHASE' that calculates the number of days since their last purchase. Which SAS code snippet correctly accomplishes this?