SAS Institute A00-211 Exam Practice Questions (P. 5)

The following SAS program is submitted:

How many observations are written to the WORK.SALES data set?

The following SAS program is submitted:

The program fails execution due to syntax errors. What is the cause of the syntax error?

Given the SAS data set EMPLOYEES:

EMPLOYEES -

NAME SALARY -
-------- ------------

Innis 60000 -

Jolli 50000 -

Ellis 55000 -

Liu 45000 -
The following SAS program is submitted:
proc print data = employees; where name like _i%;
run;
What is contained in the output?

Given the SAS data set ONE:

ONE -

Obs Dte -
----- --------
1 09JAN2005
2 12JAN2005
The following SAS program is submitted:
data two;
set one;
day = <insert expression here>;
format dte date9.;
run;
The data set TWO is created:

TWO -

Obs Dte Day -
1 09JAN2005 1
12 JAN2005 4
Which expression successfully completed the program and created the variable DAY?

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;
<insert DEFINE statement here>
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?