SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 121:

  When is it appropriate to create indexes on a SAS data set for efficient processing?

  A. if small subsets of data are often retrieved
  B. if the key variable has very few unique values
  C. if the data are often used for BY group processing
  D. if the SAS data set file page count is less than three pages
  A. if small subsets of data are often retrieved

• Question 122:

  The SAS data set ONE contains the variables X, Y, Z, and W.

  The following SAS program is submitted:

  proc transpose data = one

  out = trans

  name = new;

  by x;

  var y;

  run;

  Which one of the following contains all the names of the columns created by the

  TRANSPOSE procedure?

  A. X, Y, Z, and W
  B. _NAME_, X, and Y
  C. new, X, and COL1
  D. new, X, Y, and _COL1_
  C. new, X, and COL1

• Question 123:

  The following SAS program is submitted:

  %macro loop;

  data one;

  %do I=1 %to 3;

  varandI=andI;%

  end

  run;

  %mend;

  %loop

  After this program executes; the following is written to the SAS log:

  (LOOP): Beginning execution

  (LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is (LOOP): %DO loop index variable l is now 2; loop will iterate again

  (LOOP): %DO loop index variable l is no 3; loop will iterate again

  (LOOP): %DO loop index variable l is no 4; loop will iterate again

  (LOOP): Ending execution

  Which SAS system option displays the notes in the SAS log?

  A. SYMBOLGEN
  B. MLOGIC
  C. MACRO
  D. MPRINT
  B. MLOGIC

• Question 124:

  This question will ask you to provide a segment of missing code. Given the following program and data:

  

  What is the WHERE statement that successfully completes the PROC PRINT and selects the observation from Barb?

  A. Where Birthday=and"Want";
  B. Where Birthday=and`Want' d;
  C. Birthday=andWant;
  D. Birthday=and"Want" d;
  A. Where Birthday=and"Want";

• Question 125:

  The following SAS program is submitted:

  data new (bufnp=4);

  set old(bufno=4);

  run;

  Why are the BUFNO options used?

  A. To reduce the number I/O operations
  B. To reduce network traffic
  C. To reduce memory usage
  D. To reduce the amount of data read
  A. To reduce the number I/O operations

• Question 126:

  The following SAS FORMAT procedure is submitted:

  proc format lib = sasuser;

  value tempc low < 0 = 'BELOW FREEZING'

  0 < 5 = 'COLD'

  5 < 10 = 'MILD'

  10 < 15 = 'WARM'

  15 high = 'HOT';

  run;

  How is the value 10 displayed when the format TEMPC is applied?

  A. 10
  B. MILD
  C. WARM
  D. BELOW FREEZING
  C. WARM

• Question 127:

  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;
  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;

• Question 128:

  Which PUT statements will be the log if the program is submitted at the beginning of a new SAS session?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 129:

  The following SAS program is submitted:

  

  What is written to the SAS log?

  A. andName2
  B. MATH3
  C. WARNING: Apparent symbolic reference ROOT2 not resolved
  D. MATH1
  B. MATH3

• Question 130:

  The following SAS program is submitted:

  ;

  %let development = ontime;

  proc print data = sasuser.highway;

  title "For anddept";

  title2 "This project was completed anddevelopment";

  run;

  Which one of the following statements completes the above and resolves title1 to "For

  researchanddevelopment"?

  A. %let dept = %str(researchanddevelopment);
  B. %let dept = %str(research%anddevelopment);
  C. %let dept = %nrstr(researchanddevelopment);
  D. %let dept = %nrstr(research%anddevelopment);
  C. %let dept = %nrstr(researchanddevelopment);