SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 151:

  The following SAS program is submitted:

  data WORK.OUTDS;

  do until(Prod GT 6);

  Prod + 1;

  end;

  run;

  What is the value of the variable Prod in the output data set?

  A. . (missing)

  B. 6

  C. 7

  D. Undetermined, infinite loop.

  Correct Answer: C

• Question 152:

  Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

  A. proc sort out=EMPLOYEES data=EMPSORT; by Lname and Fname; run;

  B. proc sort data=SASUSER.EMPLOYEES out=EMPSORT; by Lname Fname; run;

  C. proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT; by Lname Fname; run;

  D. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT; by Lname and Fname; run;

  Correct Answer: B

• Question 153:

  Consider the data step: Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

  

  A. if Age not in(15,16) then Group=1; else Group=2;

  B. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;

  C. where Age not between 15 and 16 then Group=1; else Group=2;

  D. both A or C will work.

  Correct Answer: A

• Question 154:

  Given the following raw data records:

  

  The following output is desired:

  

  Which SAS program correctly reads in the raw data?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 155:

  Which of the following programs correctly invokes the DATA Step Debugger?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 156:

  The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;

  The following SAS program is submitted:

  

  What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

  A. LocalFee has format of 9. and CountryFee has a format of 7.

  B. LocalFee has format of 9. and CountryFee has a format of percent7.2

  C. Both LocalFee and CountryFee have a format of percent7.2

  D. The data step fails execution; there is no format for LocalFee.

  Correct Answer: C

• Question 157:

  The following SAS program is submitted:

  

  What is the initial value of the variable Total in the following program?

  A. 0

  B. Missing

  C. The value of the first observations Wagerate

  D. Cannot be determined from the information given

  Correct Answer: B

• Question 158:

  Consider the following data step:

  data WORK.NEW; set WORK.OLD;

  Count+1; run;

  The varaible Count is created using a sum statement. Which statement regarding this variable is true?

  A. It is assigned a value 0 when the data step begins execution.

  B. It is assigned a value of missing when the data step begins execution.

  C. It is assigned a value 0 at compile time.

  D. It is assigned a value of missing at compile time.

  Correct Answer: C

• Question 159:

  Given the following raw data records in TEXTFILE.TXT:

  

  The following output is desired:

  

  Which SAS program correctly produces the desired output?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 160:

  Given the SAS data set WORK.PRODUCTS:

  

  How many variables does the WORK.REVENUE data set contain?

  A. 2

  B. 3

  C. 4

  D. 6

  Correct Answer: A