SAS Quiz 2 Practice Chapters 5-7
2 Questions
| Attempts: 78
Practice for the SAS Basic Certification exam
Questions and Answers
- 1.
Which statement correctly accesses an Excel file?
- A.
Libname xldat 'C:\Excel\example.xlsx.Sheet1';
- B.
Filename xldat 'C:\Excel\example.xlsx\Sheet1$';
- C.
Libname xldat 'C:\Excel\example.xlsx';
- D.
Filename xldat 'C:\Excel\example.xlsx';
Correct Answer
C. Libname xldat 'C:\Excel\example.xlsx'; -
- 2.
How would you create a list report of an Excel sheet?
- A.
Data work.new; infile xldat.'Sheet1$'; input var1 var2 var3; run; proc print data=work.new; run;
- B.
Proc print data=xldat.'Sheet1$'; run;
- C.
Proc print data=xldat; sheet = 'Sheet1'; run;
- D.
Proc print data=xldat.'Sheet1$'n; run;
Correct Answer
D. Proc print data=xldat.'Sheet1$'n; run; -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 08, 2013Quiz Edited by
ProProfs Editorial Team -
Jan 23, 2013Quiz Created by
Moxleyv
Back to top