topic Re: Separate values like integer and float as two columns in SAS Programming

Separate values like integer and float as two columns

BrahmanandaRao — Sat, 25 Jan 2020 16:50:22 GMT

Hi Guys Good Evening

i want splt the value as integer and float with seperate columns

data test;
input value;
cards;
12.356
45.257
15.12
120.12
;
run;

PeterClemmensen — Sat, 25 Jan 2020 16:54:13 GMT

So in the first, obs you want 12 in the first column and 356 in the second, correct?

BrahmanandaRao — Sat, 25 Jan 2020 17:08:24 GMT

Hi Dracut

output like below

novinosrin — Sat, 25 Jan 2020 17:18:30 GMT


data test;
input value;
cards;
12.356
45.257
15.12
120.12
;
run;

data want;
 set test;
 int=int(value);
 float=value-int;
run;

Hi @BrahmanandaRao Funny question though 🙂

novinosrin — Sat, 25 Jan 2020 17:23:21 GMT

And if you wanna keep as character-->

data want;
 set test;
 length int float $8.;
 int=scan(put(value,best. -l),1,'.');
 float=scan(put(value,best. -l),-1,'.');
run;