SAS Institute SAS Institute Certifications A00-280 Questions & Answers

• Question 31:

  Which statement will produce report output that can be opened in Microsoft Word?

  A. ods rtf file='report.rtf';

  B. ods doc file='report.doc';

  C. ods type='word' file='report.doc';

  D. ods rtf='report.rtf';

  Correct Answer: A

• Question 32:

  Given the following demographic dataset:

  

  Which program will generate a report where observations will appear in order by SITE SUBJECT and display column headers for each variable defined in the column statement?

  A. Proc Report ; column site subject trt age gender race ; define site/'Site', subject/'Subject', trt/'Treatment', age/'Age', gender/'Gender', race/'Race' ; run;

  B. Proc Report ; column site subject trt age gender race ; define site, subject, trt, age, gender, race ; by site subject ; title 'Site Subject Treatment Age Gender Race' ; run;

  C. Proc Report ; column site subject trt age gender race ; define site/order 'Site' ; define subject/order 'Subject' ; define trt/'Treatment' ; define age/'Age' ; define gender/'Gender' ; define race/'Race' ; run;

  D. Proc Report ; column site subject trt age gender race ; define site/order style(header)={'Site'} ; define subject/order style(header)={'Subject'} ; define trt/style(header)={'Treatment'} ; define age/style(header)={'Age'} ; define gender/style(header)={'Gender'} ; define race/style(header)={'Race'} ; run;

  Correct Answer: C

• Question 33:

  This question will ask you to provide lines of missing code.

  

  Which ODS statements, inserted respectively in the two locations indicated above, create a report stored in a PDF file?

  A. ods pdf open='AE.pdf'; ods pdf close;

  B. ods file open='AE.pdf' type=pdf; ods file close;

  C. ods pdf file='AE.pdf'; ods pdf close;

  D. ods file pdf='AE.pdf'; ods file close;

  Correct Answer: C

• Question 34:

  Which statement assigns the current date to the character variable CURRDT?

  A. currdt="andsysdate.";

  B. currdt="%sysdate.";

  C. currdt="sysdate.";

  D. currdt="#sysdate.";

  Correct Answer: A

• Question 35:

  A report that you are working on will require the following header lines:

  

  Which code adds the second line of the header "Adverse Events"?

  A. header2 'Adverse Events';

  B. header2 = 'Adverse Events';

  C. title2 = 'Adverse Events';

  D. title2 'Adverse Events';

  Correct Answer: D

• Question 36:

  The following SAS program is submitted:

  %let Av=age;

  %macro LABD(Av=weight);

  %let Av=gend; %mend;

  %LABD(Av=height)

  %put Av is andAv;

  What will be written to the SAS log?

  A. Av is weight

  B. Av is gend

  C. Av is height

  D. Av is age

  Correct Answer: D

• Question 37:

  Which clause allows macro variable creation on a select statement in PROC SQL?

  A. INTO

  B. SYMPUT

  C. AS

  D. %MACRO

  Correct Answer: D

• Question 38:

  This question will ask you to provide a missing option.

  Given an existing work data set (DM), the following code is submitted:

  

  A. MPRINT

  B. SYMBOLGEN

  C. MLOGIC

  D. MRECALL

  Correct Answer: C

• Question 39:

  A Statistical Analysis Plan defines study day as the number of days between the visit date and the date of randomization plus one day. The following SAS program is submitted using a macro from the project's library:

  

  How is the STUDYDAY macro defined?

  A. %MACRO studyday(rand, visit) ; andvdt. ?andrdt. + 1 %MEND studyday ;

  B. %MACRO studyday(rand=, visit=) ; andvdt. ?andrdt. + 1 %MEND studyday ;

  C. %MACRO studyday(rand, visit) ; andvisit. ?andrand. + 1 %MEND studyday ;

  D. %MACRO studyday(visit=, rand=) ; andvisit. ?andrand. + 1 %MEND studyday ;

  Correct Answer: C

• Question 40:

  This question will ask you to provide a line of missing code.

  The following SAS program is submitted:

  

  Which macro call prints all records from each dataset in library DB?

  A. %printlib(lib=DB, rec=all)

  B. %printlib(lib=DB, rec= )

  C. %printlib(DB, all)

  D. %printlib(DB, )

  Correct Answer: B