Given the SAS data set WORK.TEMPS:

The following program is submitted: Which output is correct?

• A.Option D
• B.Option C
• C.Option B
• D.Option A

Comment: *

Name: *

Email: *

Verification: *

This questions will ask you to provide two missing variable names.
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First. <insert variable 1 here> then Payroll=0
Payroll+Wagerate;
if Last.<insert variable 2 here>;
run;
The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

• A.variable 1: Department variable 2: Gender
• B.variable 1: Department variable 2: Department
• C.variable 1: Gender variable 2: Department
• D.variable 1: Gender variable 2: Gender

Comment: *

Name: *

Email: *

Verification: *

Given the SAS data set WORK.ORDERS:

The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".
Which of the following statement will correctly create the value and assign it to ship_note?

• A.ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);
• B.ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
• C.ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
• D.ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:

What is the result?

• A.The value of the variable Discount in the output data set is 2000. No messages are written to the SAS
  log.
• B.The value of the variable Discount in the output data set is missing. A note in the SAS log refers to
  invalid numeric data.
• C.The value of the variable Discount in the output data set is 2000. A note that conversion has taken
  place is written to the SAS log.
• D.The variable Discount in the output data set is set to zero. No messages are written to the SAS log.

Comment: *

Name: *

Email: *

Verification: *

Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a
RETAIN statement and an Assignment statement. Which statement regarding this program is true?

• A.The assignment statement is fine, but the value of City will be truncated to 8 bytes as the
  LENGTH statement has been omitted.
• B.Both the RETAIN and assignment statement are being used to initialize new variables and are equally
  efficient. Method used is a matter of programmer preference.
• C.City's value will be assigned one time, State's value 5 times.
• D.The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the
  LENGTH statement has been omitted.

Comment: *

Name: *

Email: *

Verification: *