SAS 1 EXAM -PRACTICE QUESTIONS AND ANSWERS
A record that is being held by a single trailing at sign (@) is automatically released
when:
A. another INFILE statement is executed
B. another value is read from the observation
C. the input pointer moves past the end of the record
D. the next iteration of the DATA step begins - Answers -D
What is the difference between the following two programs?
data finances;
infile 'account.dat';
input type accountnum;
inputamount;
input date date9.;
run;
and
data finances;
infile 'account.dat';
input type accountnum / amount /
date date9.;
run;
A. The step stops processing with errors in the top program because there are multiple
INPUT statements.
B. The step stops processing with errors in the right program because there are slashes
on the INPUT statement.
C. Both steps stop processing with errors.
D. Both programs run correctly and produce the same output data set - Answers -D
What is the difference between a single trailing @ and a double trailing @@?
A. there is no difference, SAS ignores the duplicate @ symbol.
B. the single trailing @ tells SAS to load the next record, and the double trailing @@
tells SAS to hold the record in the buffer.
C. the single trailing @ tells SAS to hold the record and position in the buffer, and the
double trailing @@ tells SAS to release it.
D. The single trailing @ tells SAS to hold the record and position in the buffer. The
double trailing @@ tells SAS to read the variables on the same record one after the
other, only loading a new one when the end of the record in encountered. - Answers -D
Which of the following is false about BY-group processing?
When you use the BY statement with the SET statement,
,A. FIRST. and LAST. are stored in the data set.
B. FIRST. and LAST. identify the first and last observation in each BY group, in that
order.
C. the DATA step automatically creates two variables, FIRST. and LAST. for each
variable in the BY statement.
D. the data sets that are listed in the SET statement must be indexed or sorted by the
values of the BY variable(s). - Answers -A
What is the value of first. variable for the first observation in a BY group?
a. 0
b. 1
c. missing
d. the first value of the variable - Answers -B
In a data set with 100 observations, given the following statement, how many
observations will be read?
set orion.tests (firstobs = 20 obs = 50);
a. 20 observations
b. 30 observations
c. 31 observations
d. 50 observations - Answers -C
In a data set with 100 observations, given the following statement, how many
observations will be read?
set orion.tests (firstobs = 20 obs = 10);
a. 10 observations
b. 30 observations
c. 20 observations
d. 0 observations, the obs= value cannot be less that the firstobs= value. - Answers -D
By default, PROC FREQ creates a table of frequencies and percentages for which data
set variables?
a. numeric variables
b. character variables
c. both character and numeric variables
d. none: variables must always be specified - Answers -C
What does the TABLES statement do in the PROC FREQ step?
a. it tells SAS which table to analyze
b. it tells SAS which variables to analyze
c. you do not use a TABLES statement in the PROC FREQ step.
d. it tells SAS what your table should look like. - Answers -B
, The default statistics produced by the MEANS procedure are n-count (N), mean,
minimum, maximum, and
a. range
b. median
c. standard deviation
d. standard error of the mean - Answers -C
Which statement will limit a PROC MEANS analysis to the variables tuition, meals, and
room?
a. keep tuition meals room;
b. var tuition meals room;
c. class tuition meals room;
d. tables tuition meals room; - Answers -B
The data set student.seniors includes the following variables. Which is a poor candidate
for the PROC MEANS analysis?
a. StudID
b. GPA
c. Age
d. SAT - Answers -A
How is SAS different from other programming languages?
a. the program is complied in its entirety and then executed.
b. it is not different, all programming languages are alike.
c. SAS processes each step at a time, statement by statement, independently of one
another.
d. SAS processes the first half of the program, and then the second half. - Answers -C
SAS steps begin with
a. DATA statements or PROC statements
b. DATA statements and PROC statements
c. RUN statements
d. a semicolon - Answers -A
SAS detects the end of a step when it encounters
I. a RUN statement
II. a QUIT statement
III. the beginning of another step
a. I only
b. I and II only
c. I and III only
d. I, II, and III - Answers -D
SAS will work on which of the following operating systems/platforms?
A record that is being held by a single trailing at sign (@) is automatically released
when:
A. another INFILE statement is executed
B. another value is read from the observation
C. the input pointer moves past the end of the record
D. the next iteration of the DATA step begins - Answers -D
What is the difference between the following two programs?
data finances;
infile 'account.dat';
input type accountnum;
inputamount;
input date date9.;
run;
and
data finances;
infile 'account.dat';
input type accountnum / amount /
date date9.;
run;
A. The step stops processing with errors in the top program because there are multiple
INPUT statements.
B. The step stops processing with errors in the right program because there are slashes
on the INPUT statement.
C. Both steps stop processing with errors.
D. Both programs run correctly and produce the same output data set - Answers -D
What is the difference between a single trailing @ and a double trailing @@?
A. there is no difference, SAS ignores the duplicate @ symbol.
B. the single trailing @ tells SAS to load the next record, and the double trailing @@
tells SAS to hold the record in the buffer.
C. the single trailing @ tells SAS to hold the record and position in the buffer, and the
double trailing @@ tells SAS to release it.
D. The single trailing @ tells SAS to hold the record and position in the buffer. The
double trailing @@ tells SAS to read the variables on the same record one after the
other, only loading a new one when the end of the record in encountered. - Answers -D
Which of the following is false about BY-group processing?
When you use the BY statement with the SET statement,
,A. FIRST. and LAST. are stored in the data set.
B. FIRST. and LAST. identify the first and last observation in each BY group, in that
order.
C. the DATA step automatically creates two variables, FIRST. and LAST. for each
variable in the BY statement.
D. the data sets that are listed in the SET statement must be indexed or sorted by the
values of the BY variable(s). - Answers -A
What is the value of first. variable for the first observation in a BY group?
a. 0
b. 1
c. missing
d. the first value of the variable - Answers -B
In a data set with 100 observations, given the following statement, how many
observations will be read?
set orion.tests (firstobs = 20 obs = 50);
a. 20 observations
b. 30 observations
c. 31 observations
d. 50 observations - Answers -C
In a data set with 100 observations, given the following statement, how many
observations will be read?
set orion.tests (firstobs = 20 obs = 10);
a. 10 observations
b. 30 observations
c. 20 observations
d. 0 observations, the obs= value cannot be less that the firstobs= value. - Answers -D
By default, PROC FREQ creates a table of frequencies and percentages for which data
set variables?
a. numeric variables
b. character variables
c. both character and numeric variables
d. none: variables must always be specified - Answers -C
What does the TABLES statement do in the PROC FREQ step?
a. it tells SAS which table to analyze
b. it tells SAS which variables to analyze
c. you do not use a TABLES statement in the PROC FREQ step.
d. it tells SAS what your table should look like. - Answers -B
, The default statistics produced by the MEANS procedure are n-count (N), mean,
minimum, maximum, and
a. range
b. median
c. standard deviation
d. standard error of the mean - Answers -C
Which statement will limit a PROC MEANS analysis to the variables tuition, meals, and
room?
a. keep tuition meals room;
b. var tuition meals room;
c. class tuition meals room;
d. tables tuition meals room; - Answers -B
The data set student.seniors includes the following variables. Which is a poor candidate
for the PROC MEANS analysis?
a. StudID
b. GPA
c. Age
d. SAT - Answers -A
How is SAS different from other programming languages?
a. the program is complied in its entirety and then executed.
b. it is not different, all programming languages are alike.
c. SAS processes each step at a time, statement by statement, independently of one
another.
d. SAS processes the first half of the program, and then the second half. - Answers -C
SAS steps begin with
a. DATA statements or PROC statements
b. DATA statements and PROC statements
c. RUN statements
d. a semicolon - Answers -A
SAS detects the end of a step when it encounters
I. a RUN statement
II. a QUIT statement
III. the beginning of another step
a. I only
b. I and II only
c. I and III only
d. I, II, and III - Answers -D
SAS will work on which of the following operating systems/platforms?
