LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2002, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 18 Dec 2002 11:08:21 -0700
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      SQL For Smarties
Content-Type: text/plain; charset=us-ascii

Since we're talking about SQL again, I'd like to tell new listers about "Joe Celko's SQL for Smarties: Advanced SQL Programming ". It's essential reading for wannabe SQLheads. This is not a book for beginners, but it gives lots of interesting examples. For more information, see the review at; go to and search for "sql for smarties".

The dialect of SQL used by SAS is not quite the same as that used by DB2, Oracle, or any other database, but most of the examples work, or can be modified to work.

I sure wish SAS would add the ability to say

select a, b, c from x where (a, b) in (select a, b from z);

-- Manager, Technical Development METRICS Department, First Health West Sacramento, California USA

Back to: Top of message | Previous page | Main SAS-L page