The contents of the raw data file SIZE are listed below:
--------10-------20-------30
72 95
The following SAS program is submitted:
data test;
infile 'size';
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?

• A.72
• B..(missing numeric value)
• C.95
• D.2

Comment: *

Name: *

Email: *

Verification: *

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;

• A.tables region product;
• B.tables region*product;
• C.tables region/product;
• D.tables region,product

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 the monthly total for each department in the WORK.SALARY data set.
• B.The statement Payroll+(MonthlyWageRate*12); 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 monthly total for all values of WAGERATE in the WORK.SALARY data set.

Comment: *

Name: *

Email: *

Verification: *

Consider the data step:

Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

• A.if Age not in(15,16) then Group=1; else Group=2;
• B.if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
• C.both A or C will work.
• D.where Age not between 15 and 16 then Group=1; else Group=2;

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data combine;
prefix='505';
middle='6465 ';
end='09090';
<insert statement here>;
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

• A.total = prefix !!'-'!! middle ''!!'-'!! end;
• B.total = catx('-', prefix, middle, end);
• C.total = prefix!!'-'!! left(middle)!!'-'!! end;
• D.total = cat('-', prefix, middle, end);

Comment: *

Name: *

Email: *

Verification: *