Scan Function

[GokulShivananda]

Hi,

I'm doing some data cleansing and i have few words which act as a delimiter. I tried to get the data between two delimiters(Words) and i wasn't able to succeed.  

I used SCAN function where i cant use string/word as a delimiter. any suggestions/solutions are appreciated.

Thank you.

Regards,

Gokul SHIVANANDA

[PeterClemmensen]

How about PRX?

data have(keep=string newstring);
   string = "one two three four five six";
   r = prxparse("/one (.*) five/");
   p = prxmatch(r, string);
   newstring = prxposn(r, 1, string);
run;

[PaigeMiller]

Show us a few examples. Show us the code you tried.