SAS Base Programming for SAS 9: A00-211

Read the table:

Given the SAS data set SASUSER.HOUSES:

Obs style bedrooms baths price sqteet street 1 CONDO 2 1.5 80050 1200 MAIN 2 CONDO 3 2.5 79350 1300 ELM 3 CONDO 4 2.5 127150 1400 OAK 4 CONDO 2 2.0 110700 1100 FIFTH 5 TWOSTORY 4 3.0 107250 2100 SECOND 6 TWOSTORY 2 1.0 55650 1600 WEST 7 TWOSTORY 2 1.0 69250 1450 NORTH 6 TWOSTORY 4 2.5 102950 2000 SOUTH

The following SAS program is submitted:

proc report data = sasuser.houses nowd headline;

column style price;

where price It 100000;

define price / mean width = 9 format = dollar12.;

title;

run;

The following output is desired:

style price

CONDO $79,700 TWOSTORY $62550

Which DEFINE statement completes the program and produces the desired output?

A. define style / width = 9,

B. define style / orderwidth = 9;

C. define style / group width = 9;

D. define style / display width = 9;

Which of the following programs correctly invokes the DATA Step Debugger?

A. Option A

B. Option B

C. Option C

D. Option D

The contents of the raw data file CALENDAR are listed below:

--------10-------20-------30

01012000

The following SAS program is submitted:

data test;

infile 'calendar';

input @1 date mmddyy10.;

if date = '01012000'd then event = 'January 1st';

run;

Which one of the following is the value of the EVENT variable?

A. 01012000

B. January 1st

C. . (missing numeric value)

D. The value can not be determined as the program fails to execute due to errors