topic Re: Multiple rows in SAS Programming

Multiple rows

SASPhile — Fri, 23 Oct 2020 01:15:04 GMT

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

Re: Multiple rows

novinosrin — Fri, 23 Oct 2020 01:28:41 GMT


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;