Character variable

Accepted Solution Solved
Reply
Contributor
Posts: 51
Accepted Solution

Character variable

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


Accepted Solutions
Solution
‎05-31-2013 06:14 PM
Super User
Super User
Posts: 6,500

Re: Character variable

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


All Replies
Solution
‎05-31-2013 06:14 PM
Super User
Super User
Posts: 6,500

Re: Character variable

data want ; set have ;

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

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

    output;

  end;

run;

Contributor
Posts: 51

Re: Character variable

Hi Tom,

It works. Thank you so much,

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 163 views
  • 0 likes
  • 2 in conversation