Question No. 1

Given the following data at WORK DEMO:

Which SAS program prints only the first 5 males in this order from the data set?

Aproc sort data=WORK.DEMO out=out;
by sex;
run;
proc print data= out (obs=5);
run;

Bproc print data=WORK.DEMO(obs=5);
where Sex='M';
run;

Cproc print data=WORK.DEMO(where=(sex='M'));
where obs<=5;
run;

Dproc sort data=WORK.DEMO out=out;
by sex descending;
run;
proc print data= out (obs=5);
run;

Show Answer

Correct Answer: B

Question No. 2

Which SAS program will apply the data set label 'Demographics' to the data set named DEMO?

Adata demo (label='Demographics');
set demo;
run;

Bdata demo;
set demo (label='Demographics');
run;

Cdata demo (label 'Demographics');
set demo;
run;

Ddata demo;
set demo;
label demo= 'Demographics';
run;

Show Answer

Correct Answer: A

Question No. 3

The following SAS program is submitted:

proc sort data=SASUSER.VISIT out=PSORT;

by code descending date cost;

run;

Which statement is true regarding the submitted program?

AThe descending option applies to the variable CODE.

BThe variable CODE is sorted by ascending order.

CThe PSORT data set is stored in the SASUSER library.

DThe descending option applies to the DATE and COST variables.

Show Answer

Correct Answer: B

Question No. 4

What information can be found in the SAS Dictionary tables? (Choose two.)

Adatasets contained within a specified library

Bvalues contained within a specified format

Cvariables contained within a specified dataset

Dvalues contained within a specified variable

Show Answer

Correct Answer: A, C

Question No. 5

Given the following data set:

Which program was used to prepare the data for this PROC PRINT output?

Aproc sort data=one out=two;
by subjid;
run;

Bproc sort data=one out=two nodupkey;
by subjid;
run;

Cproc sort data=one out=two nodup;
by subjid;
run;

Dproc sort data=one out=two nodupkey;
by subjid trt;
run;

Show Answer

Correct Answer: B

Free SAS A00-281 Exam Actual Questions