topic Re: Capture text string between two delimiters in SAS Programming

Capture text string between two delimiters

jenim514 — Fri, 08 Mar 2019 18:05:08 GMT

Hi,

I have a variable with values all structured like this:

MHS7. VITAMIN D DEFICIENCY (ONSET DATE = UN UNK 2016)

I need to capture the 'VITAMIN D DEFICIENCY' only. So the text string between the ' . ' and the ' ( '

Is there a way to do this with a scan or some other way?

Thanks!

Re: Capture text string between two delimiters

novinosrin — Fri, 08 Mar 2019 18:08:45 GMT

data want;
str='MHS7. VITAMIN D DEFICIENCY (ONSET DATE = UN UNK 2016)';
pos1=findc(str, '.');
pos2=findc(str, '(');
Need=substr(str,Pos1+1,pos2-1-pos1);
drop pos:;
run;

Re: Capture text string between two delimiters

ballardw — Fri, 08 Mar 2019 18:14:20 GMT

Another way:

data want;
   str='MHS7. VITAMIN D DEFICIENCY (ONSET DATE = UN UNK 2016)';
   length newstr $ 25;
   newstr = strip(scan(str,2,'.('));
run;

The SCAN function can be provided explicit delimiters, in this case the period and left parentheses. Since the value you want would have a leading blank I add strip to remove that.

Without knowing other possible values needed it is a good idea to set a length for the new variable to hold the longest expected length. Otherwise your length would be set from the first record and might not be as long as needed for other records.

Re: Capture text string between two delimiters

novinosrin — Fri, 08 Mar 2019 18:18:35 GMT

Sir @ballardw Very clever indeed. But honestly in a prod environment and that too for a low/intermediate users can be a hard learning curve. Well even for experienced, the maintenance can be daunting unless the genius @ballardw lives forever to support them. Kudos!

Re: Capture text string between two delimiters

novinosrin — Fri, 08 Mar 2019 18:21:00 GMT

Also if you may and have time, for the sake of others, a note on how scan treats various combination of delimiters with/without modifiers will help. My $0.02 cents

Re: Capture text string between two delimiters

Yavuz — Fri, 08 Mar 2019 18:59:55 GMT

I am a sas lover and trying to improove myself.
I really thanks to all of you. I learn new things from every replys, different ways...thanks again.