topic how drop var with a part of char in the name ? in SAS Procedures

how drop var with a part of char in the name ?

Luca — Wed, 17 Dec 2014 14:54:01 GMT

I would drop every var that has a specific char in the name without write each var:

for example if var are (abc_01 abc_02 abc_03 hh_01 hh_02) I'd like to drop hh_01 and hh_02

is it possible ?

Reeza — Wed, 17 Dec 2014 14:59:57 GMT

If you want to drop any var that starts with hh use the colon notation.

Drop hh: ;

Luca — Wed, 17 Dec 2014 15:10:03 GMT

Thank you !!

If I want to drop any var that end with _01 what I have to use instead ":" ?

Loko — Wed, 17 Dec 2014 15:11:36 GMT

Hello,

proc sql noprint;
select name into :vars separated by ' ' from sashelp.vcolumn
where memname='CLASS' and libname='SASHELP' AND name like '%e';
quit;

%put &vars;

data want;
set sashelp.class (drop=&vars) ;
run;