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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Level 1 1. Using the %UPCASE and %SCAN Functions a. Open m103p01.sas from the practices folder. Add a %LET statement to convert the value of FullName to uppercase and assign the result to FullName....

need help on how to complete this project in a step by step/ click by click way. sani New Perspectives Access 2016 Modules 1-4: SAM Capstone Project la Sandra Coates Skating Club CREATING TABLES,...

This assignment reviews object-oriented programming concepts such as classes, methods, constructors, accessor methods, and access modifiers. It makes use of an array of objects as a class data...

Please write java code for the following instructions Assignment 2 Extend your application from the previous assignment. The class name should be Controller2, an underscore, and your NetID run...

Assignment 2 Extend your application from the previous assignment. The class name should be Controller2, an underscore, and your NetID run together; for example, if your NetID is abcde6, your class...

Purpose Calculate payroll data using classes write complete program under one class Upload Screenshot of output. and write a complete program under one class. Java Topics Classes, arrays of classes,...

Midwest Executive Professionals IMPROVE A DATABASE BY CREATING AND MODIFYING TABLES, QUERIES, FORMS, AND REPORTS - GETTING STARTED . Open the file IL_AC19_CS1-4a_FirstLastName Waacob, available for...

Any help with this would be greatly appreciated! An HR Payroll System Computers are great at storing and manipulating data. For this project, you will write code that keeps track of Human Resources...

The information provided in this test allows you to set up all ledgers for an Ontario company named ASSINIBOINE specializes in sales of large purebred and pedigreed dogs. In addition, they sell cages...

Get Thumbs up from me. Please help. Can anyone try this? this my 5th attempt to get this solved so far no one has submitted a solution for this. :( I started feeling that Chegg can not help anymore...

Bobbi Manufacturing, Inc., is considering several investments. The rate on Treasury bills is currently 3.75 percent, and the expected return for the market is 10 percent. What should be the expected...

The reactions of photosynthesis make up a biochemical pathway. What are the end product of light and dark reaction of photosynthesis? Explain how the biochemical pathway of photosynthesis recycles...

The effect refers to the fact that many large firms that pay large dividends have paid dividends for a very long time.

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

6. If a nation wants to pursue an independent monetary policy, it cannot have both capital flows and a exchange rate. a. restricted, floating b. restricted, fixed c. free, floating d. free, fixed

2. In the MundellFleming model with a fixed exchange rate, which of the following increases income? a. an increase in the money supply b. a decrease in the money supply c. an increase in taxes d. a...

3. In the MundellFleming model with a floating exchange rate, if a country restricts imports, the value of its currency will , while its net exports will . a. rise, fall b. rise, remain unchanged c....