The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?

• A.ods file html='sales.html'; ods file close;
• B.ods html open='sales.html'; ods html close;
• C.ods file='sales.html' / html; ods file close;
• D.ods html file='sales.html'; ods html close;

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data WORK.AUTHORS;
array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');
run;
What is the value of the second variable in the dataset WORK.AUTHORS?

• A.Hemingway
• B.Hemingwa
• C.' ' (a missing value)
• D.The program contains errors. No variables are created.

Comment: *

Name: *

Email: *

Verification: *

The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
EMPLOYEE SALARY name age name salary Bruce 30 Bruce 40000 Dan 35 Bruce 35000 Dan 37000
Dan .
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?

• A.5
• B.6
• C.4
• D.2

Comment: *

Name: *

Email: *

Verification: *

This question will ask you to provide a missing option. Given the following SAS program:

Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?

• A.label = '*'
• B.labelsplit = '*'
• C.split = '*'
• D.wrap = '*'

Comment: *

Name: *

Email: *

Verification: *

The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label
of "Open Date". Which SAS program temporarily replaces the label "Open Date" with the label "Starting
Date" in the output?

• A.proc print data=SASUSER.HOUSES;
  Open_Date="Starting Date";
  run;
• B.proc print data=SASUSER.HOUSES label;
  label Open_Date "Starting Date";
  run;
• C.proc print data=SASUSER.HOUSES;
  label Open_Date="Starting Date";
  run;
• D.proc print data=SASUSER.HOUSES label;
  label Open_Date="Starting Date";
  run;

Comment: *

Name: *

Email: *

Verification: *