COLLEGE OF COMPUTING, INFORMATICS AND MEDIA
BACHELOR OF SCIENCE (HONS.) STATISTICS
COURSE CODE:
SAS PROGRAMMING (STA610)
TOPIC:
EXERCISES CHAPTER 4
NAME:
NUR HUSNINA BINTI ZAMZURI
STUDENT ID:
2023376445
GROUP:
CDCS241 4B
LECTURER NAME:
DR. SHAMSIAH BINTI SAPRI
,Chapter 4.1
Level 1
Q1.
a. Retrieve the starter program p104e01b.
b. Add a SUM statement to display the sum of Total_Retail_Price.
libname orion "C:\Users\ASUS\OneDrive - Universiti Teknologi
MARA\Desktop\STA610\P1 2017 Data\P1 2017 Data";
proc print data=orion.order_fact;
sum Total_Retail_Price;
run;
c. Add a WHERE statement to select only the observation with Total_Retail_Price more
than 500. Submit the program. Verify that 35 observations are displayed.
, What do you notice about the Obs column? The Obs numbers are not continuous.
Did the sum of Total_Retail_Price change to reflect only the subset? Yes.
d. Add an option to suppress the Obs column. Verify that there are 35 observations in the
results.
BACHELOR OF SCIENCE (HONS.) STATISTICS
COURSE CODE:
SAS PROGRAMMING (STA610)
TOPIC:
EXERCISES CHAPTER 4
NAME:
NUR HUSNINA BINTI ZAMZURI
STUDENT ID:
2023376445
GROUP:
CDCS241 4B
LECTURER NAME:
DR. SHAMSIAH BINTI SAPRI
,Chapter 4.1
Level 1
Q1.
a. Retrieve the starter program p104e01b.
b. Add a SUM statement to display the sum of Total_Retail_Price.
libname orion "C:\Users\ASUS\OneDrive - Universiti Teknologi
MARA\Desktop\STA610\P1 2017 Data\P1 2017 Data";
proc print data=orion.order_fact;
sum Total_Retail_Price;
run;
c. Add a WHERE statement to select only the observation with Total_Retail_Price more
than 500. Submit the program. Verify that 35 observations are displayed.
, What do you notice about the Obs column? The Obs numbers are not continuous.
Did the sum of Total_Retail_Price change to reflect only the subset? Yes.
d. Add an option to suppress the Obs column. Verify that there are 35 observations in the
results.
