SAS advanced programming exam: A00-202

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?

A. 0

B. 1

C. 2

D. 5

The following SAS program is submitted:

data temp;

array points{2,3}_temporary_;

run;

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

A. 2

B. 3

C. 5

D. 6

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

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