EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer
Physics
C.S.

SAS Programing Certification Exam
Practice Questions & Answer set-

Practice Question 187

The following SAS DATA step is submitted:
data sasdata.atlanta     sasdata.boston

work.portland     work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?
A. No library references are required.
B. The data sets listed on all the IF statements require a library reference.
C. The data sets listed in the last two IF statements require a library reference.
D. The data sets listed in the first two IF statements require a library reference.


Answer is D.

Practice Question 188

Which one of the following SAS DATA steps saves the temporary data set named
Click to Get Those Highly Recommended SAS Programmers' Books
MYDATA as a permanent data set?
A. libname sasdata 'SAS-data-library';
data sasdata.mydata;
copy mydata;
run;
B. libname sasdata 'SAS-data-library';
data sasdata.mydata;
keep mydata;
run;
C. libname sasdata 'SAS-data-library';
data sasdata.mydata;
save mydata;
run;
D. libname sasdata 'SAS-data-library';
data sasdata.mydata;
set mydata;
run;


Answer is D.

Practice Question 189

some questions may have repeated. The following SAS DATA step is submitted:
libname temp 'SAS-data-library';
data temp.report;
set sasuser.houses;
newvar = price * 1.04; run;
Which one of the following statements is true regarding the program above?
A. The program is reading from a temporary data set and writing to a temporary data set.
B. The program is reading from a temporary data set and writing to a permanent data set.
C. The program is reading from a permanent data set and writing to a temporary data set.
D. The program is reading from a permanent data set and writing to a permanent data set.


Answer is D.

Practice Question 190

The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?
A.WORK     B.REPORT.     C.HOUSES     D.SASUSER


Answer is A.

Related links:

Continue to SAS Practice Exam Question Answer Set-40   SAS interview Questions Answers
Back to SAS Practice Exam Question Answer Set-38   SAS Tutorial   Statistics Tutorial