As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Advanced SQL Processing

From sasCommunity
Jump to: navigation, search
Destiny Corporation
Wethersfield, CT

Abstract

This session will bring attendees through advanced uses of SQL, including HAVING, FULL JOINs and creation of Views, Indexes, and Data sets. The joys of re-merging and sub-queries will be introduced and you will gain an understanding of the relative merits of Proc SQL and SAS® base. Finally, we will touch on some of the debugging tools available with PROC SQL. We assume that you will have at least one year of experience with SQL.

Online resources

You can download this paper from lexjansen.com.