A00-215 Exam Question 166

You have a dataset named 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You need to sort the data first by 'REGION' in ascending order, then by 'PRODUCT' in descending order, and finally by 'SALES AMOUNT' in ascending order. Which PROC SORT statement achieves this?
  • A00-215 Exam Question 167

    You have a dataset named 'CUSTOMERS' with variables 'Customer_lD', 'Name', 'City', and 'State'. You need to generate a report that displays the first 10 observations of the dataset, along with a title 'Customer Information (Top 10)' and a footer that indicates the date the report was generated. Which PROC PRINT statement with LABEL and NOOBS options would achieve this?
  • A00-215 Exam Question 168

    Consider the followin SAS code:

    What will the output dataset 'SORTED PRODUCTS' contain?
  • A00-215 Exam Question 169

    You are generating a report using PROC REPORT with multiple columns. You want to add a title to the report that spans across all the columns. Which of the following TITLE statement options will achieve this?
  • A00-215 Exam Question 170

    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?