SAS certification prep guide : advanced programming for SAS 9

SQL processing with SAS: Performing queries using PROC SQL ; Performing advanced queries using PROC SQL ; Combining tables horizontally using PROC SQL ; Combining tables vertically using PROC SQL ; Creating and managing tables using PROC SQL ; Creating and managing indexes using PROC SQL ; Creating and managing views using PROC SQL ; Managing processing using PROC SQL SAS macro language: Introducing macro variables ; Processing macro variables at execution time ; Creating and using macro programs ; Storing macro programs Advanced SAS programming techniques: Creating samples and indexes ; Combining data vertically ; Combining data horizontally ; Using lookup tables to match data ; Formatting data ; Modifying SAS data sets and tracking changes Optimizing SAS programs: Introduction to efficient SAS programming ; Controlling memory usage ; Controlling data storage space ; Utilizing best practices ; Selecting efficient sorting strategies ; Querying data efficiently Pt. 5. Quiz answer keys. SAS Certification Prep Guide( Base Programming for SAS 9) Paperback SASPublishing SASInstitute