Free SASInstitute A00-202 Exam Dumps Questions & Answers

The following SAS program is submitted:
proc sql;
select *
from dictionary.tables;
quit;
Which one of the following is reported?

• A.  metadata on all tables in the DICTIONARY library only
• B.  metadata on all tables in the WORK library only
• C.  metadata on all tables in all libraries
• D.  metadata on all tables in the SASUSER library only

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 = &numgrp;
select distinct status
into :group1-:group&numgrp
from sasuser.highway;
quit;
%do i = 1 %to &numgrp;
proc print data = sasuser.highway;
where status = "&&group&i" ;
run;
%end; %mend;
%highway How many reports are produced by the above program?

• A.  5
• B.  5
• C.  1
• D.  2
• E.  0

Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

• A.  FORMAT
• B.  DISTINCT
• C.  UNIQUE
• D.  CHECK

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

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 = &numgrp;
select distinct status
into :group1-:group&numgrp
from sasuser.highway;
quit;
%do i = 1 %to &numgrp;
proc print data = sasuser.highway;
where status = "&&group&i" ;
run;
%end;
%mend;
%highway
How many reports are produced by the above program?

• A.  5
• B.  1
• C.  2
• D.  0