EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer
Physics
C.S.

SAS Programing Certification Exam

### Practice Question 51

The following SAS program is submitted:

data work.empsalary;
set work.people (in = inemp) work.money (in = insal);

if insal and inemp; run;
The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
A. 0     B. 5     C. 7     D. 12

Answer: A Since there is no BY statement. this is an example of concatenation, there is no match between each of the datasets. therefore 0 records in the output dataset

### Practice Question 52

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. @;
Click to Get Those Highly Recommended SAS Programmers' Books
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 in each iteration of the DATA step during execution?
A. 1     B. 2     C. 3     D. 4

Answer: A Here we need to determine how many records will each iteration read from the raw data file. Remember the trailing @ definition, the next input statement will read from the current record in the same datastep iteration So when we are using @ the total number of iterations would be directly proportional to the number of records in the raw data file. Take a hard look at each of the input statements the record ends a position 54 for diagnosis variable and a trailing @ so the variable age reads at probably 69 or before depending on the length of diagnosis. So each iteration would require only record from the data file.

### Practice Question 53

Which of the following is not an attribute of the program data vector?

A) Will scan data for errors
B) Is created after the creation of the input buffer
C) Refers to physical and logical memory available to the SAS program
D) Will expand as the number of variables increase

Answer: C Reasoning: The program data vector refers to logical memory only.

### Practice Question 54

Which of the following keywords is used to create a raw data file?

A) filename     B) libname     C) infile     D) set

Answer: D Reasoning: 'Libname' is used to create a library. 'Filename' will reference an external file where raw data is stored and after it has been referenced once, the 'infile' is used to identify the external file. 'Set' will create a raw data file.

### Practice Question 55

Which of the following is a standard numeric data value?

A) Integer binaries
B) Scientific notation
C) Fractions

Answer: B Reasoning: Standard numeric data values consist of positive and negative numbers, decimal points, and scientific notation.

### Practice Question 56

Which of the following options does not describe how variables are to be
used in creating a report?

A) DISPLAY     B) ACROSS     C) GROUP     D) NUMERIC

Answer: D Reasoning: There is no numeric options: the default for numeric values is ANALYSIS. Additional options not mentioned include ORDER and COMPUTED.