SAS Institute A00-281 - Clinical Trials Programming Using SAS 9 – Accelerated Version Exam
Page: 1 / 20
Total 99 questions
Question #1 (Topic: )
Given the following data at WORK DEMO:
Which SAS program prints only the first 5 males in this order from the data set?
Which SAS program prints only the first 5 males in this order from the data set?
A. proc sort data=WORK.DEMO out=out; by sex; run; proc print data= out (obs=5); run;
B. proc print data=WORK.DEMO(obs=5); where Sex='M'; run;
C. proc print data=WORK.DEMO(where=(sex='M')); where obs<=5; run;
D. proc sort data=WORK.DEMO out=out; by sex descending; run; proc print data= out (obs=5); run;
Answer: B
Question #2 (Topic: )
Which SAS program will apply the data set label 'Demographics' to the data set named
DEMO?
DEMO?
A. data demo (label='Demographics'); set demo; run;
B. data demo; set demo (label='Demographics'); run;
C. data demo (label 'Demographics'); set demo; run;
D. data demo; set demo; label demo= 'Demographics'; run;
Answer: A
Question #3 (Topic: )
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?
proc sort data=SASUSER.VISIT out=PSORT;
by code descending date cost;
run;
Which statement is true regarding the submitted program?
A. The descending option applies to the variable CODE.
B. The variable CODE is sorted by ascending order.
C. The PSORT data set is stored in the SASUSER library.
D. The descending option applies to the DATE and COST variables.
Answer: B
Question #4 (Topic: )
What information can be found in the SAS Dictionary tables? (Choose two.)
A. datasets contained within a specified library
B. values contained within a specified format
C. variables contained within a specified dataset
D. values contained within a specified variable
Answer: A,C
Question #5 (Topic: )
Given the following data set:
Which program was used to prepare the data for this PROC PRINT output?
Which program was used to prepare the data for this PROC PRINT output?
A. proc sort data=one out=two; by subjid; run;
B. proc sort data=one out=two nodupkey; by subjid; run;
C. proc sort data=one out=two nodup; by subjid; run;
D. proc sort data=one out=two nodupkey; by subjid trt; run;
Answer: B