Pass A00-211 Exam Guide

Given the AIRPLANES data set

AlRPLANES

TYPE MPG

-------- ------

F-18 105

C-130 25

Harrier 75

A-6 110

The following SAS program is submitted:

data gt100;

set airplanes(keep = type mpg load);

load = mpg * 150;

run;

The program fails to execute due to syntax errors.

What is the cause of the syntax error?

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?

The following SAS program is submitted:

Data_null_;

set old;

put sales 1 sales2;

run;

Where is the output written?

The following SAS program is submitted:

data work.sets;

do until (prod gt 6);

prod + 1;

end;

run;

What is the value of the variable PROD in the output data set?