BookmarkSubscribeRSS Feed
SASPhile
Quartz | Level 8

I need help to split ID into two rows as below if there is a delimiter colon (:) 

 

ID                         Description

001                          Text1

002:003                   Text2

 

 

ID               Description

001                Text1

002                Text2

003                Text2

1 REPLY 1
novinosrin
Tourmaline | Level 20

data have;
input ID    $8.                   Description $;
cards;
001                          Text1
002:003                   Text2
;


data Need;
 length _id $20;
 set have;
 do _n_=1 to countw(id,':');
  _id=scan(id,_n_,':');
  output;
 end;
 drop id;
 rename _id=id;
run;
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
  • 1 reply
  • 694 views
  • 4 likes
  • 2 in conversation