Read the table:
Given the SAS data set SASUSER.HOUSES:
Obsstylebedroomsbathspricesqteetstreet
1CONDO21.5800501200MAIN
2CONDO32.5793501300ELM
3CONDO42.51271501400OAK
4CONDO22.01107001100FIFTH
5TWOSTORY43.01072502100SECOND
6TWOSTORY21.0556501600WEST
7TWOSTORY21.0692501450NORTH
6TWOSTORY42.5102950 2000SOUTH
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?

Given the SAS data set ONE:
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

Which report is produced?

Given the contents of the raw data file EMPLOYEE:
----|----10----|----20----|----30
Alan
19/2/2004
ACCT
Rob
22/5/2004
MKTG
MaryJane
14/3/2004
EDUC
The following SAS program is submitted:
data emps;
infile 'employee';
input@1 name$
@15 date <insert INFORMAT here>
@25 department$;
run;
Which INFORMAT correctly completes the program?

The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?

Given the data set WORK.EMPDATA:

Which one of the following where statements would display observations with job titles containing the word 'Manager'?