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?

• A.LOAD must be defined prior to the SET statement.
• B.LOAD is not a variable in the data set GT100.
• C.MPG is not a numeric variable.
• D.LOAD is not variable in the data set AIRPLANES.

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data work. new;
length word $7;
amount = 4;
it amount = 4 then word = 'FOUR';
else if amount = 7
then word = 'SEVEN';
else word = 'NONE!!!';
amount = 7;
run;
What are the values of the AMOUNT and WORD variables in SAS dataset work.new?

• A.amount word 4 NONE!!!
• B.amount word 7 FOUR
• C.amount word 4 FOUR
• D.amount word 7 SEVEN

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

• A.The output displays only the metadata of the SAS data sets that are contained in the WORK library.
• B.The output displays only a list of the SAS data sets that are contained in the WORK library.
• C.The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.
• D.The output displays only the variables in the SAS data sets that are contained in the WORK library.

Comment: *

Name: *

Email: *

Verification: *

Given the raw data file YEARAMT:
----|---10---|---20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile 'yearamt';
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?

• A.retain totquantity0; totquantity = totquantity + quantity;
• B.totquantity = sum(totquantity + quantity);
• C.totquantity + quantity;
• D.retain totquantity; totquantity = totquantity + quantity;

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;
What is the value of the CITY variable?

• A.Copenhagen
• B.Copenh
• C.Other
• D.''(missing character value)

Comment: *

Name: *

Email: *

Verification: *