SAS Exam Chapter 7 questions with complete solutions

SAS Exam Chapter 7 questions with
complete solutions

Which PROC PRINT step displays the United States worksheet?



a.

proc print data=orionx. United States';

run;

b.

proc print data=orionx.'UnitedStates$';

run;

c.

proc print data=orionx.'UnitedStates'n;

run;

d.

proc print data=orionx.'UnitedStates$'n;

run; - correct answer ✔✔ D



You use a SAS name literal to refer to an Excel worksheet in SAS code. You enclose the name of
the worksheet, including the dollar sign, in quotation marks followed by the letter n.



In this SAS/ACCESS LIBNAME statement, what does oracle represent?



libname sports oracle

user=edu001 pw=edu001

, path=dbmssrv schema=educ;



a. libref

b. option

c. table name

d. engine name - correct answer ✔✔ D



In this SAS/ACCESS LIBNAME statement, you must specify an engine name following the libref.
Oracle is the engine name.



Which PROC step successfully prints a list of all data sets in the orionx library without printing
descriptor portions for the individual data sets?

a.

proc contents data=orionx.nods _all_;

run;

b.

proc contents data=orionx._all_ nods;

run;

c.

proc print data=orionx._all_ noobs;

run;

d.

proc print data=orionx._all_ nods;

run; - correct answer ✔✔ B