SASInstitute SAS Institute Systems Certification A00-211 Questions & Answers

• Question 21:

  The following SAS program is submitted once:

  

  Which procedure output will appear in test.html?

  A. Only the FREQ procedure output

  B. Only the PRINT procedure output

  C. No procedure output due to syntax errors

  D. Both the PRINT procedure and FREQ procedure output

  Correct Answer: C

• Question 22:

  

  Given the following SAS log entry:

  What caused the error?

  A. The INPUT statement should be after the DATALINES statement.

  B. The CANCEL option is required with DATALINES.

  C. A semi-colon is missing on the DATALINES statement.

  D. Character data must be specified in quotes.

  Correct Answer: C

• Question 23:

  The following SAS program is submitted:

  

  If the value for the Alumcode is: ALUM2, what is the value of the variable Description?

  A. Grad Level

  B. Unknown

  C. GRAD LEVEL

  D. `' (missing character value)

  Correct Answer: A

• Question 24:

  There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:

  

  What will be the value of NewVar when SAS writes the last observation?

  A. 451

  B. 1

  C. 0

  D. . (a missing value)

  Correct Answer: A

• Question 25:

  After a SAS program is submitted, the following is written to the SAS log: What issue generated the error in the log?

  

  A. There should have been commas between the variable names.

  B. The list of variables should have been enclosed in parentheses.

  C. A drop statement and a keep= data set option cannot both be used at the same time.

  D. The syntax of the drop statement does not use an equals sign.

  Correct Answer: C

  Reference http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/ viewer.htm#a000202902.htm

• Question 26:

  The following SAS program is submitted:

  proc sort data=SASUSER.PROJECTS out=PSORT;

  by Product Code descending Date Cost;

  run;

  Which of the following is true concerning the submitted program?

  A. The descending option applies only to the Date variable.

  B. The descending option applies to the Date and Cost variables.

  C. The descending option applies to the Product and Code variables.

  D. The descending option applies only to the Code variable.

  Correct Answer: B

• Question 27:

  This question will ask you to provide a missing format: Given the contents of the raw data file 'EMPLOYEE.TXT'

  

  Which SAS information correctly completes the program?

  A. date10

  B. mmddyy10

  C. ddmmyy10

  D. date9

  Correct Answer: B

• Question 28:

  Given the data sets below: WORK.EMP with variables: WORK.NEWHIRE with variables:

  

  

  The following SAS program is submitted:

  

  The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.

  How many variables will the data set WORK.ALLEMP contain?

  A. 3

  B. The program fails execution.

  C. 6

  D. 4

  Correct Answer: A

• Question 29:

  FILL BLANK

  Given the SAS data set WORK.EMP_NAME:

  

  Given the SAS data set WORK.EMP_DEPT:

  

  The following program is submitted:

  

  How many observations are in data set WORK.ALL after submitting the program?

  A. 2

  Correct Answer: A

• Question 30:

  Given the raw data file EMPLOYEE.TXT:

  

  The following SAS program is submitted:

  

  What value does the variable idnum contain when the name of the employee is "Ruth"?

  A. 33

  B. 22

  C. 39

  D. 44

  Correct Answer: B