|
Quick Search for Books |
Updates for SAS Certification Prep Guide: Advanced Programming for SAS 9, Third Edition The following chapter numbers and page numbers apply to SAS Certification Prep Guide: Advanced Programming, ISBN number 978-1-60764-925-0. You can find the ISBN number on the copyright page. Page numbers in other ISBN versions might vary.
| Chapter | Page | Update |
| 3 | 130 | Replaced question 9 with the following: A PROC SQL inner join can combine a. a maximum of 2 tables or in-line views, but multiple joins can be chained together. b. a maximum of 256 tables or 2 in-line views. c. a maximum of 256 tables, which includes any tables referenced by an in-line view. d. a maximum of 2 tables and 32 columns. |
| 9 | 331 | Replaced the output of the second example to: Report Produced on November 4, 2011 |
| 9 | 340 | Question 3 has been replaced with the following: Which of the following statements will generate an error message while trying to display the value of the macro variable month in the SAS log? |
| 15 | 566 | The first sentence in the example has been replaced with: The following example uses the Flightdate index to combine data from Sasuser.Sale2000 with data from Sasuser.Dnunder, and writes the combined data to a new data set named Work.Profit3. |
| Appendix 1 | 922 | Replaced number 9 with the following: A PROC SQL inner join can combine a. a maximum of 2 tables or in-line views, but multiple joins can be chained together. b. a maximum of 256 tables or 2 in-line views. c. a maximum of 256 tables, which includes any tables referenced by an in-line view. d. a maximum of 2 tables and 32 columns. Correct answer: c A maximum of 256 tables can be combined in a single inner join. If the join involves views (either in-line views or PROC SQL views), it is the number of tables that underlie the views, not the number of views, that counts towards the limit of 256. |
| Appendix 1 | 981 | The graphic SAS Data Set Work.Tempin question 8 has been replaced with the following:
|
| Appendix 1 | 983 | The graphic SAS Data Set Work.Fishdata in question 10 has been replaced with the following:
|
| Appendix 1 | 984 | The graphic SAS Data Set Work.Fishsize in question 10 has been replaced with the following:
|