Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Harness The Power Of Big Data The IBM Big Data Platform

Authors: Paul Zikopoulos, David Corrigan James Giles Thomas Deutsch Krishnan Parasuraman Dirk DeRoos Paul Zikopoulos

1st Edition

0071808183, 9780071808187

More Books

Students also viewed these Databases questions