SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 121:

  Given the following SAS data sets ONE and TWO:

  ONE TWO NUM CHAR1 NUM CHAR2

  1 A 2 X

  2 B 3 Y

  4 D 5 V

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

  data three;

  set one two;

  run;

  THREE

  NUM CHAR1 CHAR2

  1 A 2 B 4 D 2 X 3 Y 5 V

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

  A. proc sql; create table three as select * from one outer union corr select * from two; quit;
  B. proc sql; create table three as select * from one outer union select * from two; quit;
  C. proc sql; create table three as select * from one outer union select * quit;
  D. proc sql; create table three as select * from one union corr select * from two; quit;
  A. proc sql; create table three as select * from one outer union corr select * from two; quit;

• Question 122:

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

• Question 123:

  Which one of the following statements is true?

  A. The WHERE statement can be executed conditionally as part of an IF statement.
  B. The WHERE statement selects observations before they are brought into the PDV.
  C. The subsetting IF statement works on observations before they are read into the PDV.
  D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.
  B. The WHERE statement selects observations before they are brought into the PDV.

• Question 124:

  The following SAS program is submitted:

  %let first = yourname;

  %let last = first;

  %put andandandlast;

  Which one of the following is the result in the log of the %PUT statement?

  A. first
  B. andfirst
  C. yourname
  D. andyourname
  C. yourname

• Question 125:

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

  A. MLOGIC
  B. MDEBUG
  C. MSGLEVEL
  D. MAUTOSOURCE
  A. MLOGIC

• Question 126:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  YEAR QTR BUDGET YEAR QTR SALES

  ------------------------------- ----------------------------- 2001 3 500 2001 4 300

  2001 4 400 2002 1 600

  2002 1 700

  The following SAS program is submitted:

  proc sql;

  select one.*, sales

  from one left join two

  on one.year = two.year;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES 2001 3 500 .
  B. YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600
  C. YEAR QTR BUDGET SALES 2001 3 500 . 2001 4 400 300 2002 1 700 600
  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600
  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600

• Question 127:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  OBS COMMON X OBS COMMON Y

  ---------------------------- ------------------------------ 1 A 10 1 A 1

  2 A 13 2 A 3

  3 A 14 3 B 4

  4 B 9 4 B 2

  5 C 8 5 C 5

  6 C 14

  The following SAS DATA step is submitted:

  data combine;

  set one;

  set two;

  run;

  Which one of the following represents the data values stored in data set COMBINE?

  A. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 A 14 3 4 B 9 4 5 B 9 2 6 C 8 5 7 C 14 5
  B. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 9 4 4 C 8 5
  C. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 14 4 4 B 9 2 5 C 8 5
  D. OBS COMMON X Y 1 A 10 1 2 A 13 1 3 A 14 1 4 A 10 3 5 A 13 3 6 A 14 3 7 B 9 4 8 B 9 2 9 C 8 5 10 C 14 5
  C. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 14 4 4 B 9 2 5 C 8 5

• Question 128:

  Which one of the following options displays the value of a macro variable in the SAS log?

  A. MACRO
  B. SOURCE
  C. SOURCE2
  D. SYMBOLGEN
  D. SYMBOLGEN

• Question 129:

  Given the following SAS data set ONE:

  ONE NUM VAR

  1 A 2 B 3 C

  Which one of the following SQL programs deletes the SAS data set ONE?

  A. proc sql; delete table one; quit;
  B. proc sql; alter table one drop num, var; quit;
  C. proc sql; drop table one; quit;
  D. proc sql; delete from one; quit;
  C. proc sql; drop table one; quit;

• Question 130:

  The SAS data set ONE consists of five million observations and has 25 variables. Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?

  A. data two; set one; totrev = sum(price * quantity); totcost = sum(fixed,variable); profit = sum(totrev,otcost); if totrev > 1000; run;
  B. data two; set one; totrev = sum(price * quantity); if totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;
  C. data two; set one; totrev = sum(price * quantity); where totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;
  D. data two; set one; where totrev > 1000; totrev = sum(price * quantity); totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;
  B. data two; set one; totrev = sum(price * quantity); if totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;