|
Thanks for being my tester.
Maybe
create view no45 as
select *
from one
where var4 = 4;
select * from no45 (drop = var4 var5);
On Thu, 22 Sep 2005 12:39:18 -0400, Ken Borowiak <evilpettingzoo97@AOL.COM>
wrote:
>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.
>
>Ken
>
>-----Original Message-----
>From: Howard Schreier <hs AT dc-sug DOT org> <nospam@HOWLES.COM>
>To: SAS-L@LISTSERV.UGA.EDU
>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>
>wrote:
>
>>Thanks Toby,
>>
>>Simple as that...
>>
>>I tried to extend your code to:
>>
>>proc sql ;
>> select *
>> from one (drop = var4 var5)
>> where var4 = 4;
>>quit ;
>>
>>But it didn't like that.
|
