topic Re: Function to extract substring between two delimiters that are the same in SAS Programming

Function to extract substring between two delimiters that are the same

mglogan — Thu, 03 Jan 2019 02:26:25 GMT

Hello!

I need to extract a medication class that is between two delimiters that are the same. In this case, it is a semi-colon (;).

have (oldvar) = ATC|R|RESPIRATORY SYSTEM; ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES; ATC|R03A|ADRENERGICS, INHALANTS; ...

want (newvar) = ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES

can you suggest an effective way to do this?

Thank you!

Re: Function to extract substring between two delimiters that are the same

novinosrin — Thu, 03 Jan 2019 02:33:48 GMT

do you mean this?

data test;
have=' ATC|R|RESPIRATORY SYSTEM; ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES';
want=scan(have,-1,';','m');
run;

or just this?


data test;
have=' ATC|R|RESPIRATORY SYSTEM; ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES';
want=scan(have,-1,';');
run;

Re: Function to extract substring between two delimiters that are the same

mglogan — Thu, 03 Jan 2019 02:40:03 GMT

Thanks for the quick response!

I should have included the entire length of the string which is as follows:

ATC|R|RESPIRATORY SYSTEM; ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES; ATC|R03A|ADRENERGICS, INHALANTS; ATC|R03AC|SELECTIVE BETA-2-ADRENORECEPTOR AGONISTS; PRODUCT|001395 01 001|SALBUTAMOL; PRODUCTSYNONYM|001395 01 002|VENTOLIN /00139501/;

Re: Function to extract substring between two delimiters that are the same

novinosrin — Thu, 03 Jan 2019 02:43:55 GMT

is it always in 2nd position?

if yes, extract the 2nd


data test;
have='ATC|R|RESPIRATORY SYSTEM; ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES; ATC|R03A|ADRENERGICS, INHALANTS; ATC|R03AC|SELECTIVE BETA-2-ADRENORECEPTOR AGONISTS; PRODUCT|001395 01 001|SALBUTAMOL; PRODUCTSYNONYM|001395 01 002|VENTOLIN /00139501/;';
want=strip(scan(have,2,';'));
run;

Re: Function to extract substring between two delimiters that are the same

mglogan — Thu, 03 Jan 2019 06:00:35 GMT

It will always be between the first and second semi-colon.

Re: Function to extract substring between two delimiters that are the same

novinosrin — Thu, 03 Jan 2019 02:45:49 GMT

ok, i updated in my previous. check that out plz

here again

data test;
have='ATC|R|RESPIRATORY SYSTEM; ATC|R03|DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES; ATC|R03A|ADRENERGICS, INHALANTS; ATC|R03AC|SELECTIVE BETA-2-ADRENORECEPTOR AGONISTS; PRODUCT|001395 01 001|SALBUTAMOL; PRODUCTSYNONYM|001395 01 002|VENTOLIN /00139501/;';
want=strip(scan(have,2,';'));
run;

Re: Function to extract substring between two delimiters that are the same

mglogan — Thu, 03 Jan 2019 02:49:44 GMT

It worked. thank you!