SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 161:

  Which SQL procedure program deletes rows from the data set CLASS?

  A. proc sql; Select * from class Where age<(select stop_age from threshold); Quit;

  B. proc sql; Modify table class Delete where age<(select stop_age from threshold); Quit

  C. proc sql; Delete from class Where age<(select stop_age from threshold); Quit;

  D. proc sql; Alter from class Delete where age<(select stop_age from threshold); Quit;

  Correct Answer: C

• Question 162:

  Given the data set shown on the left, the SAS program on the right is submitted:

  

  Which statement is true regarding the WORK.MISSING data set?

  A. The descriptor portion of WORK.MISSING is created when the DATA step is submitted

  B. The data set is created when the DATA step is submitted

  C. When the view ONE is used in another SAS step, the data set is created

  D. The data set not created because the DATA statement contains a syntax error

  Correct Answer: D

• Question 163:

  This question will ask you to provide a segment of missing code. The following SAS program submitted:

  

  Which segment of code will successfully run an in-line view?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 164:

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

  Given the SAS data set WORK EXAM:

  TotalScore

  *

  The following SAS program is submitted:

  

  The following output is desired:

  TotalScore

  Which WHERE expression completes the program and generates the desired output?

  A. Where TotalScore is not missing

  B. Where TotalScore ne null

  C. Where TotalScore is not

  D. Where TotalScore ne missing

  Correct Answer: A

• Question 165:

  Which one of the following is an advantage of creating and using a SAS DATA step view?

  A. It can store an index.

  B. It always accesses the most current data.

  C. It works quickly through multiple passes of the data.

  D. It is useful when the underlying data file structure changes.

  Correct Answer: B

• Question 166:

  Given has SAS dataset ONE: The following SAS program is submitted:

  

  

  Proc sql;

  from one;

  quit;

  The following output is desired:

  Which SQL procedure clause completes the program and generates the desired output?

  A. Select salary, salary*.10 var=BONUS

  B. Select salary, salary*.10 label='BONUS'

  C. Select salary, salary *.10 column='BONUS'

  D. Select salary, salary*.10 name='BONUS'

  Correct Answer: B

• Question 167:

  When reading a SAS data file, what does the NOBS=option on the SET statement represent?

  A. A variable that represents the total number of observation in the output data set(s)

  B. A variable that represents a flag indicating the end of the file

  C. A variable that represents the total number of observations in the input data set(s)

  D. A variable that represents the current observation number

  Correct Answer: C

• Question 168:

  Which one of the following statements is true regarding a SAS DATA step view?

  A. It allows write capabilities.

  B. It contains global statements.

  C. It contains data and a descriptor portion.

  D. It contains a partially compiled DATA step.

  Correct Answer: D

• Question 169:

  The SAS data set TEMP has the following distribution of values for variable A: A Frequency

  1 500,000

  2 500,000

  6 7,000,000

  8 3,000

  Which one of the following SAS programs requires the least CPU time to be processed?

  A. data new; set temp; if a = 8 then b = 'Small '; else if a in(1, 2) then b = 'Medium'; else if a = 6 then b = 'Large'; run;

  B. data new; set temp; if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small'; else if a = 6 then b = 'Large'; run;

  C. data new; set temp; if a = 6 then b = 'Large '; else if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small';

  D. data new; set temp; if a = 6 then b = 'Large '; if a in (1, 2) then b = 'Small'; run;

  Correct Answer: C

• Question 170:

  The following SAS program is submitted:

  proc contents data = testdata.one;

  run;

  Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

  A. proc sql; show testdata.one; quit;

  B. proc sql; describe testdata.one; quit;

  C. proc sql; show table testdata.one; quit;

  D. proc sql; describe table testdata.one; quit;

  Correct Answer: D