SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 21:

  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, two

  where one.year = two.year;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES --------------------------------------------------------- 2001 4 400 300 2002 1 700 600
  B. YEAR QTR BUDGET SALES ---------------------------------------------------------- 2001 3 500 . 2001 4 400 300 2002 1 700 600
  C. 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 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
  C. YEAR QTR BUDGET SALES ------------------------------------------------------------ 2001 3 500 300 2001 4 400 300 2002 1 700 600

• Question 22:

  The following SAS program is submitted:

  data temp;

  array points{3,2}_temporary_ (10,20,30,40,50,60); score = points{2,1}

  run;

  Which one of the following is the value of the variable SCORE in the data set TEMP?

  A. 10
  B. 20
  C. 30
  D. 40
  C. 30

• Question 23:

  Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS System options writes that text to the log?

  A. MPRINT
  B. MLOGIC
  C. MSOURCE
  D. SOURCE2
  A. MPRINT

• Question 24:

  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;
  C. data new(bufsize = 2000 bufno = 3); set temp; run;

• Question 25:

  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
  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 26:

  The following SAS program is submitted:

  %let lib = %upcase(sasuser);

  proc sql;

  select nvar

  from dictionary.tables

  where libname = "andlib";

  quit;

  Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

  A. no result set
  B. a syntax error in the log
  C. a report showing the names of each table in SASUSER
  D. a report showing the number of columns in each table in SASUSER
  D. a report showing the number of columns in each table in SASUSER

• Question 27:

  Given the following SAS statement: %let idcode = Prod567;

  Which one of the following statements stores the value 567 in the macro variable CODENUM?

  A. %let codenum = substr(andidcode,length(andidcode)-2);
  B. %let codenum = substr(andidcode,length(andidcode)-3);
  C. %let codenum = %substr(andidcode,%length(andidcode)-2);
  D. %let codenum = %substr(andidcode,%length(andidcode)-3);
  C. %let codenum = %substr(andidcode,%length(andidcode)-2);

• Question 28:

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

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

• Question 29:

  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 30:

  Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR 2

  1 A1 2 X1

  1 A2 2 X 2

  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 X 2 2 B2 X 1 2 B2 X 2

  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;