03-14-2015 02:08 PM
oh. sorry. it works with the colon! this is very very helpful. thank you so much.
do u by any chance have an idea, how to drop the same suffixes? ie: _C.
i have variables that ends with _C: for example, xxx_C. how may i drop them?
03-14-2015 02:28 PM
Rename is similar to suffix. You need to query the list of names.
proc contents data=have out=contents(keep=name) noprint ; run;
proc sql noprint ;
into :renames separated by ' '
where upcase(name) like '%^_C' escape '^'
data want ;
set have (rename=(&renames));
Need further help from the community? Please ask a new question.