After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
-----
22
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
, <=, <>, =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?

• A. (drop Month Quantity Cost)
• B. (drop=Month Quantity Cost)
• C. (drop Month, Quantity, Cost)
• D. (drop=Month, Quantity, Cost)

CORRECT TEXT
The following SAS program is submitted:

What value will SAS assign to Pos? Enter your numeric answer in the space below.

12

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);

Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input@1 salary 6.;
if_error_then description = 'Problems';
else description = 'No Problems';
run;
What is the result?

• A. The value of the DESCRIPTION variable is Problems.
• B. The value of the DESCRIPTION variable is No Problems.
• C. The value of the DESCRIPTION variable is No Probl.
• D. The value of the DESCRIPTION variable can not be determined.

The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.
Which statement is true?

• A. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
• B. The statement payroll + wagerate; in the DATA step causes a syntax error.
• C. The BY statement in the DATA step causes a syntax error.
• D. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.