SAS Programing Certification Exam
Practice Questions & Answer set-14
Practice Question 57
Which of the following methods for combining data sets is distinguished for
its use of the BY statement?
D) None of the above Answer: A
Reasoning: Match-merging is distinguished by the MERGE
statement and concatenation by multiple
SET statements. The
interweaving method uses BY statements to choose which
observations are appropriate from each of the data sets. Though the
match-merging method also uses BY statements to focus the
observations used, it must have the MERGE statement to perform
Practice Question 58
Which of the following is not an error identified during the compilation
A) Quotation marks are unbalances
B) No RUN statement in the step
C) An option is invalid
D) Semicolons are missing in statements Answer: B
Reasoning: The compilation phase will identify most syntax errors,
while the executing phase will identify processing errors. No RUN or
QUIT statement will result in processing to continue indefinitely.
Practice Question 59
Which of the following programming conventions can be used in conjunction
with the line-hold specifier, @@?
A) @ pointer control
B) MISSOVER option
C) column input
D) INPUT statement Answer: D
Reasoning: A, B, C should not be used with the double training at
Practice Question 60
What must happen for DO Loops to be nested within each other?
A) Each DO loop must end in a RUN statement
B) A condition must be in place to determine if the DO loop should be
C) An OUTPUT statement is required to ensure the result of the DOloop
D) A unique index-variable name must be assigned for each iterative
DO statement Answer: D
Reasoning: DO statements must end with an END statement. A
condition is not necessary. The OUTPUT statement is used to create
observations for each iteration of the DO loop. A unique indexvariable
name is required when nesting DO loops.
Practice Question 61
Which of the following in a correctly created data set name?
Click to Get Those Highly Recommended SAS Programmers' Books
D) create\B4infinity Answer: B
Reasoning: Data set names can be 1-32 characters long and
consists and begin with alphanumeric characters and underscores.
Practice Question 62
When are SAS arrays not used?
A) SAS arrays are used to compare variables
B) SAS arrays are used to change variables to observations
C) SAS arrays are used to group data within the data set
D) SAS arrays are used to perform repetitive calculations
Reasoning: SAS arrays are a temporary grouping of variables that
exist for the duration of a data step. They will not 'group' data within
the data set.
Practice Question 63
Several libraries are created during a SAS session by default. Which of the
following is not one of those libraries?
D) Work Answer: B
Reasoning: All of the libraries are created by default except libref,
which is not a library but a keyword for naming a library.
Practice Question 64
When is character-to-numeric conversion not automatically performed?
A) When used in an arithmetic operation
B) When used within a WHERE statement
C) When compared to a numeric value
D) When assigned a defined numeric variable Answer: B
Reasoning: A WHERE statement will not use automatic conversion of
Continue to SAS Practice Exam Question Answer Set-15
SAS interview Questions Answers
Back to SAS Practice Exam Question Answer Set-13