Free SASInstitute A00-215 Exam Dumps Questions & Answers

You have a SAS dataset called 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You need to create a new dataset 'HIGH SALES' containing only observations from the 'SALES' dataset where the 'SALES AMOUNT' is greater than 1000 and the 'PRODUCT' is 'Laptop'. Which of the following DATA step code snippets will achieve this?

• A. 
• B. 
• C. 
• D. 
• E. 

You have a dataset with a 'ProductStatus' variable containing values like 'Active', 'Inactive', 'Discontinued', or missing. You want to create a custom format to label missing values as 'Unknown' and combine 'Inactive' and 'Discontinued' as 'Not Active'. Which PROC FORMAT code snippet correctly defines this format?

• A. 
• B. 
• C. 
• D. 
• E. 

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?

• A. 
• B. 
• C. 
• D. 
• E. 

You have a dataset 'PRODUCTS with variables 'PRODUCT ID', 'PRICE', and 'QUANTITY SOLD'. You need to calculate the total revenue for each product, then find the product with the highest revenue, and output its product ID and revenue. Which code snippet achieves this correctly?

• A. 
• B. 
• C. 
• D. 
• E. 

You have a SAS dataset 'PRODUCTS' with variables 'PRODUCT ID', 'PRODUCT NAME', and 'PRICE'. You need to export this dataset to a CSV file 'product_catalog.csv', but you want to exclude the 'PRODUCT ID' variable and only include rows where 'PRICE' is greater than 100. Which PROC EXPORT statement will achieve this?

• A. 
• B. 
• C. 
• D. 
• E.