LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 1998, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 17 Apr 1998 12:31:43 -0400
Reply-To:     Grib Otsasinovik <sashole@EARTHLINK.NET>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Grib Otsasinovik <sashole@EARTHLINK.NET>
Organization: ...
Subject:      Re: Pass-thru SQL
Content-Type: text/plain; charset=koi8-r

Arthur wrote: > > Anybody know if its possible to do cursor level stuff via the pass-thru SQL > functionality of the PROC SQL statement. DECLARE CURSOR and FETCH.. stuff like > that. > > If so could you post examples.

Arthur,

Couldn't be a similar effect achieved by creating a pass-through SQL view like

proc sql; connect to oracle(user=username); create view sqlview as select * from oracle ( select....more query clauses... ); disconnect from oracle; quit;

and 'reading' it sequentially in SAS as

data whatever; set sqlview; ...more SAS statements... run;

?

In both cases, you would 'read' a virtual result table; the only distinction would be that it wouldn't be possible to interrogate SQL code on fetch. I've been doing all the time in DB2 (when subsetting, it saves the grief of the necessity to write a huge 'alive' SAS dataset), and in Oracle, it might be not much different.

Regards,

Grib.


Back to: Top of message | Previous page | Main SAS-L page