COLLEGE OF COMPUTING, INFORMATICS AND MEDIA
BACHELOR OF SCIENCE (HONS.) STATISTICS
COURSE CODE:
SAS PROGRAMMING (STA610)
TOPIC:
EXERCISES CHAPTER 7
NAME:
NUR HUSNINA BINTI ZAMZURI
STUDENT ID:
2023376445
GROUP:
CDCS241 4B
LECTURER NAME:
DR. SHAMSIAH BINTI SAPRI
, Chapter 7.1
Level 2
Q2.
a. Open new program and write an OPTION statement to set VALIDVARNAME to V7.
options validvarname=v7;
b. Write LIBNAME statement to create a libref named prod that references the Excel
workbook product.xlsx.
options validvarname=v7;
libname prod excel "C:\Users\ASUS\OneDrive - Universiti Teknologi
MARA\Desktop\STA610\pg1\pg1\products.xlsx";
c. Write a PROC CONTENTS step to view all the contents of prod.
proc contents data=prod._all_;
run;
BACHELOR OF SCIENCE (HONS.) STATISTICS
COURSE CODE:
SAS PROGRAMMING (STA610)
TOPIC:
EXERCISES CHAPTER 7
NAME:
NUR HUSNINA BINTI ZAMZURI
STUDENT ID:
2023376445
GROUP:
CDCS241 4B
LECTURER NAME:
DR. SHAMSIAH BINTI SAPRI
, Chapter 7.1
Level 2
Q2.
a. Open new program and write an OPTION statement to set VALIDVARNAME to V7.
options validvarname=v7;
b. Write LIBNAME statement to create a libref named prod that references the Excel
workbook product.xlsx.
options validvarname=v7;
libname prod excel "C:\Users\ASUS\OneDrive - Universiti Teknologi
MARA\Desktop\STA610\pg1\pg1\products.xlsx";
c. Write a PROC CONTENTS step to view all the contents of prod.
proc contents data=prod._all_;
run;
