Date:         Mon, 22 Dec 2003 10:44:30 -0700
Reply-To:     Kenneth Moody <KennethMoody@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Kenneth Moody <KennethMoody@FIRSTHEALTH.COM>
Subject:      Re: Views and engines problem
Comments: To: nick_s_downie@HOTMAIL.COM
Content-Type: text/plain; charset=us-ascii

Nick,
According to the following SASnote you're out of luck,  Version 6 views
can't be created in Version 8.

http://support.sas.com/techsup/unotes/SN/005/005053.html

Ken

>>> Nick <nick_s_downie@HOTMAIL.COM> 12/22/03 08:59AM >>>
Hi all,

Simple problem but nothing to help me in the manuals - I'm working
under V8 conditions but want to create a V6 view from V6 datasets -
which you'd think would be easy - but i cannot seem to find the option
to make this work..

using SQL this happens...

100
101  proc sql;
102   create view sasdata.demo as
103         select *
104           from site1.demo
105   outer union corresponding
106         select *
107           from site2.demo
108  ;
ERROR: PROC SQL will not store a post-V6 view into a V6 library.
109  quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used:
      real time           0.01 seconds
      cpu time            0.01 seconds

110

and in datastep...


111  data sasdata.demo / view = sasdata.demo;
112   set site1.demo site2.demo;
113   run;

ERROR: The library SASDATA is not compatible with the current version
of DATA step views.
NOTE: View not saved due to errors.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used:
      real time           0.04 seconds
      cpu time            0.02 seconds


like i say - site1, site2 and sasdata are all v6 libname - can anyone
help?

thanks in advance.

nick