topic Re: Character String Parsing in SAS Procedures

Character String Parsing

cheric_amusa — Mon, 18 May 2015 16:56:01 GMT

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

Steelers_In_DC — Mon, 18 May 2015 18:06:06 GMT

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 — Mon, 18 May 2015 18:24:52 GMT

Thank you very much for the quick response!!!

naveen20jan — Tue, 19 May 2015 07:43:34 GMT

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