Date: Thu, 28 Feb 2002 09:39:00 -0800
Reply-To: Nick <nick_s_downie@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nick <nick_s_downie@HOTMAIL.COM>
Subject: referencing sas views in sql vs data step
Content-Type: text/plain; charset=ISO-8859-1
Hi, hope u can help - I basically want to create a view of a large
dataset but also to overwrite one of its variables. I know a view
holds as many columns as you define, and that these can be called the
same name, and I know that when this is read into sql it is dealt with
differently than datastep, but how can i create a view that will
ensure a consistent approach, ie value always overwritten regardless
of where the view is used?
In this case d/set one is altered by two is not. Also NB i need to use
select * as the source dataset contains > 100 variables, and this may
be liable to change.
Test code below..
input var1 $ number;
create view vindex as
,99 as number
create table two as select * from vindex;