Saturday - last edited Saturday
Here I have a sample dataset, I want to extract the gram/milligram values from the string.
I tried up with compress method, but even I need more efficient step to extract in particular format.
data have; input drug1$30.; cards; metformin 500MG Glycopride 250mg GLYCOMET 1GM gLYCOMET 1GM GLYCIPHAGE 850MG GLYCIPHAGE 500mg ; run; data want; set have; d1 = compress(drug1,'1234567890mgMG','k'); run;
Please suggest the code which extract the output in the given format.
NOTE : To more simpler, Atleast let me know how to remove the characters in front of numeric value.
Thanks in advance!
Need further help from the community? Please ask a new question.