hi i have 800+variables. some of the variables have CGOV as a common prefix. i wanted to drop all of them. how may i do this?
Many thx,
aaron
Try:
drop CGOV: ;
not working...get an error:
WARNING: The variable EC in the DROP, KEEP, or RENAME list has never been referenced.
EC? Naveen suggested that you use drop CGOV: ;
Show your code.
Can you please show your code that you used?
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?
thankyou!
just along the lines, how may i rename those variables that ends with _C to without them?
ideally i would like, aaa_c->aaa
many thanks in advance!
If all variables are in an order, you can prolly use
drop yourfirstvariable_C --yourlastvariable_C ;
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 ;
select catx('=',name,substr(name,1,length(name)-2))
into :renames separated by ' '
from contents
where upcase(name) like '%^_C' escape '^'
;
quit;
data want ;
set have (rename=(&renames));
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.