topic Re: Function to count the decimal places in SAS Programming

Function to count the decimal places

Kaushal — Fri, 07 Jun 2013 05:45:21 GMT

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

Re: Function to count the decimal places

sureshv — Fri, 07 Jun 2013 06:45:32 GMT

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;

Re: Function to count the decimal places

Kaushal — Fri, 07 Jun 2013 07:55:36 GMT

thanks

Rgds, Kaushal

Re: Function to count the decimal places

sureshv — Fri, 07 Jun 2013 08:25:47 GMT

reduce code:

data smpl2;

set sample;

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

run;

Re: Function to count the decimal places

SUDOKU — Thu, 19 May 2016 16:08:03 GMT

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.