The following SAS program is submitted:

data numrecords;

infile `file specification';

input@1 patient $15.

relative$ 16-26@;

if relative = `children' then

input @54 diagnosis $15. @;

else if relative = `parents' then

input @28 doctor $15.

clinic $ 44-53

@54 diagnosis $15. @;

input age;

run;

How many raw data records are read during each iteration of the DATA step execution?

A. 1

B. 2

C. 3

D. 4

The following SAS program is submitted:

What new variables are created?

A. Difcount1, Difcount2 and Difcount3

B. Diff1, Diff2 and Diff3

C. Janpt, Febpt, and Marpt

D. Patients1, Patients2 and Patients3

The following SAS program is submitted:

What is produced as output?

A. A file named test.cvs that can only be opened in Excel.

B. A text file named test.cvs that can be opened in Excel or in any text editor.

C. A text file named test.cvs that can only be opened in a text editor.

D. A file named test.cvs that can only be opened by SAS.

Which one of the following SAS statements renames two variables?

A. set work.dept1 work.dept2(rename = (jcode = jobcode) (sal = salary));

B. set work.dept1 work.dept2(rename = (jcode = jobcode sal = salary));

C. set work.dept1 work.dept2(rename = jcode = jobcode sal = salary);

D. set work.dept1 work.dept2(rename = (jcode jobcode) (sal salary));

A raw data file is listed below:

--------10-------20-------30

John McCloskey 35 71

June Rosesette 10 43

Tineke Jones 9 37

The following SAS program is submitted using the raw data file as input:

data work.homework;

infile 'file-specification';

input name $ age height;

if age LE 10;

run;

How many observations will the WORK.HOMEWORK data set contain?

A. 0

B. 2

C. 3

D. No data set is created as the program fails to execute due to errors.

The following SAS program is submitted and reads 100 records from a raw data file:

data work.total;

infile 'file-specification' end = eof;

input name $ salary;

totsal + salary;

run;

Which one of the following IF statements writes the last observation to the output data set?

A. if end = 0;

B. if eof = 0;

C. if end = 1;

D. if eof = 1;

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. if (Age NE 16) or (Age NE 15) then Group=1;

B. where Age not between (15 and 16) then Group=1;

C. where Age not between 15 and 16 then Group=1;

D. if Age not in(15,16) then Group=1;

By default, which variables and data values are used to calculate statistics in the MEANS procedure?

A. all non-missing numeric variable values

B. all missing and non-missing numeric variable values and numbers stored as character variables.

C. all non-missing numeric variable values and numbers stored as character variables

D. all missing and non-missing numeric variable values

The following SAS program is submitted:

If the value for the Alumcode is: ALUM2, what is the value of the variable Description?

A. Grad Level

B. Unknown

C. GRAD LEVEL

D. `' (missing character value)

When SAS encounters a data when reading from a raw data file, which action will occur?

A. SAS will write an ERROR message to the SAS log and suspend execution.

B. SAS will write a WARNING message to the SAS log and suspend execution.

C. SAS will write a NOTE to the SAS log and continue execution.

D. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.