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
Practice Question 66
What statement is used to identify the conditions for selecting observations
in a report?
B) IF/THEN ELSE
D) INPUT 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?
D) None of the above
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
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
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
Practice Question 72
Which of the following is not considered a character type of variable?
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.
Continue to SAS Practice Exam Question Answer Set-16
SAS interview Questions Answers
Back to SAS Practice Exam Question Answer Set-14