A00-215 Exam Question 96

You have a dataset 'Employees' with a 'Hire_Date' variable in the format 'YYMMDDIO.'. You need to categorize employees based on their tenure (time employed) into three groups: 'New Hire' (less than 1 year), 'Experienced' (1 to 5 years), and 'Veteran' (more than 5 years). Which code snippet correctly performs this categorization?
  • A00-215 Exam Question 97

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

    You have a dataset with a variable 'REGION' containing values like 'North America', 'South America', 'Europe', etc. You want to create a custom format that abbreviates these values to 'NA', 'SA', 'EU', respectively. Which PROC FORMAT code snippet achieves this?
  • A00-215 Exam Question 99

    Which of the following options correctly implements the desired output formatting in SAS using PROC MEANS?
  • A00-215 Exam Question 100

    You are developing a report that requires a title containing a macro variable representing a specific department name. The department name is stored in a data set named 'dept_info'. How can you correctly incorporate the department name into the report title using the TITLE statement and a macro variable?