Date:         Mon, 25 Aug 2008 12:11:50 -0700
Reply-To:     jfh@stanfordalumni.org
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: sybase SQL to SAS Proc SQL
Comments: To: trn <trn_f@GMAC.BOC>
In-Reply-To:  <g8ut0f$bp5$1@registered.motzarella.org>
Content-Type: text/plain; charset="ISO-8859-1"

On Mon, 25 Aug 2008 21:17:49 +0300, "trn" <trn_f@GMAC.BOC> said:
> Jack Hamilton wrote:
> > You would have to create the table in Sybase.
> >
> > I haven't used Sybase, but with other databases you would typically
> > create the table using passthrough SQL, and then populate it with Proc
> > SQL INSERT INTO or with PROC APPEND.
>
> with the code samples I provided, would you (or anyone) be able to show
> me
> how?

I can't.  It's very dependent on the database, and I don't have Sybase.

There's an Oracle example at
<http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a003113602.htm>,
but it appears to have ar error in the PROC APPEND section ("set trans"
should be "data=trans").  I have not found temporary tables to be
reliable, so I create a regular table in my own schema and drop it when
I'm through.

There's a Sybase example in the appropriate section of the online
documentation.  The main page is

   http://support.sas.com/onlinedoc/913/docMainpage.jsp



> the working proc sql code where I don't do any "where statements", pulls
> the
> 1st patient 10010001001001 and I would love to see how I can access this
> one
> record from a temporary table


--
Jack Hamilton
Sacramento, California
jfh@alumni.stanford.org  <== Use this, not jfh@stanfordalumni.org