Given the SAS data set WORK.ORDERS:

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: "Order 9341 shipped on 02FEB2009".
Which of the following statement will correctly create the value and assign it to Note?

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

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City_Country = substr(First,1,7)!!', '!!'England';
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?

• A.6
• B.7
• C.17
• D.25

Comment: *

Name: *

Email: *

Verification: *

The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:

What is the length of the Name variable in the data set WORK STAFF_UPDATE?

• A.10
• B.15
• C.8
• D.20

Comment: *

Name: *

Email: *

Verification: *

The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:

What is output?

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

Comment: *

Name: *

Email: *

Verification: *

The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently
ordered by Department. The following SAS program is submitted:

Which statement is true?

• A.The values of the variable Payroll represent a monthly total for all values of WAGERATE in the
  WORK.SALARY data set.
• B.The values of the variable Payroll represent the monthly total for each department in the
  WORK.SALARY data set.
• C.The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
• D.The by statement in the DATA step causes a syntax error.

Comment: *

Name: *

Email: *

Verification: *