Thanks for being my tester.
create view no45 as
where var4 = 4;
select * from no45 (drop = var4 var5);
On Thu, 22 Sep 2005 12:39:18 -0400, Ken Borowiak <evilpettingzoo97@AOL.COM>
>A warning is generated that data set options will be ignored when used
>in the CREATE VIEW statement, except for READ, WRITE, ALTER, PW &
>LABEL. Most data set options will work in the CREATE TABLE statement.
>From: Howard Schreier <hs AT dc-sug DOT org> <nospam@HOWLES.COM>
>Sent: Thu, 22 Sep 2005 11:30:14 -0400
>Subject: Re: SQL - Excluding columns from Select
> You'll need two statements, as in (untested);
> create view no45 (drop = var4 var5) as
> select *
> from one
> where var4 = 4;
> select * from no45;
>On Thu, 22 Sep 2005 08:23:48 -0700, Ali G <Alistair.Gordon@NEWTYNE.COM>
>>Simple as that...
>>I tried to extend your code to:
>>proc sql ;
>> select *
>> from one (drop = var4 var5)
>> where var4 = 4;
>>But it didn't like that.