Given the following IF/THEN statement:
If Age NE 16 and Age NE 15 then Group=1;
Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?

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

Comment: *

Name: *

Email: *

Verification: *

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 Probl.
• C.The value of the DESCRIPTION variable is No Problems.
• D.The value of the DESCRIPTION variable can not be determined.

Comment: *

Name: *

Email: *

Verification: *

The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?

• A.proc print data=MYXLS.NORTH;
  run;
• B.proc print data=MYXLS.NORTH$;
  run;
• C.proc print data=MYXLS.'NORTH'e;
  run;
• D.proc print data=MYXLS.'NORTH$'n;
  run;

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

• A.there is an error and no new data sets are created
• B.2 temporary and 2 permanent SAS data sets are created
• C.3 temporary and 2 permanent SAS data sets are created
• D.2 temporary and 1 permanent SAS data sets are created

Comment: *

Name: *

Email: *

Verification: *

The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?

• A.libname qtrdata 'qtr1.xls';
• B.libname 'qtr1.xls' sheets=3;
• C.libname jan feb mar 'qtr1.xls';
• D.libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);

Comment: *

Name: *

Email: *

Verification: *