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',transwrd(shipped,date9.),'to',customer);
• B.ship_note=catx(' ','Order',order_id,'shipped on',put(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',input(shipped,date9.),'to',customer);

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

• A.' ' (missing character value)
• B.Senior Pilot
• C.Unknown
• D.SENIOR PILOT

Comment: *

Name: *

Email: *

Verification: *

Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :

Which expression successfully completed the program and creates the variable DAY?

• A.day(BeginDate)
• B.weekday(BeginDate)
• C.getday(BeginDate,today())
• D.dayofweek(BeginDate)

Comment: *

Name: *

Email: *

Verification: *

Given the SAS data set ONE:
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

Which report is produced?

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

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.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.
• B.The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
• 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: *