SAS PROGRAMMING CERTIFICATION
TEST EXAM QUESTIONS WITH 100%
CORRECT ANSWERS LATEST VERSION
2025/2026.
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. - ANS 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;
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,run;
A. 3
B. 4
C. 5
D. 6 - ANS 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 - ANS 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 - ANS Correct answer: d
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,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 - ANS 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 - ANS 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).
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, 2.10 What is a SAS library?
a. a collection of SAS files, such as SAS data sets and catalogs
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 - ANS 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 catalogs. 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 - ANS Correct answer: d
Librefs remain in effect until the LIBNAME statement is changed, canceled, 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. - ANS 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.
4 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
TEST EXAM QUESTIONS WITH 100%
CORRECT ANSWERS LATEST VERSION
2025/2026.
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. - ANS 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;
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,run;
A. 3
B. 4
C. 5
D. 6 - ANS 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 - ANS 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 - ANS Correct answer: d
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,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 - ANS 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 - ANS 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).
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, 2.10 What is a SAS library?
a. a collection of SAS files, such as SAS data sets and catalogs
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 - ANS 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 catalogs. 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 - ANS Correct answer: d
Librefs remain in effect until the LIBNAME statement is changed, canceled, 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. - ANS 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.
4 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
