Question
Create a macro variable named employee_grade and assign it a value of GR20. Print the following fields from the employees SAS data file in the
Create a macro variable named employee_grade and assign it a value of GR20.
Print the following fields from the employees SAS data file in the following order: name, title, salary, dob so that it displays only those employees in the employee_grade macro field you just created. Format the date so that it displays as Saturday, January 1, 2022 and format the salary so it displays with a dollar sign and two decimal places.
Sort the employees file as a new file named employ_out by grade in ascending order and then by salary in descending order.
Eliminate duplicate values for the grade field/column. Set up your code so that the unique values are kept in a file named employ_nodups and the duplicated data is in a file named employ_dups.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started