Write a DATA step to create a new data set named work.trainee. Use the data set orion.staff as input.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1.  Identify and correct any errors in the program below:  [4 marks]

daat work.newsalesemps;

   length First_Name $ 12 

          Last_Name $ 18 Job_Title $ 25;

   infil "&path/newemps.csv" dlm=',;   

   input First_Name $ Last_Name $  

         Job_Title $ Salary

run;

prc print data=work.newsalesemps;

run;

proc mean data work.newsalesemps

   var Salary;

     run;

Paste your corrected SAS program in the space below:

data work.newsalesemps;

   length First_Name $ 12 

          Last_Name $ 18 Job_Title $ 25;

   infile "&path/newemps.csv" dlm=',’;   

   input First_Name $ Last_Name $  

         Job_Title $ Salary;

run;

proc print data=work.newsalesemps;

run;

proc means data work.newsalesemps

   var Salary;

     run;

 

 2.    Use the ORION dataset and write a SAS program that performs the following tasks: [5 marks]

a) Write a DATA step to create a new data set named work.trainee. Use the data set orion.staff as input.

b) The work.trainee data set should contain only the observations where Job_Title contains Trainee and Salary is greater than $25,000.

c) Create two new variables, Increase and New_Salary

a. Increase is Salary multiplied by 0.10.

b. New_Salary is Salary added to Increase

d) Generate a detail listing report as shown below . Display Employee_ID as the identifier in place of the Obs column. Format dollar amounts as dollar10.2.

e) Include titles in the report stating “Trainee Salary Report” and a second line with your family name and student id.

f) Include appropriate comments/ documentation so that it is clear to the reader what your code does.

g) SAVE your program as familyname_student_id_task2.sas

h) SAVE your results as familyname_student_id_task2.pdf

Note: Use the Download Results as a PDF File button on the Results tab. 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme