Online Access Free A00-202 Exam Questions

Given the following SAS data sets ONE and TWO:
ONE TWO NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN 2 FRANCE 5 TOKYO 3 GERMANY 4 BELGIUM 5 JAPAN
The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num); quit;
Which one of the following reports is generated?

• A.COUNTRY
  GERMANY JAPAN
• B.COUNTRY
  FRANCE BELGIUM
• C.COUNTRY
  CANADA FRANCE BELGIUM
• D.COUNTRY
  CANADA FRANCE GERMANY

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.2
• B.5
• C.0
• D.1
• E.5

Given the following SAS data sets ONE and TWO:
ONE TWO NUM CHAR1 NUM CHAR2
1 A 2 X 2 B 3 Y 4 D 5 V
The following SAS program is submitted creating the output table THREE:
data three; set one two; run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V
Which one of the following SQL programs creates an equivalent SAS data set THREE?

• A.proc sql;C.proc sql;
  create table three as
  select *
  from one
  union
  select *
  from two;
  quit;
• B.proc sql;D.proc sql;
  create table three as
  select *
  from one
  union corr
  select *
  from two;
  quit;
• C.proc sql;
  create table three as
  select *
  from one
  outer union
  select *
  from two;
  quit;
• D.proc sql;
  create table three as
  select *
  from one
  outer union corr
  select *
  from two;
  quit;

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

Which one of the following programs contains a syntax error?

• A.proc sql;
  select product.*, cost.unitcost, sales.quantity
  from product p, cost c, sales s
  where p.item = c.item and
• B.proc sql;
  select product.*, cost.unitcost, sales.quantity
  from product, cost, sales
  where product.item = cost.item and
  product.item = sales.item;
  quit;
• C.item = s.item;
  quit;
• D.proc sql;
  select p.*, c.unitcost, s.quantity
  from product as p, cost as c, sales as s
  where p.item = c.item and
• E.proc sql;
  select p.*, c.unitcost, s.quantity
  from product, cost, sales
  where product.item = cost.item and
  product.item = sales.item;
  quit;
• F.item = s.item;
  quit;