topic Using Compress in Statistical Procedures

Using Compress

desireatem — Thu, 03 Feb 2022 17:46:41 GMT

I have a quick question on separating numbers and units in SAS.

So the data I'm having is "10 MG-25MG", I want to separate "10" with "MG-25MG".

I have tried

data want;
	txt = "100/50 mg medicin";
	c = compress(txt,"0123456789.,/ ","K"); *K is to keep the chars you specified.;
	txt_b = compress(txt,"0123456789.,/");
run;

But my output is "1025", not "10". Can you please help?

Re: Using Compress

PaigeMiller — Thu, 03 Feb 2022 18:03:40 GMT

Your words and your code don't match.

You words say that you want to separate 10 from the rest of the text, and yet in your code there is no 10. Could you clarify this, please?

Re: Using Compress

desireatem — Thu, 03 Feb 2022 18:21:33 GMT

Sure. Here is my data structure:

Drug	Strength
A/B	10 MG-25MG

I tried:

data drug;

set drug;

dose=compress(strength,"0123456789.,/ ","K");

unit = compress(strength,"0123456789.,/");

run;

Then I get:

Drug	Dose	Unit
A/B	1025	MG-MG

What I want is :

Drug	Dose	Unit
A/B	10	MG-25MG

Re: Using Compress

Rick_SAS — Thu, 03 Feb 2022 18:24:35 GMT

Maybe this will help:

data want;
	txt = "10mg-25mg";
   a = scan(txt, 1, '-');  /* get text before the dash */
   b = scan(txt, 2, '-');  /* get text after the dash */
   a_val = input(compress(a,' ', 'A'), 10.); /* get rid of letters, convert to number */
   b_val = input(compress(b,' ', 'A'), 10.);
run;

proc print;run;
proc contents; run;

Re: Using Compress

desireatem — Thu, 03 Feb 2022 18:29:58 GMT

Thank you Rick!