SASInstitute SAS Certified Associate: Programming Fundamentals Using SAS 9.4 - A00-215 FREE EXAM DUMPS QUESTIONS & ANSWERS

You have a dataset with a variable 'PRICE' containing values like 12.99, 25.50, 18.75. You want to round these values down to the nearest dollar amount (e.g., 12.99 becomes 12). Which SAS function would you use?

You have a dataset 'SALES' with variables 'REGION', 'PRODUCT', and 'SALES AMOUNT'. You need to calculate the average sales amount for each region and product combination, but only for products with a total sales amount greater than 1000. Which code snippet achieves this correctly?

You are analyzing customer data in a SAS data set named 'CUSTOMER DATA'. You need to create a new data set called 'ACTIVE CUSTOMERS that contains only customers who have made a purchase in the last 12 months. The 'CUSTOMER DATA' dataset has the following variables: CUSTOMER D, LAST PURCHASE DATE. Which DATA step code snippet correctly accomplishes this task?

You have a SAS dataset named 'SALES with variables 'Region', 'Product', and 'Sales'. You want to create a new dataset 'SALES SUMMARY' that summarizes sales by region and product. Which SAS code snippet correctly performs this task, assuming that the 'Sales' variable is numeric and the 'Region' and 'Product' variables are character? Choose all correct options.

You have a dataset 'Transactions' with a variable 'TransactionDate' in a DATE format. You need to create a new variable 'DaysSinceLastTransaction' that calculates the number of days since the previous transaction for each record. Which SAS code snippet would correctly achieve this?

You have three datasets: 'CUSTOMER INFO', 'ORDER DETAILS', and 'PRODUCT_DATA', each containing a unique 'CUSTOMER ID', 'ORDER ID', and 'PRODUCT ID' respectively. You need to create a new dataset 'COMPLETE DATA' that combines the data from all three datasets based on the following logic: 1. Merge 'CUSTOMER INFO' and 'ORDER DETAILS' datasets on 'CUSTOMER ID'. 2. Then, merge the resulting dataset with 'PRODUCT DATA' on 'ORDER ID'. Write the SAS code to achieve this using MERGE statements.

You have a dataset 'ORDERS' with variables 'ORDER D', 'CUSTOMER ID', and 'ORDER DATE'. You want to create a new dataset 'RECENT ORDERS' containing only the records where the 'ORDER DATE' is within the last 30 days (excluding today) and only the 'ORDER ID' and 'CUSTOMER ID' variables should be included. The date format is 'YYYY-MM-DD'. Which SAS code snippet would achieve this correctly?

You have a SAS dataset with a variable 'DATE VAR' containing dates stored as numeric values. You need to create a new variable 'DATE DISPLAY' that displays the date in the format 'DDMONYY' (e.g., 25JUL2023). Which SAS code snippet correctly achieves this?

You have a dataset 'EmployeeData' with variables 'Department', 'JobTitle', and 'YearsOfExperience'. You want to create a two-way frequency table showing the distribution of 'JobTitle' across different 'Department's. You also want to use the 'CROSSLIST' option to control the layout, but you want to include only those employees with 'YearsOfExperience' greater than 5. Which PROC FREQ statements, along with the correct options, achieve this?

You have a dataset 'CUSTOMERS' with variables 'CUSTOMER ID', 'ORDER DATE', and 'ORDER AMOUNT'. You need to calculate the total order amount for each customer and then calculate the average order amount across all customers. Which code snippet achieves this correctly?

Consider the following SAS code:

What is the order in which the statements in the DATA step are executed for a single record in the WORK.OLD DATA dataset?