SAS Institute SAS Institute Certifications A00-280 Questions & Answers

• Question 21:

  Given the SAS data set WORK.BP

  

  What is the result?

  A. WORK.HIGHBP has 1 observation WORK.NORMBP has 1 observation WORK.INVESTBP has 3 observations

  B. WORK.HIGHBP has 1 observation WORK.NORMBP has 1 observation WORK.INVESTBP has 4 observations

  C. WORK.HIGHBP has 1 observation WORK.NORMBP has 1 observation WORK.INVESTBP has 2 observations

  D. WORK.HIGHBP has 2 observations WORK.NORMBP has 2 observations WORK.INVESTBP has 3 observations

  Correct Answer: B

• Question 22:

  Given the following two data sets EX and AE:

  

  Which output data set is produced by the submitted SAS program?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 23:

  The following SAS program is submitted: data WORK.ALL;

  

  How will the data sets ONE and TWO be combined?

  A. updated

  B. one-one merged

  C. match merged

  D. concatenated

  Correct Answer: D

• Question 24:

  The data set CM has eight variables including CMTRT and is sorted by STUDYID USUBJID CMSEQ.

  DATA_BB is created by selecting records from CM where the character string "BLOCKER" is included in CMTRT.

  

  Which program was used to produce WORK.DATA_BB?

  A. proc sort data=cm out=data_bb (keep=usubjid cmstdtc cmtrt); by usubjid CMSTDTC; where cmtrt in('BLOCKER'); run;

  B. proc sort data=CM (keep=usubjid cmstdtc cmtrt) out=data_bb; by usubjid CMSTDTC; where cmtrt contains 'BLOCKER'; run;

  C. data data_bb; set cm (where=(find(cmtrt,'BLOCKER','i')>0)); by usubjid CMSTDTC; run;

  D. data data_bb; set cm (keep=usubjid cmstdtc cmtrt); by usubjid CMSTDTC; where cmtrt in('BLOCKER'); run;

  Correct Answer: B

• Question 25:

  Which name is a valid SAS V5 variable name?

  A. _AESTDTC

  B. AESTARTDTC

  C. AE-STDTC

  D. AE_START_DTC

  Correct Answer: A

• Question 26:

  You have been asked to import an Excel spreadsheet. What will lead to substantial differences between the original Excel spreadsheet and the resulting SAS data set?

  A. the number of rows to be read from the Excel file

  B. the number of columns to be read from the Excel file

  C. multiple value types within a single column

  D. multiple value types within a single row

  Correct Answer: C

• Question 27:

  Which LIBNAME statement is valid?

  A. libname "c:\sas\labdata\";

  B. libname mysasdata "c:\sas\labdata\";

  C. libname work "c:\sas\labdata\";

  D. libname sasdata "c:\sas\labdata\";

  Correct Answer: D

• Question 28:

  The VISIT data set is multiple records per subject, sorted by usubjid vistdtc vistm and contains the following variables:

  

  The DEATH data set is one record per subject, sorted by usubjid vistdtc vistm and contains the following variables:

  

  Which program will combine the DEATH and VISIT data sets by matching records?

  A. data data_1; merge death visit; by usubjid vistdtc vistm; run;

  B. data data_1; merge death visit; run;

  C. data data_1; set death visit; by usubjid vistdtc vistm; run;

  D. data data_1; merge death visit; by usubjid vistm vistdtc; run;

  Correct Answer: A

• Question 29:

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

  

  Which statement must be added to the following program to create a page break in the report after each RACE grouping?

  

  A. break page / race;

  B. break race / page;

  C. break after race / page;

  D. break after race;

  Correct Answer: C

• Question 30:

  Which statement will create a report footnote that identifies the date and time that the SAS program was executed?

  A. footnote1 "Created on andsysdate9 andsystime";

  B. footnote1 = "Created on andsysdate9 andsystime";

  C. footnote1 'Created on andsysdate9 andsystime';

  D. footnote1 = 'Created on andsysdate9 andsystime';

  Correct Answer: A