A00-215 Exam Question 36

You have a dataset with customer information, including their purchase history. You need to identify the top 10 customers with the highest total purchase amount and display their information in descending order of their total purchase amount. Which code snippet correctly uses PROC SORT to achieve this? (Assume you have a variable named 'TotalPurchaseAmount' in our dataset)
  • A00-215 Exam Question 37

    Which step reads the SASHELP. BASEBALL data set and creates the temporary data set CATCHERS?
  • A00-215 Exam Question 38

    You have a SAS dataset named 'CUSTOMERS' with variables 'CUSTOMER ID', 'NAME', 'AGE', 'CITY', 'STATE', 'ZIPCODE'. You want to create a new dataset named 'CUSTOMERS SELECTED' containing only the 'CUSTOMER ID', 'NAME', and 'CITY' variables from 'CUSTOMERS'. Which code snippet correctly achieves this using the KEEP= option?
  • A00-215 Exam Question 39

    You have a SAS dataset named 'CustomerData' located in the '/home/datasets/' directory, and you want to create a new library called 'CUSTOMER' to access it. You also want to specify that the dataset is located on a Unix server using the 'SERVER' option. Additionally, you want to use a specific SAS session user, 'adminuser', and password, 'password 1 23', for accessing the dataset. Which LIBNAME statement is correct for this scenario?
  • A00-215 Exam Question 40

    You have a SAS dataset named 'CUSTOMERS' with variables 'CustomerlD', 'Name', 'Address', and 'City'. You want to create a new dataset 'CUSTOMERS CITY' that contains only unique city names from the 'CUSTOMERS' dataset. Which SAS code snippet correctly performs this task?