SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 - A00-215 Exam Practice Test

You are working with a SAS dataset called 'EMPLOYEE DATA' that includes variables 'EMPLOYEE ID', 'NAME', 'DEPARTMENT', 'SALARY', and 'HIRE DATE'. You need to analyze the relationship between 'SALARY' and 'HIRE DATE' for employees in the 'Sales' department. However, you notice that some 'HIRE DATE' values are missing. Which of the following SAS code snippets would be most suitable for handling missing values in 'HIRE DATE' while still performing the analysis?

Which of the following options correctly implements the desired output formatting in SAS using PROC MEANS?

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?

Consider two datasets, 'EMPLOYEES' and 'DEPARTMENTS', both containing a 'DEPARTMENT ID' variable. You want to combine these datasets horizontally, but only for employees in 'EMPLOYEES' whose 'HIRE DATE' is before 01JAN2010. How would you modify the MERGE statement to include this condition?

You have a SAS dataset named 'SALES with variables 'Region', 'Product', 'Sales_Amount', and 'Date'. You want to generate a report summarizing the total sales amount for each region, sorted in descending order of total sales. Which PROC PRINT statement with LABEL and NOOBS options would achieve this?

You are analyzing data on customer purchases, and you need to generate a report showing the frequency distribution of purchase amounts categorized by customer age group (18-25, 26-35, 36-45, 46-55, 56+). You also want to examine the relationship between purchase amount and customer gender (Male, Female). Which of the following PROC FREQ statements would correctly accomplish this task and generate the desired output?

You have a dataset with a variable 'SalesAmount' representing the sales revenue for each customer. You want to assign a descriptive label to each 'SalesAmount' based on its value: 'Low' for values below $1000, 'Medium' for values between $1000 and $5000, and 'High' for values above $5000. How would you accomplish this using the FORMAT statement?

You have a dataset with a variable 'DateOfBirth' in a DATE format. You want to create a new variable 'Age' that calculates the age of each individual based on today's date. Which SAS code snippet would accurately calculate the age?

You have a dataset with a variable 'SALES' containing sales values. You need to create a new variable 'SALES CATEGORY' that categorizes sales as follows: - 'High' if SALES is greater than or equal to 10000 - 'Medium' if SALES is greater than or equal to 5000 but less than 10000 - 'Low' if SALES is less than 5000 Which code snippet correctly achieves this using the INT function?

You have a dataset 'CustomerData' with variables 'CustomerlD', 'Age', and 'Income'. You want to create a new dataset 'CustomerSegments' with 'CustomerlD' and 'Segment' variables. The 'Segment' variable should be assigned based on the following rules: 1. If 'Age' is less than 30 and 'Income' is greater than 50,000, assign 'Young Professionals'. 2. If 'Age' is between 30 and 50 and 'Income' is greater than 75,000, assign 'Mid-Career Earners'. 3. If 'Age' is greater than 50 and 'Income' is greater than 100,000, assign 'Senior Executives'. 4. For all other cases, assign 'Other'. Which of the following code snippets will produce the correct 'CustomerSegments' dataset?

You have two SAS datasets: 'CUSTOMERS' (CUSTOMER ID, NAME) and 'ORDERS' (ORDER D, CUSTOMER ID, ORDER DATE). You want to create a new dataset 'CUSTOMER ORDERS' that includes customer information and their most recent order date. Which code snippets would achieve this correctly? (Select all that apply)

You have a CSV file named 'product data.csv' with columns 'product id', 'product _ name', 'category', 'price', 'quantity_in_stock'. You want to import this data into a SAS dataset named 'PRODUCTS' using PROC IMPORT. However, the CSV file has a delimiter character that is not a comm a. It is a semicolon (';'). How would you modify the PROC IMPORT statement to handle this delimiter?

You have a dataset called 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You want to sort the data in ascending order by 'REGION' and then in descending order by 'SALES AMOUNT' within each region. Which PROC SORT statement achieves this?

You are tasked with creating a report that displays the sales figures for different products. The sales data is stored in a dataset named 'SALES' with variables 'Product', 'Quantity', and 'Price'. You want to create a new variable called 'SalesValue' by multiplying 'Quantity' and 'Price', and then present the 'SalesValue' in a formatted way using the following conditions: - For 'SalesValue' less than 100, display the value with a '$' prefix and two decimal places. - For 'SalesValue' between 100 and 1000, display the value with a 'K' suffix and one decimal place. - For 'SalesValue' greater than 1000, display the value with an 'M' suffix and no decimal places. Which of the following code snippets correctly implements the required formatting using the FORMAT statement for temporary attributes?

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?