A00-215 Exam Question 71

You have a dataset with a variable 'City' containing city names. You want to create a new variable 'State' based on the following logic: , If the city name contains 'New York', assign 'NY' to 'State'. , If the city name contains 'Los Angeles', assign 'CA' to 'State'. , If the city name contains 'Chicago', assign 'IL' to 'State'. , For all other cities, assign 'Other' to 'State'. Which code snippet correctly implements this logic using the FIND function?
  • A00-215 Exam Question 72

    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?
  • A00-215 Exam Question 73

    You have a dataset 'ORDERS' with variables 'ORDER ID', 'CUSTOMER ID', 'ORDER DATE', and 'TOTAL AMOUNT'. You want to create a dataset 'HIGH VALUE ORDERS' containing only observations from the 'ORDERS' dataset where the 'TOTAL AMOUNT' is greater than 5000 and the 'ORDER DATE' falls between '01JAN2023'd and '31 MAR2023d. Which of the following DATA step code snippets will achieve this?
  • A00-215 Exam Question 74

    You have a dataset with a variable 'DATE VAR' storing dates in SAS date format. You need to calculate the number of days between 'DATE VAR' and a constant date '01JAN2023'd. Which code snippet correctly performs this calculation?
  • A00-215 Exam Question 75

    You have a SAS dataset named 'CUSTOMERS' with variables 'CUST ID', 'NAME', 'CITY', 'STATE', 'ZIP', 'PHONE', 'EMAIL'. You need to create a new dataset named 'CUSTOMERS CONTACT' containing only the variables 'NAME', 'PHONE', and 'EMAIL'. Which of the following DATA step code snippets would achieve this?