SAS Institute SAS Institute Certifications A00-280 Questions & Answers

• Question 81:

  Review the following procedure format:

  

  What is the required type of data for the variable in this procedure?

  A. Character

  B. Continuous

  C. Categorical

  D. Treatment

  Correct Answer: B

• Question 82:

  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;

  Correct Answer: B

• Question 83:

  Given the data set WORK.BP with the following variable list:

  

  Which output will be created by the program?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 84:

  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;

  Correct Answer: C

• Question 85:

  Given the following data set:

  

  Which SAS program produced this output?

  A. proc sort data=one(where=(age>50)) out=two; by subjid; run;

  B. proc sort data=one(if=(age>50)) out=two; by subjid; run;

  C. proc sort data=one out=two; where=(age>50); by subjid; run;

  D. proc sort data=one out=two; if age>50; by subjid; run;

  Correct Answer: A

• Question 86:

  Which statement correctly adds a label to the data set?

  A. DATA two Label="Subjects having duplicate observations"; set one; run;

  B. DATA two; Label="Subjects having duplicate observations"; set one; run;

  C. DATA two; set one; Label dataset="Subjects having duplicate observations"; run;

  D. DATA two(Label="Subjects having duplicate observations"); set one; run;

  Correct Answer: D

• Question 87:

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

  The following SAS program is submitted:

  

  Which statement is required to produce this output?

  A. TABLES site*group /nocol;

  B. TABLES site*group /norow;

  C. TABLES site*group;

  D. TABLES site*group /nocol norow;D. TABLES site*group /nocol norow;

  Correct Answer: A

• Question 88:

  Given the following data set:

  

  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;

  Correct Answer: B

• Question 89:

  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?

  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.

  Correct Answer: B

• Question 90:

  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

  Correct Answer: AC