The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 ='Pre-Teen'
13-high = 'Teen';
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification: Which statement below was modified or added to generate the results above:

• A.proc means data=SASHELP.CLASS min max mean maxdec=1;
• B.proc means data=SASHELP.CLASS maxdec=1 ;
• C.var Height / nobs min max mean maxdec=1;
• D.output nobs min max mean maxdec=1;

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

Which statement describes a characteristic of the SAS automatic variable _ERROR_?

• A.The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
• B.The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
• C.The _ERROR_ variable can be used in expressions in the DATA step.
• D.The _ERROR_ variable contains the number of the observation that caused the data error.

Comment: *

Name: *

Email: *

Verification: *

The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?

• A.$25.31
• B.25.31
• C.No value is stored as the program fails to execute due to errors.
• D.. (missing numeric value)

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
libname company 'SAS-data-library';
proc sort data = company.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?

• A.COMPANY.PAYROLL is stored in original order, and a new data set
  COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.
• B.COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
• C.COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
• D.COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber

Comment: *

Name: *

Email: *

Verification: *