Extract the word form the string

Sathish_jammy — Sat, 11 Aug 2018 09:20:42 GMT

Hi Community,

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;

SAS Output

Obs drug1 d1123456

metformin 500MG	mm500MG
Glycopride 250mg	G250mg
GLYCOMET 1GM	GM1GM
gLYCOMET 1GM	gM1GM
GLYCIPHAGE 850MG	GG850MG
GLYCIPHAGE 500mg	GG500mg

Expected Output

500MG

250mg

1GM

850MG

500mg

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!

Re: Extract the word form the string

s_manoj — Sat, 11 Aug 2018 09:46:39 GMT

Hi,

data want(keep = unit);
set have;
unit = substr(drug1,anydigit(drug1));
run;

Regards,

Manoj

Re: Extract the word form the string

Kurt_Bremser — Sat, 11 Aug 2018 10:52:56 GMT

Try

d1 = scan(drug1,-1);

topic Re: Extract the word form the string in SAS Programming

Extract the word form the string

Re: Extract the word form the string

Re: Extract the word form the string