SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 111:

  Given the SAS data set ONE:

  ONE

  DIVISION SALES

  A 1234

  A 3654

  B 5678

  The following SAS program is submitted:

  Data_null_;

  Set one;

  By divition;

  If first.division then

  Do;

  %let mfirst=sales;

  end;

  run;

  What is the value of the macro variable MFRIST when the program finishes execution?

  A. 1234

  B. sales

  C. 5678

  D. null

  Correct Answer: B

• Question 112:

  Given the following SAS data set ONE: ONE REP AREA COST SMITH NORTH 100 SMITH SOUTH 200 JONES EAST 100

  SMITH NORTH 300 JONES WEST 100 JONES NORTH 200 JONES NORTH 400 SMITH NORTH 400 JONES WEST 100 JONES WEST 300 The following SAS program is submitted: proc sql; select rep, area, count(*) as TOTAL from one group by rep, area; quit;

  Which one of the following reports is generated?

  A. REP AREA COUNT JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200

  B. REP AREA TOTAL JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200

  C. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1

  D. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1 SMITH NORTH 3 SMITH SOUTH 1

  Correct Answer: CD

• Question 113:

  Which title statement would always display current date?

  A. title " Today is: and today.";

  B. title "Today is: sysfunc (today (), worddate)";

  C. title "Today is: and sysdate. ";

  D. title "Today is: andsysdate.";

  Correct Answer: D

• Question 114:

  Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?

  A. CHECK

  B. NOT NULL

  C. PRIMARY KEY

  D. UNIQUE

  Correct Answer: A

• Question 115:

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

  Given the SAS data set SASUSER.ORDERS:

  

  The following SAS program is submitted:

  

  Which statement completes the program completely so that it will produce a report with the total number of orders for California?

  A. Call syntax (`num' California)

  B. Num = California

  C. andnum = California

  D. Syntax (`num', California)

  Correct Answer: B

• Question 116:

  Which one of the following options is available for SAS macro debugging?

  A. MLOGIC

  B. MDEBUG

  C. MSGLEVEL

  D. MAUTOSOURCE

  Correct Answer: A

• Question 117:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  NUM CHAR1 NUM CHAR2

  1 A1 2 X1

  1 A2 2 X2

  2 B1 3 Y

  2 B2 5 V

  4 D

  The following SAS program is submitted creating the output table THREE:

  proc sql; create table three as

  select one.num, char1, char2

  from one, two

  where one.num = two.num;

  quit;

  THREE

  NUM CHAR1 CHAR2

  2 B1 X1

  2 B1 X2

  2 B2 X1

  2 B2 X2

  Which one of the following DATA step programs creates an equivalent SAS data set THREE?

  A. data three; merge one two; by num; run;

  B. data three; set one; set two; by num; run; merge one two; by num; run;

  C. data three; set one; set two; by num; run; by num; run;

  D. data three; set one; do i = 1 to numobs; set two(rename = (num = num2)) point = i nobs = numobs; if num2 = num then output; end; drop num2; run;

  Correct Answer: D

• Question 118:

  Which one of the following SAS programs uses the most amount of memory resources for output buffers?

  A. data new(bufsize = 1000 bufno = 5); set temp; run;

  B. data new(bufsize = 1000 bufno = 2); set temp; run;

  C. data new(bufsize = 2000 bufno = 3); set temp; run;

  D. data new(bufsize = 4000 bufno = 1); set temp; run;

  Correct Answer: C

• Question 119:

  Given the SAS data set SAUSER.HIGWAY: SASUSER.HIGHWAY

  

  The following SAS program is submitted:

  %macro highway;

  proc sql nonprint;

  %let numgrp=6;

  select distinct status into:group1-:groupandnumgrp from sasuser.highway;

  quit;

  %do i=1 %to andnumgrp;

  proc print data =sasuser.highway;

  where status ="andandgroupandI";

  run;

  %end;

  %mend;

  %highway

  How many reports are produced?

  A. 2

  B. 6

  C. 0

  D. 5

  Correct Answer: A

• Question 120:

  Given the non-indexed SAS data set TEMP: TEMP X Y

  P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: Proc print data=temp; run; Which BY statement completes the program, creates a listing report that is grouped by X and completes without errors?

  A. By X notsorted;

  B. By X grouped;

  C. By Descending X;

  D. By X;

  Correct Answer: A