EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer

SAS Programing Certification Exam
Practice Questions & Answer set-15

Practice Question 65

Which of the following items can be expected by the SORT procedure?

A) Replace the original SAS data set
B) Will not generate printed output
C) Rearrange observations in the SAS data set
D) All of the above

Answer: D Reasoning: All of the situations describe are possible with the SORT procedure.

Practice Question 66

What statement is used to identify the conditions for selecting observations
in a report?


Answer: A Reasoning: The WHERE statement will identify conditions for identifying variables and values to print in a report.

Practice Question 67

Which of the following describes the programming process of adding
observations from one data set to the observations of another data set?

A) Match-merging     B) Interweaving     C) Concatenating     D) None of the above

Answer: C Reasoning: Match merging will merge several data sets together based on the value of a common variable. Interweaving can do the same as match-weaving, but with more than one common variable. Concatenation will append, or add on, to existing data sets.

Practice Question 68

When using the VALUE statement to define the format of specific values,
which of the following statements is not correct about identifying the range.

A) A series of character values can be identified as the range for a VALUE statement

B) A single value can be identified as the range for a VALUE statement
C) A list of unique values separated by commas can be identified as range for a VALUE statement
D) A series of numeric values can be identified as the range for a VALUE statement

Answer: A Reasoning: C shows that detail is required in the answer. The range can consist of character values which are enclosed by quotation marks.

Practice Question 69

Which of the following is a true statement about executing a data step?

A) The input raw data is read from the input buffer
B) Error checking is performed at the beginning of the execution phase
C) Multiple observations can be found in a single fixed field record
D) The iteration for a DATA step refers to the number of INPUT
statement in the step

Answer: B Reasoning: Input raw data is read from the program data vector while INPUT statements are read from the input buffer. In raw data with fixed fields, a single record provides only one observation. Multiple observations can be contained in a single record for free-format files. An iteration refers to the complete cycle through the data step, typically one iteration for each observation found.

Practice Question 70

What data summarizations are provided by the PROC MEANS statement by

A) The minimum value     B) the n-count
C) The standard deviation     D) All of the above

Answer: D Reasoning: PROC MEANS will also provide the mean and the maximum value without limiting the output.

Practice Question 71

When would the keyword, FILE, be appropriate to use?

A) When attempting to describe the file where raw data is being written
B) When referencing the file to be read
C) When creating a raw data file
D) When referencing the file to be written to

Answer: D Reasoning: SET is used to create a raw data file. FILENAME references a file to be read, while FILE is used to reference a file to be written to. The PUT statement will describe the lines written to the raw data.

Practice Question 72

Which of the following is not considered a character type of variable?

A) Miller     B) Miller12     C) Miller.2     D) 2miller4u

Answer: C Reasoning: SAS naming conventions require variables names to be 1-32 characters long, can begin and consist of any combination of letters, numbers, and underscores.

Related links:

Continue to SAS Practice Exam Question Answer Set-16   SAS interview Questions Answers
Back to SAS Practice Exam Question Answer Set-14   SAS Tutorial   Statistics Tutorial