Separate values like integer and float as two columns

[BrahmanandaRao]

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]

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

[BrahmanandaRao]

Hi Dracut 

output like below

Value	Integer value	Float value
12.356	12	356
45.257	45	257
15.12	15	12
120.12	120	12

[novinosrin]

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 · Accepted solution]

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;