Online Access Free A00-212 Exam Questions

Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

• A.&SYSERR
• B.&SYSRC
• C.&ERR
• D.&RC

Given the following SAS data set ONE:
ONE
REP AREA COST
SMITH NORTH 100
SMITH SOUTH 200
JONES EAST 100
SMITH NORTH 300
JONES WEST 100
JONES NORTH 200
JONES NORTH 400
SMITH NORTH 400
JONES WEST 100
JONES WEST 300
The following SAS program is submitted:
proc sql;
select rep, area, count(*) as TOTAL
from one
group by rep, area;
quit;
Which one of the following reports is generated?

• A.REP AREA TOTAL
  JONES EAST 1
  JONES NORTH 2
  JONES WEST 3
  SMITH NORTH 3
  SMITH SOUTH 1
  SMITH NORTH 3
  SMITH SOUTH 1
• B.REP AREA TOTAL
  JONES EAST 1
  JONES NORTH 2
  JONES WEST 3
  SMITH NORTH 3
  JONES WEST 3
  SMITH NORTH 3
  SMITH SOUTH 1
• C.REP AREA COUNT
  JONES EAST 100
  JONES NORTH 600
  JONES WEST 500
  SMITH NORTH 800
  SMITH SOUTH 200
• D.REP AREA TOTAL
  JONES EAST 100
  JONES NORTH 600
  JONES WEST 500
  SMITH NORTH 800
  SMITH SOUTH 200

The following SAS program is submitted:
% micro test(var);
% let jobs=BLACKSMITH WORDSMITH SWORDSMITH;
% let type=%index(&jobs, &var);
% put type = &type;
% mend;
% test(SMITH)
What is the value of the macro variable TYPE when the %PUT statement executes?

• A.Null
• B.3
• C.6
• D.0

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 RANCH SPLIT SPLIT SPLIT TWOSTORY
• B.RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT
• C.CONDO RANCH SPLIT TWOSTORY
• D.RANCH SPLIT CONDO TWOSTORY

The following SAS program is submitted:
data two;
y = '2';
run;
% let x = 10;
% let var = y;
data one;
set two (keep = &var);
z = &var * &x;
run;
Which one of the following is the value of the variable Z when the program finishes execution?

• A.20 (as a numeric)
• B._ERROR_
• C.20 (as a character)
• D.. (missing numeric)