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 -- Introducing macro variables -- Processing macro variables at execution time -- Creating and using macro programs -- Storing macro programs -- 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 -- Introduction to efficient SAS programming -- Controlling memory usage -- Controlling data storage space -- Using best practices -- Selecting efficient sorting strategies -- Querying data efficiently.