SAS PROGRAMMING CERTIFICATION
TEST QUESTIONS WITH COMPLETE
SOLUTIONS
13.2 What is an advantage of storing dates and times as SAS numeric date and time
values?
a. They can easily be edited.
b. They can easily be read and understood.
c. They can be used in text strings like other character values.
d. They can be used in calculations like other numeric values. - Answer- Correct
answer: d
In addition to tracking time intervals, SAS date and time values can be used in
calculations like other numeric values
2.2 How many program steps are executed when the program below is processed?
data user. Tables;
set work.jobs;
run;
proc sort data=user. Tables;
by name;
run;
proc print data=user. Tables;
run;
A. 3
B. 4
C. 5
D. 6 - Answer- Correct answer: a
When it encounters a DATA, PROC, or RUN statement, SAS stops reading statements
and executes the previous step in the program. This program contains one DATA step
and two PROC steps, for a total of three program step
2.5 With the system option VALIDVARNAME=ANY, which of the following variable
names is valid?
a. 4BirthDate
b. $Cost
c. _Items_
d. Tax-Rate
e. All of the above - Answer- Correct answer: e
If you use VALIDVARNAME=ANY, the name can begin with or contain any characters,
including blanks, national characters, special characters, and multi-byte characters. The
name can be up to 32 bytes long. The name must contain at least one character, and
the variable name can contain mixed-case letters
,2.6 Which of the following files is a permanent SAS file?
a. Work.PrdSale
b. Cert.MySales
c. Certxl.Quarter1
d. only b and c above
e. all of the above - Answer- Correct answer: d
To store a file permanently in a SAS data library, you assign it a libref. For example, by
assigning the libref Cert to a SAS data library, you specify that files within the library are
to be stored until you delete them. Therefore, SAS files in the Cert and Certxl libraries
are permanent files
2.7 In a DATA step, how can you reference a temporary SAS data set named Forecast?
a. Forecast
b. Work. Forecast
c. Sales. Forecast (after assigning the libref Sales)
d. only a and b above - Answer- Correct answer: d
To reference a temporary SAS file in a DATA step or PROC step, you can specify the
one-level name of the file (for example, Forecast) or the two-level name using the libref
Work (for example, Work.Forecast).
2.9 How many statements does the following SAS program contain?
proc print data=cert admit
label double;
var ID Name Sex Age;
where Sex=F;
label Sex='Gender';
run;
a. three
b. four
c. five
d. six - Answer- Correct answer: c
The five statements are 1) the PROC PRINT statement (two lines long); 2) the VAR
statement; 3) the WHERE statement (on the same line as the VAR statement); 4) the
LABEL statement; and 5) the RUN statement (on the same line as the LABEL
statement).
2.10 What is a SAS library?
a. a collection of SAS files, such as SAS data sets and catalogues
b. in some operating environments, a physical collection of SAS files
c. a group of SAS files in the same folder or directory
d. all of the above - Answer- Correct answer: d
Every SAS file is stored in a SAS library. A SAS library is a collection of SAS files, such
as SAS data sets and catalogues. In some operating environments, a SAS library is a
physical collection of files. In others, the files are only logically related. In the Windows
, and UNIX environments, a SAS library is typically a group of SAS files in the same
folder or directory
3.1 How long do librefs remain in effect?
a. until the LIBNAME statement is changed
b. until the LIBNAME statement is canceled
c. until the SAS session ends
d. All of the above - Answer- Correct answer: d
Librefs remain in effect until the LIBNAME statement is changed, cancelled, or until the
SAS session ends
3.2 Which of the following statements are true?
a. When using the default engine, you do not have to specify the libref in the LIBNAME
statement.
b. When using the default engine, you do not have to specify the engine name in the
LIBNAME statement.
c. When using the default engine, you do not have to specify the SAS library in the
LIBNAME statement.
d. When using the default engine, you have to specify the libref, engine name, and the
SAS library in the LIBNAME statement. - Answer- Correct answer: b
When you are using the default engine, you do not have to specify the engine name in
the LIBNAME statement. However, you do have to specify the libref and the SAS data
library name.
3.3 When you specify an engine for a library, what are you specifying?
a. the file format for files that are stored in the library
b. the version of SAS that you are using
c. access to other software vendors' files
d. instructions for creating temporary SAS files - Answer- Correct answer: a
A SAS engine is a set of internal instructions that SAS uses for writing to and reading
from files in a SAS library. Each engine specifies the file format for files that are stored
in the library, which in turn enables SAS to access files with a particular format. Some
engines access SAS files, and other engines support access to other vendors' file
3.4 Which statement prints a summary of all the files stored in the library named
Area51?
a. proc contents data=area51._all_ nods;
b. proc contents data=area51 _all_ nods;
c. proc contents data=area51 _all_ noobs;
d. proc contents data=area51 _all_.nods; - Answer- Correct answer: a
To print a summary of library contents with the CONTENTS procedure, use a period to
append the _ALL_ option to the libref. Adding the NODS option suppresses detailed
information about the files
3.5 Which of the following programs correctly references a SAS data set named
SalesAnalysis that is stored in a permanent SAS library?
TEST QUESTIONS WITH COMPLETE
SOLUTIONS
13.2 What is an advantage of storing dates and times as SAS numeric date and time
values?
a. They can easily be edited.
b. They can easily be read and understood.
c. They can be used in text strings like other character values.
d. They can be used in calculations like other numeric values. - Answer- Correct
answer: d
In addition to tracking time intervals, SAS date and time values can be used in
calculations like other numeric values
2.2 How many program steps are executed when the program below is processed?
data user. Tables;
set work.jobs;
run;
proc sort data=user. Tables;
by name;
run;
proc print data=user. Tables;
run;
A. 3
B. 4
C. 5
D. 6 - Answer- Correct answer: a
When it encounters a DATA, PROC, or RUN statement, SAS stops reading statements
and executes the previous step in the program. This program contains one DATA step
and two PROC steps, for a total of three program step
2.5 With the system option VALIDVARNAME=ANY, which of the following variable
names is valid?
a. 4BirthDate
b. $Cost
c. _Items_
d. Tax-Rate
e. All of the above - Answer- Correct answer: e
If you use VALIDVARNAME=ANY, the name can begin with or contain any characters,
including blanks, national characters, special characters, and multi-byte characters. The
name can be up to 32 bytes long. The name must contain at least one character, and
the variable name can contain mixed-case letters
,2.6 Which of the following files is a permanent SAS file?
a. Work.PrdSale
b. Cert.MySales
c. Certxl.Quarter1
d. only b and c above
e. all of the above - Answer- Correct answer: d
To store a file permanently in a SAS data library, you assign it a libref. For example, by
assigning the libref Cert to a SAS data library, you specify that files within the library are
to be stored until you delete them. Therefore, SAS files in the Cert and Certxl libraries
are permanent files
2.7 In a DATA step, how can you reference a temporary SAS data set named Forecast?
a. Forecast
b. Work. Forecast
c. Sales. Forecast (after assigning the libref Sales)
d. only a and b above - Answer- Correct answer: d
To reference a temporary SAS file in a DATA step or PROC step, you can specify the
one-level name of the file (for example, Forecast) or the two-level name using the libref
Work (for example, Work.Forecast).
2.9 How many statements does the following SAS program contain?
proc print data=cert admit
label double;
var ID Name Sex Age;
where Sex=F;
label Sex='Gender';
run;
a. three
b. four
c. five
d. six - Answer- Correct answer: c
The five statements are 1) the PROC PRINT statement (two lines long); 2) the VAR
statement; 3) the WHERE statement (on the same line as the VAR statement); 4) the
LABEL statement; and 5) the RUN statement (on the same line as the LABEL
statement).
2.10 What is a SAS library?
a. a collection of SAS files, such as SAS data sets and catalogues
b. in some operating environments, a physical collection of SAS files
c. a group of SAS files in the same folder or directory
d. all of the above - Answer- Correct answer: d
Every SAS file is stored in a SAS library. A SAS library is a collection of SAS files, such
as SAS data sets and catalogues. In some operating environments, a SAS library is a
physical collection of files. In others, the files are only logically related. In the Windows
, and UNIX environments, a SAS library is typically a group of SAS files in the same
folder or directory
3.1 How long do librefs remain in effect?
a. until the LIBNAME statement is changed
b. until the LIBNAME statement is canceled
c. until the SAS session ends
d. All of the above - Answer- Correct answer: d
Librefs remain in effect until the LIBNAME statement is changed, cancelled, or until the
SAS session ends
3.2 Which of the following statements are true?
a. When using the default engine, you do not have to specify the libref in the LIBNAME
statement.
b. When using the default engine, you do not have to specify the engine name in the
LIBNAME statement.
c. When using the default engine, you do not have to specify the SAS library in the
LIBNAME statement.
d. When using the default engine, you have to specify the libref, engine name, and the
SAS library in the LIBNAME statement. - Answer- Correct answer: b
When you are using the default engine, you do not have to specify the engine name in
the LIBNAME statement. However, you do have to specify the libref and the SAS data
library name.
3.3 When you specify an engine for a library, what are you specifying?
a. the file format for files that are stored in the library
b. the version of SAS that you are using
c. access to other software vendors' files
d. instructions for creating temporary SAS files - Answer- Correct answer: a
A SAS engine is a set of internal instructions that SAS uses for writing to and reading
from files in a SAS library. Each engine specifies the file format for files that are stored
in the library, which in turn enables SAS to access files with a particular format. Some
engines access SAS files, and other engines support access to other vendors' file
3.4 Which statement prints a summary of all the files stored in the library named
Area51?
a. proc contents data=area51._all_ nods;
b. proc contents data=area51 _all_ nods;
c. proc contents data=area51 _all_ noobs;
d. proc contents data=area51 _all_.nods; - Answer- Correct answer: a
To print a summary of library contents with the CONTENTS procedure, use a period to
append the _ALL_ option to the libref. Adding the NODS option suppresses detailed
information about the files
3.5 Which of the following programs correctly references a SAS data set named
SalesAnalysis that is stored in a permanent SAS library?
