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 (December 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


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