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
Comments: To: sas-l@uga.edu
Content-Type: text/plain; format=flowed; charset="Windows-1252";
              reply-type=original

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?

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