COLLEGE OF COMPUTING, INFORMATICS AND MEDIA
BACHELOR OF SCIENCE (HONS.) STATISTICS
COURSE CODE:
SAS PROGRAMMING (STA610)
TOPIC:
EXERCISES CHAPTER 6
NAME:
NUR HUSNINA BINTI ZAMZURI
STUDENT ID:
2023376445
GROUP:
CDCS241 4B
LECTURER NAME:
DR. SHAMSIAH BINTI SAPRI
, Chapter 6.1
Level 2
Q1.
a. Write a DATA step to create new data set named work.assistent. use the data set
orion.staff as input.
b. Where Job_Title contains Assistant and Salary less than $26,000.
c. New variable
• Increase is Salary multiplied by 0.01.
• New_Salary is Salary added to Increase.
d. Generate as below.
libname orion "C:\Users\ASUS\OneDrive - Universiti Teknologi
MARA\Desktop\STA610\P1 2017 Data\P1 2017 Data";
data work.assistent;
set orion.staff;
where job_title contains 'Assistant' and salary<26000;
Increase=Salary*0.10;
New_Salary= Salary + Increase;
run;
proc print data=work.assistent noobs;
var employee_id job_title salary increase new_salary;
format salary dollar10.2 increase dollar9.2 new_salary dollar10.2;
run;
BACHELOR OF SCIENCE (HONS.) STATISTICS
COURSE CODE:
SAS PROGRAMMING (STA610)
TOPIC:
EXERCISES CHAPTER 6
NAME:
NUR HUSNINA BINTI ZAMZURI
STUDENT ID:
2023376445
GROUP:
CDCS241 4B
LECTURER NAME:
DR. SHAMSIAH BINTI SAPRI
, Chapter 6.1
Level 2
Q1.
a. Write a DATA step to create new data set named work.assistent. use the data set
orion.staff as input.
b. Where Job_Title contains Assistant and Salary less than $26,000.
c. New variable
• Increase is Salary multiplied by 0.01.
• New_Salary is Salary added to Increase.
d. Generate as below.
libname orion "C:\Users\ASUS\OneDrive - Universiti Teknologi
MARA\Desktop\STA610\P1 2017 Data\P1 2017 Data";
data work.assistent;
set orion.staff;
where job_title contains 'Assistant' and salary<26000;
Increase=Salary*0.10;
New_Salary= Salary + Increase;
run;
proc print data=work.assistent noobs;
var employee_id job_title salary increase new_salary;
format salary dollar10.2 increase dollar9.2 new_salary dollar10.2;
run;
