This scenario uses the
Cert.Empdata, Cert.Empdatu, and Cert.Empdatu2 data sets. Write a SAS
program to do the following:
-
Concatenate Cert.Empdata, Cert.Empdatu,
and Cert.Empdatu2 to create Work.FlightEmpData.
-
Create a macro variable named &Location
and set the value of this macro variable to USA.
-
Include only the observations whose
value for Country is the value of the macro variable.
-
Keep only observations whose salary
is $30,000 or greater.
-
Sort the data by variable Salary
in descending order.
-
Use PROC EXPORT to export the data
to a CSV file and save it as flightempdata.csv.