BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mkd
Calcite | Level 5 mkd
Calcite | Level 5

     I have data that includes the name of a town in parenthesis.  I want to get rid of what's in the parenthesis.  Is there a way to do this in SAS...or does it need to be done outside of SAS?

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
arodriguez
Lapis Lazuli | Level 10

I will select the first word separated by "(" character with an scan function in the datastep

newvar=SCAN(var,1,'(');

View solution in original post

5 REPLIES 5
stat_sas
Ammonite | Level 13

Please show some sample data.

ballardw
Super User

One approach, inside a data step is to include code similar to

Variable = substr(variable, 1,(index(variable,'(')-1));

mkd
Calcite | Level 5 mkd
Calcite | Level 5

This was very useful and did what I needed.  Thank you for answering, however, I found the SCAN function much easier to use and most likely easier for me to remember in the future.

arodriguez
Lapis Lazuli | Level 10

I will select the first word separated by "(" character with an scan function in the datastep

newvar=SCAN(var,1,'(');

user24feb
Barite | Level 11

Depending on your actual data, this might work (kicks out ( and ) without replacement):

Data A;

  Ex="xxxcd(1dfd32)"; Output;

  Ex="gegewx1d (322)"; Output;

Run;

Data B;

  Set A;

  Ex_new=PRXChange("s/[\(\)]//",-1,Ex);

Run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 5 replies
  • 1575 views
  • 3 likes
  • 5 in conversation