Question 61

You have a SAS dataset called 'product _ info' with variables 'Product ID', 'Product Name', and 'Price'. You want to export this data to a CSV file called 'products.csv' but need to ensure that the data is exported in a specific order: Product _ Name, Product ID, and Price. Which PROC EXPORT statement correctly accomplishes this?
  • Question 62

    The sashelp. class data set has 19 observations.
    Given the frequency information about the Age, shown below:

    How many observations are written to output data set when the following code is submitted?
  • Question 63

    You have a SAS dataset named 'ORDERS' with the following structure: Order ID,Customer ID,Order Date,T0tal Amount You need to export this data to a CSV file named 'orders_export.csv' with the following requirements: 1. The data should be sorted by 'Order Date' in ascending order. 2. The 'Order Date' column should be formatted as 'YYYY-MM-DD'. 3. The 'Total Amount' column should be formatted as a comma-separated numeric value with 2 decimal places. Which of the following PROC EXPORT statements would achieve this correctly?
  • Question 64

    You have a SAS dataset named 'CUSTOMERS' with variables 'CUST ID' and 'CITY'. You want to generate a report that displays the city names in a column titled 'Location' instead of 'CITY' and assign a specific label to the 'CUST ID' variable. Which code snippet correctly uses the LABEL statement for the required modifications?
  • Question 65

    You have a dataset with a character variable 'NAME' that stores full names. You need to create a new variable 'FIRST NAME' containing only the first name from the 'NAME' variable. The names are separated by a space. However, some names have a middle name, and some don't. Which code snippet correctly extracts the first name and ensures the 'FIRST NAME' variable has a length of 20 bytes?