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>
Subject: Re: Pass-thru SQL
Content-Type: text/plain; charset=koi8-r
> 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
> If so could you post examples.
Couldn't be a similar effect achieved by creating a pass-through SQL
connect to oracle(user=username);
create view sqlview as
select * from oracle
select....more query clauses...
disconnect from oracle;
and 'reading' it sequentially in SAS as
...more SAS statements...
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.