SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 111:

  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;

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

• Question 112:

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

  Given the following SAS data set ONE:

  ONE JOB LEVEL SALARY

  ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400

  The following SAS data set TWO is created:

  TWO JOB LEVEL BONUS

  ACC 2 30 MGR 3 70 MGR 2 40

  Which one of the following SAS programs creates data set TWO?

  A. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where bonus > 20; quit;
  B. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where salary > 20; quit;
  C. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated salary * 0.1 > 20; quit;
  D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;
  D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;

• Question 114:

  Given the following SAS data set ONE:

  ONE GROUP SUM

  A 765

  B 123

  C 564

  The following SAS program is submitted:

  data _null_;

  set one;

  call symput(group,sum);

  run;

  Which one of the following is the result when the program finishes execution?

  A. Macro variable C has a value of 564.
  B. Macro variable C has a value of 1452.
  C. Macro variable GROUP has a value of 564.
  D. Macro variable GROUP has a value of 1452.
  A. Macro variable C has a value of 564.

• Question 115:

  Which one of the following is the purpose of the IDXNAME= data set option?

  A. It instructs SAS to name and store a specific index.
  B. It instructs SAS to store an index in a particular location.
  C. It instructs SAS to use a specific index for WHERE processing.
  D. It instructs SAS to use any available index for WHERE processing.
  C. It instructs SAS to use a specific index for WHERE processing.

• Question 116:

  Which one of the following is the purpose of the IDXNAME= data set option?

  A. It instructs SAS to name and store a specific index.
  B. It instructs SAS to store an index in a particular location.
  C. It instructs SAS to use a specific index for WHERE processing.
  D. It instructs SAS to use any available index for WHERE processing.
  C. It instructs SAS to use a specific index for WHERE processing.

• Question 117:

  Given the following SAS data set SASUSER.HIGHWAY:

  SASUSER.HIGHWAY

  STEERING SEATBELT SPEED STATUS COUNT

  -------------------------------------------------------------------------- absent no 0-29 serious 31

  absent no 0-29 not 1419

  absent no 30-49 serious 191

  absent no 30-49 not 2004

  absent no 50+ serious 216

  The following SAS program is submitted:

  %macro highway;

  proc sql noprint;

  select count(distinct status)

  into :numgrp

  from sasuser.highway;

  %let numgrp = andnumgrp;

  select distinct status

  into :group1-:groupandnumgrp

  from sasuser.highway;

  quit;

  %do i = 1 %to andnumgrp;

  proc print data = sasuser.highway;

  where status = "andandgroupandi" ;

  run;

  %end;

  %mend;

  %highway

  How many reports are produced by the above program?

  B. 1
  C. 2
  D. 5D.5
  C. 2

• Question 118:

  Which one of the following options controls the pagesize of a SAS data set?

  A. SIZE=
  B. BUFNO=
  C. BUFSIZE=
  D. PAGESIZE=
  C. BUFSIZE=

• Question 119:

  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 50 . 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 120:

  The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ;

  Which one of the following is the maximum number of elements stored?

  A. 3
  B. 7
  C. 8
  D. 11
  C. 8