SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 101:

  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.
  D. It contains a partially compiled DATA step.

• Question 102:

  Given the following SAS program:

  proc sql;

  select product, type, sum(sales) as revenue

  from one

  group by product, type;

  quit;

  Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

  A. order by 1, 3
  B. order by 1, 3 desc
  C. orderby product, revenue desc
  D. order by product, desc revenue
  B. order by 1, 3 desc

• Question 103:

  The following SAS program is submitted:

  %let var = chicago, 1;

  data a;

  var = 'new york, 2';

  newvar = %scan(andvar,2,%str());

  run;

  Which one of the following explains why the program fails to execute?

  A. The %STR() is invalid syntax.
  B. The %SCAN function does not exist.
  C. The %SCAN function has too many arguments.
  D. The macro variable VAR does not get created properly.
  C. The %SCAN function has too many arguments.

• Question 104:

  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;C.proc sql; create table three as select * from one union select * from two; quit;
  D. proc sql;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 105:

  The following SAS program is submitted: %let name = Patel's Restaurant;

  Which one of the following statements avoids problems associated with the unbalanced quotation mark?

  A. %let name = Patel%'s Restaurant;
  B. %let name = %str(Patel's Restaurant);
  C. %let name = Patel%str(')s Restaurant;
  D. %let name = %str(Patel%'s Restaurant);
  D. %let name = %str(Patel%'s Restaurant);

• Question 106:

  The following SAS program is submitted:

  data new (bufsize = 6144 bufno = 4);

  set old;

  run;

  Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

  A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.
  B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.
  C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.
  D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.
  B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.

• Question 107:

  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'; run;
  D. data new;D.data new; set temp; if a = 6 then b = 'Large '; if a in (1, 2) then b = 'Medium'; if a = 8 then b = 'Small'; 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'; run;

• Question 108:

  Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

  A. It temporarily compresses observations in a SAS data set.
  B. It allows users to update the same SAS data set concurrently.
  C. It allows new observations to be inserted wherever enough free space exists.
  D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.
  C. It allows new observations to be inserted wherever enough free space exists.

• Question 109:

  Given the following SAS data set ONE:

  ONE LEVEL AGE

  1 10 2 20 3 20 2 10 1 10 2 30

  3 10

  2 20

  3 30

  1 10

  The following SAS program is submitted:

  proc sql;

  select level, max(age) as MAX

  from one group by level

  having max(age) > (select avg(age) from one);

  quit;

  Which one of the following reports is generated?

  A. LEVEL AGE 2 20 3 20
  B. LEVEL AGE 2 30 3 30
  C. LEVEL MAX 2 20 3 30
  D. LEVEL MAX 2 30 3 30
  D. LEVEL MAX 2 30 3 30

• Question 110:

  The following SAS program is submitted:

  %macro test(var);

  proc print data = sasuser.class;

  where age > andvar;

  run;

  %mend;

  Which type of parameter is the macro variable VAR?

  A. default
  B. keyword
  C. positional
  D. command
  C. positional