SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 41:

  The following SAS program is submitted:

  %let a = cat;

  %macro animal(a = frog);

  %let a = bird;

  %mend;

  %animal(a = pig)

  %put a is anda;

  Which one of the following is written to the SAS log?

  A. a is anda
  B. a is cat
  C. a is pig
  D. a is bird
  B. a is cat

• Question 42:

  Which one of the following should be avoided when creating and using an SQL procedure view?

  A. using a HAVING clause
  B. using summary functions
  C. referencing a view multiple times in the same program
  D. creating views on tables whose structures remain constant
  C. referencing a view multiple times in the same program

• Question 43:

  The following SAS program is submitted:

  %macro execute;

  proc print data = sasuser.houses;

  run;

  %end;

  %mend;

  Which of the following completes the above program so that it executes on Tuesday?

  A. %if andsysday = Tuesday %then %do;
  B. %if andsysday = 'Tuesday' %then %do;
  C. %if "andsysday" = Tuesday %then %do;
  D. %if 'andsysday' = 'Tuesday' %then %do;
  A. %if andsysday = Tuesday %then %do;

• Question 44:

  In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

  A. data three; set one; set two key = char1; run;
  B. data three; set one; if char1 in ('new york' 'los angeles'); run;
  C. data three; set one; where char1 in ('new york' 'los angeles'); run;
  D. proc sql; create table three as select * from one, two where one.char1 > two.char1; quit;
  A. data three; set one; set two key = char1; run;

• Question 45:

  Given the following SAS data set ONE:

  ONE REP COST

  SMITH 200

  SMITH 400

  JONES 100

  SMITH 600

  JONES 100

  JONES 200

  JONES 400

  SMITH 800

  JONES 100

  JONES 300

  The following SAS program is submitted:

  proc sql;

  select rep, avg(cost) as AVERAGE

  from one

  group by rep

  having avg(cost) > (select avg(cost) from one);

  quit;

  Which one of the following reports is generated?

  A. REP AVERAGE JONES 200
  B. REP AVERAGE JONES 320
  C. REP AVERAGE SMITH 320
  D. REP AVERAGE SMITH 500
  D. REP AVERAGE SMITH 500

• Question 46:

  The following SAS program is submitted:

  proc sort data = sales tagsort;

  by month year;

  run;

  Which of the following resource(s) is the TAGSORT option reducing?

  A. I/O usage only
  B. CPU usage only
  C. I/O and CPU usage
  D. temporary disk usage
  D. temporary disk usage

• Question 47:

  The following SAS program is submitted:

  options yearcutoff = 1950;

  %macro y2kopt(date);

  %if anddate >= 14610 %then %do;

  options yearcutoff = 2000;

  %end;

  %else %do;

  options yearcutoff = 1900;

  %end;

  %mend;

  data _null_ ;

  date = "01jan2000"d;

  call symput("date",left(date));

  run;

  %y2kopt(anddate)

  The SAS date for January 1, 2000 is 14610 and the SAS system option for YEARCUTOFF is set to 1920 prior to submitting the above program. Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

  A. 1900
  B. 1920
  C. 1950
  D. 2000
  D. 2000

• Question 48:

  Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

  A. NODUP
  B. UNIQUE
  C. DISTINCT
  D. NODUPKEY
  A. NODUP

• Question 49:

  The following SAS program is submitted:

  %macro test(var);

  %let jobs = BLACKSMITH WORDSMITH SWORDSMITH;

  %let type = %index(andjobs,andvar);

  %mend;

  %test(SMITH)

  Which one of the following is the resulting value of the macro variable TYPE?

  B. 3
  C. 6
  D. null
  C. 6

• Question 50:

  The following SAS code is submitted:

  %macro houses(dsn = houses,sub = RANCH);

  data anddsn;

  set sasuser.houses;

  if style = "andsub";

  run;

  %mend;

  %houses(sub = SPLIT)

  %houses(dsn = ranch)

  %houses(sub = TWOSTORY)

  Which one of the following is the value of the automatic macro variable SYSLAST?

  A. work.ranch
  B. work.houses
  C. WORK.RANCH
  D. WORK.HOUSES
  D. WORK.HOUSES