Function to count the decimal places

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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;

View solution in original post


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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 4539 views
  • 1 like
  • 3 in conversation