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:

>peter,
>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"
(http://www.nesug.info/Proceedings/nesug07/as/as08.pdf).

You may want to look first at "SAS SQL Procedure User's Guide"
(http://support.sas.com/onlinedoc/913/getDoc/en/sqlproc.hlp/a002536894.htm).
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 <peterflomconsulting@mindspring.com> 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"
>>  ;
>> quit;
>>
>> 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
>>
>> Peter
>>
>
>
>
>--
>===============================
>WenSui Liu
>Statistical Project Manager
>ChoicePoint Precision Marketing
>(http://spaces.msn.com/statcompute/blog)
>===============================