Function to count the decimal places

[Kaushal]

Hi Team,

I am looking for a function in SAS which can count decimal places in a numeric value.

Is anyone aware of any such function ?

Many thanks,

Kaushal

[sureshv · Accepted solution]

data sample;
input count;
datalines;
1.99999
2.0005
99.0001
1023.9999999
104
;
run;

data smpl2;
set sample;
cc=(scan(count,2,"."));
if cc="" then dcount=0;
else dcount=length(cc);
drop cc;
run;

[Kaushal]

thanks

Rgds, Kaushal

[sureshv]

reduce code:

data smpl2;

set sample;

cc=lengthn(scan(count,2,"."));

run;

[SUDOKU]

Sureshv: Thank you for this and I used it today. In my search I was surprised that SAS doesn't have a function that would return the decimal precision and that a conversion to text and then a count was required.