Date: Mon, 25 Aug 2008 12:11:50 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject: Re: sybase SQL to SAS Proc SQL
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
I can't. It's very dependent on the database, and I don't have Sybase.
There's an Oracle example at
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
There's a Sybase example in the appropriate section of the online
documentation. The main page is
> the working proc sql code where I don't do any "where statements", pulls
> 1st patient 10010001001001 and I would love to see how I can access this
> record from a temporary table
firstname.lastname@example.org <== Use this, not email@example.com