Online Access Free A00-202 Exam Questions

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 calculated salary * 0.1 > 20;
  quit;
• C.proc sql;
  create table two as
  select job, level, salary * 0.1 as bonus
  from one
  where salary > 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;

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

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

Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?

• A.proc datasets lib = sasuser._all_;
  quit;
• B.proc datasets lib = sasuser;
  contents data = _all_;
  quit;
• C.proc datasets lib = sasuser.all;
  quit;
• D.proc datasets lib = sasuser;
  contents data = all;
  quit;

The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES:
SASUSERS.HOUSES OBS STYLE
1 RANCH 2 SPLIT 3 CONDO 4 TWOSTORY 5 RANCH 6 SPLIT 7 SPLIT
The following SAS program is submitted:
proc sql noprint; select distinct style into :styles separated by ' ' from sasuser.houses order by style;
quit;
Which one of the following is the value of the resulting macro variable?

• A.CONDO RANCH SPLIT TWOSTORY
• B.RANCH SPLIT CONDO TWOSTORY
• C.CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
• D.RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

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 and subsetting IF statements can be used interchangeably in all SAS programs.
• C.The subsetting IF statement works on observations before they are read into the PDV.
• D.The WHERE statement selects observations before they are brought into the PDV.