Character String Parsing

[cheric_amusa]

Using SAS V8, how can I parse a character string into several smaller fields based on a delimeter character of '*' or '~'?

[Steelers_In_DC · Accepted solution]

data have;

infile cards dsd;

length name $50.;

format name $char50.;

input name;

cards;

name1*name2*name3~name4

;

run;

data want;

set have;

name1=scan(name,1,'*~');

name2=scan(name,2,'*~');

name3=scan(name,3,'*~');

name4=scan(name,4,'*~');

run;

[cheric_amusa]

Thank you very much for the quick response!!!

[naveen20jan]

Hi Cherric ,

I have a another automated way which you can try,  here  you dont have to type name if the string have 1000 names.  .

data all;

  drop string;

  string = ' name1*name2*name3~name4*name5~name6 ';

  do until(word=' ');

  count+1;

  word = scan(string, count,'*~');

  output;

  end;

run;

if you want it in horizontal way you can transpose the same