A00-215 Exam Question 91
You have a dataset containing customer names in a variable named 'CUSTOMER NAME'. Some names are in all uppercase, some are in all lowercase, and some have a mix of cases. You need to standardize all customer names to have the first letter in uppercase and the rest in lowercase. Which SAS code snippet accomplishes this task using the 'PROPCASE' function?
A00-215 Exam Question 92
You have a SAS dataset named 'mydata' containing customer information, and you need to export it to a CSV file named 'customers.csv'. You want to include only the 'CustomerlD', 'Name', and 'City' variables in the output file and ensure that the data is delimited by a semicolon (;). Which PROC EXPORT statement accomplishes this task?
A00-215 Exam Question 93
You have a dataset 'Sales' with variables 'Region', 'Product', and 'Quantity'. You want to create a two-way frequency table showing the distribution of 'Product' across different 'Region's. Which PROC FREQ statement with the CROSSLIST option correctly produces this table, where the rows represent 'Region' and columns represent 'Product'?
A00-215 Exam Question 94
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 95
You have a SAS data set named 'CUSTOMERS' with several variables. You need to determine if any of the variables are formatted with a specific format named 'MY FORMAT'. Which PROC CONTENTS option would you use to achieve this?