The following SAS program is submitted:

What is the result?

• A.The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.
• B.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.
• C.The variable Discount in the output data set is set to zero. No messages are written to the SAS log.
• D.The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

The following SAS DATA step is submitted:
data sasdata.atlanta
sasdata.boston
work.portland
work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?

• A.The data sets listed on all the IF statements require a library reference.
• B.No library references are required.
• C.The data sets listed in the last two IF statements require a library reference.
• D.The data sets listed in the first two IF statements require a library reference.

Comment: *

Name: *

Email: *

Verification: *

Given the following data step:

After data step execution, what will data set WORK.GEO contain?

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

Comment: *

Name: *

Email: *

Verification: *

This question will ask you to provide a segment of missing code.
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be the day of the month:

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

• A.day(BeginDate)
• B.weekday(BeginDate)
• C.dayofmonth(BeginDate)
• D.getday(BeginDate)

Comment: *

Name: *

Email: *

Verification: *