SAS Institute A00-280 Online Practice Questions and Exam Preparation

SAS Institute A00-280 Online Questions & Answers

• Question 71:

  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;
  A. data data_1; merge death visit; by usubjid vistdtc vistm; run;

• Question 72:

  This question will ask you to provide a section of missing code. Given the input SAS data set LABRAW:

  

  Which DO LOOP will create the output SAS data set WORK.LAB_NEW?

  A. do i=1 to 2; visit=i; date=dat{i}; result=num{i}; output; end;
  B. do i=1 to 2; visit=i; date=dat{i}; result=num{i}; end; output;
  C. do i=1 to 2; do j=1 to 2; visit=i; date=dat{j}; result=num{j}; output; end;
  D. do i=1 to 2; do j=1 to 2; visit=i; date=dat{j}; result=num{j}; end; output; end;
  A. do i=1 to 2; visit=i; date=dat{i}; result=num{i}; output; end;

• Question 73:

  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
  B. Option B

• Question 74:

  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
  A. datasets contained within a specified library
  C. variables contained within a specified dataset

• Question 75:

  The following SAS program is submitted:

  

  You want to store all calculated means and standard deviations in one SAS data set.

  Which statement must be added to the program?

  A. output mean std;
  B. ods output mean=m1 m2 std=s1 s2;
  C. output out=WORK.RESULTS mean=m1 m2 std=s1 s2;
  D. ods output out=WORK.RESULTS mean=m1 m2 std=s1 s2;
  C. output out=WORK.RESULTS mean=m1 m2 std=s1 s2;

• Question 76:

  The following question will ask you to provide a line of missing code. Given the following data set work.vs:

  

  The following SAS program is submitted to create a new data set that carries forward the previous value of sbp when the value is missing.

  In the space below, enter the line of code that completes the program (Case is ignored. Do not add leading or trailing spaces to your answer.).

  RETAINOLD_SBP

• Question 77:

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

  Given the dataset RAWBP that is sorted by SUBJECT TEST WEEK:

  

  Which statement must be added to the program to calculate relative change in percent (percent change) from baseline?

  A. pct_chg = ((baseline - value) /baseline)*100;
  B. pct_chg = ((value - baseline) /baseline)*100;
  C. pct_chg = ((baseline - value) /value)*100;
  D. pct_chg = ((value - baseline) /value)*100;
  B. pct_chg = ((value - baseline) /baseline)*100;

• Question 78:

  A SAS program is submitted and the following log is written.

  

  What is the cause of this error message?

  A. The ARRAY declaration is syntactically incorrect.
  B. The IF statement is syntactically incorrect.
  C. The DO loop tries to get a value from a variable which does not exist.
  D. The IF statement tries to get ARRAY elements which are not declared.
  D. The IF statement tries to get ARRAY elements which are not declared.

• Question 79:

  Which program will report all created output objects in the log?

  A. proc ttest data=WORK.DATA1 ods=trace; class TREAT; var RESULTS; run;
  B. ods trace on; proc ttest data=WORK.DATA1; class TREAT; var RESULTS; run;
  C. ods trace=log; proc ttest data=WORK.DATA1; class TREAT; var RESULTS; run;
  D. ods trace log; proc ttest data=WORK.DATA1; class TREAT; var RESULTS; run;
  B. ods trace on; proc ttest data=WORK.DATA1; class TREAT; var RESULTS; run;

• Question 80:

  The following SAS program is submitted:

  

  What is the value of the second variable in the data set WORK.DIGESTL?

  A. diverticulosis
  B. divertic
  C. a missing value
  D. No variables are created.
  B. divertic