Sharpening your advanced SAS skills

Content: Accessing Data Using SQL Introduction Table Access and Retrieval Creating Macro Variables Table Structure Operations Table Content Operations Connecting to Relational Databases SAS Macro Processing Introduction Introduction to SAS Macro Language and Ground Rules Writing Macro Programs to Automate Tasks Accessing Macros from Macro Libraries Creating Macro Variables to Store and Replace Text Referencing Macro Variables to Substitute Text The Art of SAS Macro Testing Section Summary Powerful SAS Macro Quoting Functions Advanced Programming Techniques Introduction Demonstrate the Use of Advanced Table Lookup Techniques Reduce I/O by Controlling the Space Required to Store SAS Datasets Reduce Programming Time by Developing Reusable SAS Programs Perform Effective Benchmarking SORT Procedure Identify Appropriate Applications for Using Indexes and Create Them Compare Techniques to Eliminate Duplicate Data What's New in SAS Version 9.3 Introduction What's New in SAS Procedures What's New in Character and Numeric Functions What's New in ODS Styles and Templates What's New in ODS Statistical Graphics Answers to Chapter Review Questions References and Questions appear at the end of each chapter.