SAS Programing Certification Exam
Practice Questions & Answer set-17
Practice Question 80
Which character function would be used to remove extra spaces from
D) CATX Answer: D
Reasoning: CATX is the most correct answer as it removes both
leading and trailing blanks from character strings. TRIM only
removes the trailing blanks from character values.
Practice Question 81
Which programming statement is used to perform conditional processing on
Click to Get Those Highly Recommended SAS Programmers' Books
groups of SAS statements?
D) IF/THEN Answer: A
Reasoning: The key word in this question is "group". Conditional
processing can be performed using some iteration of BY, WHERE,
and IF/THEN, but DO provides an opportunity to group statements
Practice Question 82
What is the purpose of the SUM statement?
A) To combine numeric variables
B) To obtain a total output of multiple values
C) To produce column totals
D) All of the above Answer: C
Reasoning: In creating reports for SAS programs, the SUM
statement is used to create column totals for numeric values
Practice Question 83
Which location pointer identifies the exact line number from which to begin
reading data from?
A) #n pointer
B) input pointer
C) / pointer
D) Column pointer Answer: A
Reasoning: The #n pointer references the absolute number of the
line for moving the pointer to read data.
Practice Question 84
What would be the correct raw data value of a datatime field for Dec 15,
1986 10:00pm for SAS?
D) 121519862200 Answer: C
Reasoning: The datetime value is the number of seconds from
midnight on 1/1/1960. This of course would be a rather large number,
in fact, 120 seconds from 10942 days (including 7 extra days from
leap years). The last answer is incorrect as it is the date and time
written out without any delimiters.
Practice Question 85
Each data set has a descriptive portion providing useful information about
the data set. Which of the following items would not be found in the
A) Creation data and time
B) Set name
C) Information on labels
D) Error messages Answer: D
Reasoning: Error messages are found in the program log, not the
descriptive portion of the data set.
Practice Question 86
Which of the following statements is not true for list inputs?
A) Fields cannot be skipped or re-read
B) Fields are read from left to right
C) Fields must be separated by a delimiter
D) The MISSOVER option must be used at all times to read missing
values Answer: D
Reasoning: If missing values are represented by a special character
that is not used as a separated of data, then the MISSOVER option is
Practice Question 87
Which of the following statements is not correct about crosstabulation of
A) Frequency calculations for number of cells that appear will be
included in table
B) Crosstabulation is used when comparing three or more distinct
C) The first variable listed in the TABLES statement will define the rows
of the table
D) Each level of variables will be represented by a separate two-way
table Answer: B
Reasoning: Crosstabulation is used when comparing two distinct
variables. More variables may be compared as well.
Continue to SAS Practice Exam Question Answer Set-18
SAS interview Questions Answers
Back to SAS Practice Exam Question Answer Set-16