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

Variable old_ID may include several names for each name in new_ID. I want to have only one name in old_ID for each name in new_id by separating names in old_id into several rows as the following.

Could you show me how to do so? Thank you so much!

Old_ID                                                               New_ID

P006                                                                B01002

P006A                                                               B01002A

PCT003                                                               B02005

P038                                                                       B05002

P047, P052                                                       B08006

P016, P007, P023, P027, P030                               B11001

P024, P008                                                       B11002

P024A, P008A,                                                       B11002A

Old_ID     New_ID

P006             B01002

P006A     B01002A

PCT003     B02005

P038      B05002

P047             B08006

P052             B08006

P016            B11001

P007        B11001

P023            B11001

P027      B11001

P030      B11001

P024      B11002

P008             B11002

P024A      P008A

P008A      P008A

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

data want ; set have ;

  do i=1 by 1 until (scan(old_id,i,',') = ' ');

    new_old_id = scan(old_id,i,',');

    output;

  end;

run;

View solution in original post

2 REPLIES 2
Tom
Super User Tom
Super User

data want ; set have ;

  do i=1 by 1 until (scan(old_id,i,',') = ' ');

    new_old_id = scan(old_id,i,',');

    output;

  end;

run;

vxhong17
Calcite | Level 5

Hi Tom,

It works. Thank you so much,

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
  • 2 replies
  • 831 views
  • 0 likes
  • 2 in conversation