Date:         Tue, 22 May 2007 23:55:32 +0300
Reply-To:     Nina <sas@MAILINATOR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nina <sas@MAILINATOR.COM>
Subject:      Re: help with sybase and proc sql
Comments: To: sas-l@uga.edu
Content-Type: text/plain; format=flowed; charset="Windows-1252";
              reply-type=original

Richard A. DeVenezia wrote:
> Your best performance might be to create a temporary table containing
> the 3000 lookups on the Sybase side and then performing an inner join
> on the remote side

am a little rusty on the specifics on how this might look on the sybase side

my little original example works perfectly, *if* I remove the little
$myformat. line
but I end up with 25M rows of data

care to share what the inner join would look like?

ie. -> this gets me 25M rows

proc sql; connect to sybase (user = myid pass = mypass server = myserver);
 create table match as
  select a.var1, a.var2

 from dabig_table as a
 /* where
   (put (a.var1, $myformat.) = 'Y') */
 ); disconnect from sybase; quit;