Advanced SQL with SAS

Chapter 9: Tips, Tricks, and More

This chapter consists of four sections on different facets of working with PROC SQL:

• Section 9.1 introduces runtime logging of SAS programs as a key to performance. (See Chapter 8.) Four scenarios are presented with their respective advantages and disadvantages, how the runtime could be captured with the SAS option FULLSTIMER, as well as an example using ARM macros.
• Section 9.2 introduces working with SAS dictionaries. Dictionaries contain information about columns and variables from SAS files, directories, SAS tables and views, SAS catalogs and their entries, SAS macros, and current settings of SAS. This chapter presents three applications of dictionaries.
• Section 9.3 presents several PROC SQL applications ...