Date: Fri, 14 Dec 2007 22:07:54 -0500
Reply-To: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject: Re: Minimal SQL
On Wed, 12 Dec 2007 10:15:32 -0500, Wensui Liu <liuwensui@GMAIL.COM> wrote:
>my undrestanding is that sas/sql is very different from sql used in
>DB. as for sas/sql, my favorite reading material is SAS manual.
There is more than one SAS manual pertaining to SQL. See my "Finding Answers
in the PROC SQL Documentation"
You may want to look first at "SAS SQL Procedure User's Guide"
It is more tutorial than reference.
>for sql used in db, there are different variations. for instance, t-sql
>used in sql server is so different from pl/sql in oracle.
>so you'd better have more specific idea how to use sql before diving into it.
>On Dec 12, 2007 9:43 AM, Peter Flom <firstname.lastname@example.org> wrote:
>> Hello again
>> Still working through the great responses to the programming question. I
will have some time today, as it's unusually slow here today.
>> Fortuitously, the most recent NYASUG meeting featured 3 talks by Frank
DiIorio, which were very useful. But some of the talks and some of the other
material at his website (www.codecrafters.com - full of good stuff) presumed
a *little* knowledge of SQL. I know nothing about this.
>> Can anyone recommend a particularly good paper or presentation on a basic
intro to SQL?
>> e.g., one of Frank's includes
>> proc sql noprint;
>> select xpath
>> into :CurrFile separated by ''
>> from dictionary.extfiles
>> where fileref like "#LN00006"
>> I can sort of figure this out, but I'd like to understand it a little
better - I would have no idea how to modify it, if I wanted to
>> thanks as always
>Statistical Project Manager
>ChoicePoint Precision Marketing