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 WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.

What is the result?

Reveal Solution Hide Solution

The following SAS program is submitted:

<_insert_ods_code_>

proc means data=SASUSER.SHOES;

where Product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);

run;

<_insert_ods_code_>

Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?

Reveal Solution Hide Solution

The following output is created by the FREQUENCY procedure:

Which TABLES statement was used to completed the following program that produced the output?

proc freq data=sales;

<_insert_code_>

run;

Reveal Solution Hide Solution

The following SAS program is submitted:

data work.test;

set work.staff (keep = jansales febsales marsales);

array diff_sales{3} difsales1 – difsales3;

array monthly{3} jansales febsales marsales;

run;

What new variables are created?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

The following SAS program is submitted:

data WORK.DATE_INFO;

X="01Jan1960" D;

run;

What variable X contains what value?

Reveal Solution Hide Solution

Which statement is true concerning the SAS automatic variable _ERROR_?

Reveal Solution Hide Solution