topic Scan Function in SAS Programming

Scan Function

GokulShivananda — Mon, 27 Jul 2020 10:21:17 GMT

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

Re: Scan Function

PeterClemmensen — Mon, 27 Jul 2020 10:35:03 GMT

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;

Re: Scan Function

PaigeMiller — Mon, 27 Jul 2020 12:31:31 GMT

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