Solved
New Contributor
Posts: 2

# Function to count the decimal places

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

Accepted Solutions
Solution
‎06-07-2013 02:45 AM
Occasional Contributor
Posts: 10

## Re: Function to count the decimal places

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;

All Replies
Solution
‎06-07-2013 02:45 AM
Occasional Contributor
Posts: 10

## Re: Function to count the decimal places

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;

New Contributor
Posts: 2

## Re: Function to count the decimal places

thanks

Rgds, Kaushal

Occasional Contributor
Posts: 10

## Re: Function to count the decimal places

reduce code:

data smpl2;

set sample;

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

run;

New Contributor
Posts: 4

## Re: Function to count the decimal places

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.

🔒 This topic is solved and locked.