Date: Mon, 25 Aug 2008 21:17:49 +0300
Reply-To: trn <trn_f@GMAC.BOC>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: trn <trn_f@GMAC.BOC>
Organization: A noiseless patient Spider
Subject: Re: sybase SQL to SAS Proc SQL
Content-Type: text/plain; format=flowed; charset="Windows-1252";
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
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