topic Re: Match and Value in SAS Programming

Match and Value

SASPhile — Wed, 11 Apr 2018 19:37:02 GMT

Text
.25 Mg Every 3 Hours Prn

MATCH=prxmatch('m/Meq|mg|ml|gram(\w)*|gm|mcg/i',text);

The result of match is 5. But I would like to capture Mg as value in a new column as below

Text Match Value
.25 Mg Every 3 Hours Prn 5 Mg

Re: Match and Value

SuryaKiran — Wed, 11 Apr 2018 19:44:43 GMT

I'm using SCAN and SUBSTR, but it may change depending on how you data flows. PRXMATCH gives you the position and you can use that values in SUBSTR.

MATCH=SCAN(SUBSTR(TEXT,prxmatch('m/Meq|mg|ml|gram(\w)*|gm|mcg/i',text)),1);

Re: Match and Value

SASPhile — Wed, 11 Apr 2018 20:16:07 GMT

Thank you,

How about to capture the digits that precede the keywords. in the example .25

Re: Match and Value

SuryaKiran — Wed, 11 Apr 2018 20:26:51 GMT

Something like this would work, also if you want to convert into numeric use INPUT function. I'm assuming value is separated from units with a space here, if not all the time in your data then change accordingly.

Data have;
Text ="Example text .25 Mg Every 3 Hours Prn";
MATCH=SCAN(SUBSTR(TEXT,prxmatch('m/Meq|mg|ml|gram(\w)*|gm|mcg/i',text)),1);
value=SCAN(SUBSTR(TEXT,1,prxmatch('m/Meq|mg|ml|gram(\w)*|gm|mcg/i',text)-2),-1,' ');
run;

Re: Match and Value

s_lassen — Thu, 12 Apr 2018 12:57:34 GMT

I understand that you want both the number and the unit. The something like this may work:

data _null_;
  text='.25 Mg Every 3 Hours Prn';
  prxid=prxparse('/([0-9\.]+)\s+(Meq|mg|ml|gram(\w)*|gm|mcg)/i');
  if prxmatch(prxid,text) then do;
    number=prxposn(prxid,1,text);
    unit=prxposn(prxid,2,text);
    end;
  put _all_;
run;

The PRXPOSN function returns the string inside a capture buffer (the stuff inside the parantheses).

Re: Match and Value

Ksharp — Thu, 12 Apr 2018 13:23:43 GMT

Data have;
Text ="Example text .25 Mg Every 3 Hours Prn";
pid=prxparse('m/Meq|mg|ml|gram(\w)*|gm|mcg/i');
call prxsubstr(pid,text,p,l);
if p then want=substr(text,p,l);
run;
proc print;run;

Re: Match and Value

SASPhile — Thu, 12 Apr 2018 14:06:29 GMT

if the number is 0.25, the decimal is not captured. shows as 25

if there numbers are like .63-0.125 mg, .63-0.125 are not captured.,shows as 125

if there is no space between digit and unit like 0.25Mg nothing is captured