• Print  |
  • Feedback  |

Training & Books

Bookstore Questions?


Related Links

Conversations

linkedin sasCommunity blog Facebook YouTube

SAS Certification Books - SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition


Updates for SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition

The following chapter numbers and page numbers apply to SAS Certification Prep Guide: Base Programming, ISBN number 978-1-60764-924-3. You can find the ISBN number on the copyright page. Page numbers in other ISBN versions might vary.

Chapter Page Update
The "Creating Enhanced List and Summary Reports" chapter was removed from the third edition.
1 19 In the sentence at the top of the page,
"For example, to display the value 1234 as $1,234.00 in a report, you can use the DOLLAR8.2 format, as shown for Total below."
the DOLLAR format should be DOLLAR9.2 (and not 8.2) to accommodate the full width of the output field, which in this case is 9 bytes (or 9 digits, including the $ sign, the comma, and the decimal point.)

In the table that follows (Table 1.9 Format Attribute), the Format for the variable Total should also be DOLLAR9.2.
2 62 This first sentence in paragraph two should read as follows:

"In the following example, the observations are longer than 64 characters, so the output continues on a subsequent line."
2 62 The output in Figures 2.28 and 2.29 is incorrect and should be shown as follows:

Notice that the Obs column numbers (1-8) are repeated because the observations have wrapped to the next line.
4 132 In the example, the value for the LABEL statement should be contained in quotes, as shown here:
label walkjogrun=’Walk/Jog/Run’;
4 132 The title for Figure 4.28 incorrectly labels the output as being "Without" the LABEL option when it should be "With", as shown below:
Figure 4.28 Output Created With the LABEL Option
11 339 The Selected PDV Variables table should contain a "Salary" column showing salary data rather than the "Payroll" column.
11 339 * This example requires the use of the data set USA, which you can access by running this SAS program (copy paste the contents of the text file into your SAS session and run it).

The output shown in Figure 11.4 is incorrect and should be shown as follows:
Figure 11.4
11 339 * This example requires the use of the data set USA, which you can access by running this SAS program (copy paste the contents of the text file into your SAS session and run it).

The values in Figure 11.5 are incorrect. The Selected PDF Variables should contain the following values as well as a "Yearly” column showing employees’ yearly salaries:
Figure 11.5
11 340 * This example requires the use of the data set USA, which you can access by running this SAS program (copy paste the contents of the text file into your SAS session and run it).

The values in Figure 11.6 showing the Payroll Sum are incorrect and should be shown as follows:

Figure 11.6
11 341 * This example requires the use of the data set USA, which you can access by running this SAS program (copy paste the contents of the text file into your SAS session and run it).

The values in Figure 11.7 are incorrect. The Selected PDF Variables should contain the following values as well as a "Yearly” column showing employees’ yearly salaries:
Figure 11.7
Appendix 1 706 The correct answer should be "a. HTML and PDF". The explanation is correct.