- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Try:
drop CGOV: ;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
not working...get an error:
WARNING: The variable EC in the DROP, KEEP, or RENAME list has never been referenced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
EC? Naveen suggested that you use drop CGOV: ;
Show your code.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can you please show your code that you used?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If all variables are in an order, you can prolly use
drop yourfirstvariable_C --yourlastvariable_C ;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;