• Print  |
  • Feedback  |

Training & Bookstore

Bookstore Questions?


Quick Search for  Books
 


Related Links

Conversations

linkedin sasCommunity blog YouTube

SAS Training and Books on Facebook

Browse Resources» SAS Certification Prep Guide: Advanced Programming for SAS 9, Third Edition


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:

SAS Data Set Work.Tempin new graphic
Appendix 1 983 The graphic SAS Data Set Work.Fishdata in question 10 has been replaced with the following:

SAS Data Set Work.Fishdata new graphic
Appendix 1 984 The graphic SAS Data Set Work.Fishsize in question 10 has been replaced with the following:

SAS Data Set Work.Fishsize new graphic