The following SAS program is submitted:

proc means data = sasuser.houses std mean max; var sqfeet run;

Which one of the following is needed to display the standard deviation with only two decimal places?

A. Add the option MAXDEC = 2 to the MEANS procedure statement.

B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.

C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.

D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.

A raw data file is listed below:

RANCH, 1250,2,1 Sheppard Avenue,"$64,000"

SPLIT,1 190,1,1 Rand Street"$65,850"

CONDO,1400,2,1.5,Market Street,"80,050"

TWOSTORY,1810,4,3,Garris Street,"$107,250"

RANCH,1 500 ,3,3,Kemble Avenue "$86,650"

SPLIT, 1615,4,3 ,West Drive,"94,450"

SPLIT, 1305,3,1.5,Graham Avenue "$73,650"

The following SAS program is submitted using the raw data file as input:

data work.condo_ranch

infile `file-specification' dsd

input style $ @;

if style = `CONDO' or style = `RANCH' then

input sqfeet bedrooms baths street $ price : dollar10.; run;

How many observations does the WORK.CONDO_RANCH data set contain?

A. 0

B. 3

C. 5

D. 7

The following SAS program is submitted:

proc sort data = sasuser.houses out = houses;

by style;

run;

proc print data = houses;

run;

Click on the Exhibit button to view the report produced.

Which of the following SAS statement(s) create(s) the report?

A. id style;

B. id style; var style bedrooms baths price;

C. id style; by style; var bedrooms baths price;

D. id style; by style; var style bedrooms baths price;

The SAS data set EMPLOYEE_INFO is listed below:

IDNUMBER Expenses 2542 100.00 3612 133.15

2198 234.34

2198 111.12

The following SAS program is submitted:

proc sort data = employee_info;

run;

Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

A. by descending IDNumber Expenses;

B. by (IDNumber Expenses) descending;

C. by IDNumber descending Expenses descending;

D. by descending IDNumber descending Expenses;

Click the Exhibit button to view the output of a FREQ procedure.

The variable STYLE has a permanent label of `Style of homes" and the variable BEDROOMS has a permanent label of "Number of bedrooms".

Which one of the following SAS programs produced the output shown in the exhibit?

A. proc freq data = sasuser.houses; tables style and bedrooms; run;

B. proc freq data = sasuser.houses; tables style * bedrooms; run;

C. proc freq data = sasuser.houses; tables style bedrooms; run;

D. proc freq data = sasuser.houses; tables style; tables bedrooms; run;

In the following SAS program, the input data files are sorted by the NAMES variable:

libname temp SAS-data-library';

data temp.sales;

merge temp.sales

work.receipt;

by names;

run;

Which one of the following results occurs when this program is submitted?

A. The program executes successfully and a temporary SAS data set is created.

B. The program executes successfully and a permanent SAS data set is created.

C. The program fails execution because the same SAS data set is referenced for both read and write operations.

D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.

The following SAS program is submitted:

libname temp `SAS-data-library';

data work.new;

set temp.jobs;

format newdate mmddyy10.;

qdate = qtr(newdate);

ddate = weekday(newdate);

run;

proc print data = work.new;

run;

The variable NEWDATE contains the SAS date value for April 15, 2000.

What output is produced if April 15, 2000 falls on a Saturday?

A. Obs newdate qdate ddate 1 APR152000 2 6

B. Obs newdate qdate ddate 1 04/15/2000 2 6

C. Obs newdate qdate ddate 1 APP152000 2 7

D. Obs newdate qdate ddate 1 04/15/2000 2 7

The SAS data sets WORK.EMPLOYEE and WORKSALARY are listed below:

WORK.EMPLOYEE WORK. SALARY

name age name salary

Bruce 30 Bruce 25000

Dan 40 Bruce 35000

Dan 25000

The following SAS program is submitted:

data work.empdata;

merge work.employee

work.salary;

by fname;

totsal + salary;

run;

How many variables are output to the WORK.EMPDATA data set?

A. 3

B. 4

C. 5

D. No variables are output to the data set as the program fails to execute due to errors.

The SAS data set BANKS is listed below:

BANKS

name rate

FirstCapital 0.0718

DirectBank 0.0721

VirtualDirect 0.0728

The following SAS program is submitted:

data newbank;

do year = 1 to 3;

set banks;

capital + 5000;

end;

run;

Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?

A. 0 observations and 0 variables

B. 1 observations and 4 variables

C. 3 observations and 3 variables

D. 9 observations and 2 variables

The following SAS program is submitted:

data work.test;

Author = `Agatha Christie';

First = substr(scan(author,1,' ,`)1 ,1);

run;

Which one of the following is the length of the variable FIRST in the output data set?

A. 1

B. 6

C. 15

D. 200