NO.213 Consider the following SAS code snippet. Which statements accurately describe the behavior of the PDV during the execution of this code?

NO.214 Which two statements are true about data set options such as KEEP= and RENAME =? (Choose two.)

NO.215 You are analyzing financial data and need to report the average return on investment (ROI) for different investment strategies. You want to display the average ROI to two decimal places. Which PROC MEANS statement would achieve this using the MAXDEC= option?

NO.216 You are tasked with analyzing sales data for different regions. You need to calculate the cumulative sum of sales for each region, resetting the sum at the start of each new region. Which of the following code snippets would correctly achieve this, using BY group processing with FIRST. and LAST. to accumulate in groups?

NO.217 You have a dataset ‘sales_data’ with variables ‘Region’, ‘Product’, and ‘Sales’. You want to create a frequencyreport that displays the frequency counts for each region and product combination, but you only want to see the counts for those combinations where the sales value is greater than $10,000. How would you modify the PROC FREQ statement to achieve this?

NO.218 You are analyzing customer data, and you need to identify the first and last purchases made by each customer. Which of the following techniques using the OUTPUT statement would be most appropriate to achieve this?

NO.219 The data set SASHELP. CARS contains information on different vehicles. How do you correctly write the observations with Type of ‘SUV’ to the suv data set and Type of ‘Sedan’ to the sedans data set?

NO.220 The sashelp. class data set has 19 observations.
Given the frequency information about the Age, shown below:

How many observations are written to output data set when the following code is submitted?

NO.221 Which of the following SAS variable names are valid and adhere to the SAS naming conventions? 1 . _ age 2. Age_ 1 3. AGE 1 4. lage 5. Age! 6. Age_ 7. _1Age 8. _age_ 9. Age_l_

NO.222 What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

NO.223 Given the SAS data set WORK PRODUCTS:

The following SAS program is submitted:

How many variables does the WORK REVENUE data set contains?

NO.224 Given the code shown below:

What will be the format for MSRP in the RPOC PRINT output?

NO.225 You have a dataset ‘CUSTOMER’ with variables ‘CustomerlD’, ‘Name’, and ‘City’. You want to create a new variable ‘Region’ based on the ‘City’ variable using the following rules: If ‘City’ starts with ‘New’, then ‘Region’ = ‘Northeast’; If ‘City’ is ‘Los Angeles’, then ‘Region’ = ‘West’; otherwise, ‘Region’ = ‘Other’. Which code snippet correctly implements this logic in the DATA step?

NO.226 The data set Snacks contains three variables (productName, Flavor, and Price). Given the program shown below:

What is the type and length of SnackType?

NO.227 You have a SAS dataset ‘CUSTOMERS’ with variables ‘CUSTOMER ID’, ‘NAME’, and ‘CITY’. You need to create a new dataset ‘ACTIVE CUSTOMERS’ containing only those customers who have made purchases in the past 3 months. You have another dataset ‘ORDERS’ with variables ‘ORDER ID’, ‘CUSTOMER ID’, and ‘ORDER DATE’. How would you use the SET statement to achieve this?

NO.228 Given the input data set INVENTORY as shown below:

Two output data sets are desired, CHIPS and OTHERSNACKS.
* The CHIPS data set should only include QtySold, Price, and Product.
* The OTHERSNACKS data set should include QtySold, Price, product, and Type.
Which Data step creates the two desired output data sets

NO.229 You have two SAS datasets, ‘SALES 2022’ and ‘SALES 2023’, each containing sales data for the respective years. Both datasets share the same structure with variables like ‘Region’, ‘Product’, and ‘SalesAmount’. You want to combine these datasets into a single dataset called ‘ALL SALES’ to analyze the sales trends over the two years. How would you accomplish this using the SET statement within the DATA step, ensuring that the original datasets remain untouched?

NO.230 You have a dataset ‘sales data’ with variables ‘Product’, ‘Quantity’, and ‘Price’. You want to calculate the total revenue for each product and create a new dataset ‘revenue_data’ with variables ‘Product’ and ‘TotalRevenue’. You need to use the ‘SUM’ function within a DO loop. Which SAS code snippet correctly accomplishes this?

NO.231 You’re working with a dataset that contains employee salary information. You need to adjust the salary based on the following criteria: – If the employee is in the ‘Management’ department and their salary is less than $50,000, increase their salary by 10%. – If the employee is in the ‘Sales’ department and their salary is between $40,000 and $60,000, increase their salary by 5%. – Otherwise, leave the salary unchanged. Which of the following code snippets accurately implements this logic using the IF-THEN/ELSE structure?

NO.232 You have an Excel file ‘customer data.xlsx’ with two sheets: ‘Customers’ and ‘Orders’. The ‘Customers’ sheet contains customer IDs and names, while the ‘Orders’ sheet contains order IDs, customer IDs, and order dates. You want to create a SAS dataset ‘combined_data’ that joins data from both sheets based on the common ‘Customer ID’ column. Which code snippet correctly accomplishes this?

NO.233 You have a SAS dataset named ‘sales’ with variables ‘product’, ‘region’, and ‘units_sold’. You want to create a new dataset ‘sales _ summary’ that summarizes the total units sold for each product across all regions. Which of the following code snippets correctly achieves this?