SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
aarony
Obsidian | Level 7

     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

1 ACCEPTED SOLUTION

Accepted Solutions
8 REPLIES 8
naveen_srini
Quartz | Level 8

Try:

drop CGOV:  ;

aarony
Obsidian | Level 7

not working...get an error:

WARNING: The variable EC in the DROP, KEEP, or RENAME list has never been referenced.

art297
Opal | Level 21

EC?  Naveen suggested that you use drop CGOV: ;

Show your code.

naveen_srini
Quartz | Level 8

Can you please show your code that you used?

aarony
Obsidian | Level 7

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!

aarony
Obsidian | Level 7

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!

naveen_srini
Quartz | Level 8

If all variables are in an order, you can prolly use

drop yourfirstvariable_C --yourlastvariable_C ;

Tom
Super User Tom
Super User

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;

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 8 replies
  • 36723 views
  • 7 likes
  • 4 in conversation