Exam (elaborations) SAS Programming Certification

SAS Programming Certification Test Questions 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. Correct answer: d In addition to tracking time intervals, SAS date and time values can be used in calculations like other numeric values 1/64 3/2/26, 2:27 PM SAS Programming Certification Test Questions 2.2 How many program steps are executed when the program below is processed? data s; set ; run; proc sort data=s; by name; run; proc print data=s; run; A. 3 B. 4 C. 5 D. 6 contains one DATA step and two PROC steps, for a total of three program step 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 2/64 3/2/26, 2:27 PM SAS Programming Certification Test Questions 3/64 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 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 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 3/2/26, 2:27 PM SAS Programming Certification Test Questions 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 Correct answer: d specify the one-level name of the file (for example, Forecast) or the two-level name using the libref Work (for example, Work.Forecast). To reference a temporary SAS file in a DATA step or PROC step, you can 4/64 3/2/26, 2:27 PM SAS Programming Certification Test Questions 5/64 2.9 How many statements does the following SAS program contain? proc print data= label double; var ID Name Sex Age; where Sex=F; label Sex='Gender'; run; a. three b. four c. five d. six 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 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 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