topic Re: Help need in using compress function in SAS Programming

Help need in using compress function

knveraraju91 — Mon, 09 Aug 2021 21:48:42 GMT

Dear,

I need help in my pgm to get the output i need. I need to create a numeric variable 'b' from char variable 'a'

output need

15.22

33.22

please suggest. Thank you

data have;
input a $20.;
datalines;
CYCLE 15 DAY 22
CYCLE 33 DAY 22
;
data want;
set have;
b=compress(a,'','kd');
run;

Re: Help need in using compress function

jimbarbour — Mon, 09 Aug 2021 22:04:25 GMT

You've got the right idea using the COMPRESS function with 'kd' as the third parameter. Then you would want to use the INPUT function (function not statement) to cast the data into numeric form.

Like this:

data have;
input a $20.;
datalines;
CYCLE 15 DAY 22
CYCLE 33 DAY 22
;
data want;
	set have;
	b	=	INPUT(TRANWRD(strip(COMPBL(compress(a,,'kd'))),' ', '.'), 8.2);
run;

Which yields:

Are you sure that's what you want? It almost seems like cycle and day should be two separate fields instead of a single numeric fields with two values, in essence, separated by a decimal point.

Jim

Re: Help need in using compress function

Reeza — Mon, 09 Aug 2021 22:26:35 GMT

I suspect you really want two variables, CYCLE and DAY, and likely separately.

CYCLE = input(scan(a, 2), 8.);
DAY = input(scan(a, 4), 8.);

@knveraraju91 wrote:

Dear,

I need help in my pgm to get the output i need. I need to create a numeric variable 'b' from char variable 'a'

output need

15.22

33.22

please suggest. Thank you
data have;
input a $20.;
datalines;
CYCLE 15 DAY 22
CYCLE 33 DAY 22
;
data want;
set have;
b=compress(a,'','kd');
run;

Re: Help need in using compress function

Ksharp — Tue, 10 Aug 2021 13:14:28 GMT

data have;
input a $20.;
datalines;
CYCLE 15 DAY 22
CYCLE 33 DAY 22
;
data want;
set have;
b=catx('.',scan(a,1,,'kd'),scan(a,2,,'kd'));
run;