The following SAS program is submitted:

data work.empsalary;

set work.people (in = inemp)

work.money (in = insal);

if insal and inemp;

run;

The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7

observations. How many observations will the data set WORK.EMPSALARY contain?

A. 0

B. 5

C. 7

D. 12

The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:

WORK.ONE Num Char

1 23 3 23 1 77 The following SAS program is submitted: proc print data=WORK.ONE;

where Num='1'; run;

What is output?

A. Num Char 1 23

B. Num Char

1 23

1 77

C. Num Char

1 23

3 23

1 77

D. No output is generated.

Given the SAS data set WORK.ONE:

And the SAS data set WORK.TWO:

The following program is submitted: What is the first observation in the SAS data set WORK.BOTH?

A. Option A

B. Option B

C. Option C

D. Option D

A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

A. proc print data = sasuser.houses; where price lt 60000; where price gt 100000; run;

B. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;

C. proc print data = sasuser.houses; where price lt 60000 and price gt 100000; run;

D. proc print data = sasuser.houses; where price lt 60000 or where price gt 100000; run;

The following SAS program is submitted:

data work.january;

set work.allmonths (keep = product month num_sold cost);

if month = 'Jan' then output work.january;

sales = cost * num_sold;

keep = product sales;

run;

Which variables does the WORK.JANUARY data set contain?

A. PRODUCT and SALES only

B. PRODUCT, MONTH, NUM_SOLD and COST only

C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

D. An incomplete output data set is created due to syntax errors.