|
On Wed, 2 May 2007 09:09:47 -0500, SAS_learner <proccontents@GMAIL.COM>
wrote:
>Hello guys I am trying to extract views (generated by oracle ) into SAS ,
>everything looks fine expect I am getting a WARNING "WARNING: The option
>OUTREP is not implemented in the V8 engine." What does it mean ??
>
>
>
> *Capture the variables for Subset One ;
>931 data v_imn4 ;
>932 set views.imn4 (where = ( subsetsn = 6 ) ) ;
>WARNING: The option OUTREP is not implemented in the V8 engine.
>933 length PGNM $15. ;
>934 PGNM = trim(left(QUALIFYV))!!'.'!! trim( put(SUBEVE, 2. -l )) ;
>935 label pgnm = "Page Number";
>936 keep &keep_var &keep_var1 PGNM ;
>937 run;
>
>NOTE: There were 2 observations read from the data set VIEWS.IMN4.
> WHERE subsetsn=6;
>NOTE: The data set WORK.V_IMN4 has 2 observations and 27 variables.
>NOTE: DATA statement used:
> real time 0.31 seconds
> cpu time 0.02 seconds
Hi,
You should give some more details:
what means: generated by Oracle? That are no Oracle views, right?
Otherwise there must be something like SQL pass-through... ...select ...
from connection to ...
Or is the libname "views" a libname on Oracle? Something like:
LIBNAME views oracle SSID=xxxx AUTHID=xxxx
ACCESS=READONLY CONNECTION=global;
Or is it a view on a ACCESS descriptor on a Oracle table?
Anyway.
Try to make a
proq sql;
describe view views.imn4;
quit;
Maybe that could tell anything about the view.
Otherwise, more details please!
Gerhard
| 
