From: Joe Matise on
data clear;
set barcode193;
drop commodiy_:;
run;

* Drop AFTER set statement declares the variables
* COLON is the wildcard, not asterisk

-Joe

On Wed, Sep 2, 2009 at 3:37 PM, Elmaache, Hamani <
Hamani.Elmaache1(a)cra-arc.gc.ca> wrote:

> Hi there.
> I want to drop many variables from my data set.
> These variables start by Commodity_var1 ,,,,, Commodity_var100
> Commodity_expe100 ....
>
>
> I wrote this code but it doesn't work:
>
> data clear;
> drop commodity_* ;
> set BarCode193 ;
> run;
>
> I appreciate any help.
> Thanks.
>
From: "Data _null_;" on
data clear;
set BarCode193 (drop=commodity_:);
run;


On 9/2/09, Elmaache, Hamani <Hamani.Elmaache1(a)cra-arc.gc.ca> wrote:
> Hi there.
> I want to drop many variables from my data set.
> These variables start by Commodity_var1 ,,,,, Commodity_var100
> Commodity_expe100 ....
>
>
> I wrote this code but it doesn't work:
>
> data clear;
> drop commodity_* ;
> set BarCode193 ;
> run;
>
> I appreciate any help.
> Thanks.
>