topic Re: Count the number of digits before decimal and after decimal in SAS Programming

Count the number of digits before decimal and after decimal

Aayushi_17 — Wed, 19 Dec 2018 10:24:47 GMT

Hi all,

i've a dataset like given bellow

N_	36	36	36
Mt_	9581.1728	9791.5262	1366.1106
S_D	2965.8626	2982.0749	398.3543

Now i need to give decimal places for the variables what if other variables contain more decimal places how to find out that .i had tried many things like format, length and etc. but it didn't work well.

is it really possible? if so, can anyone tell me how?

Thanks in advance

Re: Count the number of digits before decimal and after decimal

RW9 — Wed, 19 Dec 2018 10:38:47 GMT

You dont have a dataset like that, you can't have 36 as a variable name, nor can you have multiple of the same variable. Please post test data in the form of a datastep in future:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

As such I can only speak generally in that:

data want;
  have=9581.1728;
  want=lenthn(scan(put(have,best.),2,"."));
run;

So I take the second word from the number after putting it to text, delimited by ., then lengthn() to get how many characters.

Re: Count the number of digits before decimal and after decimal

ShiroAmada — Wed, 19 Dec 2018 10:42:04 GMT

try this

data test;
  input amount 8.;
cards;
9581.1728
398.3543
12.12
1.12
;
run;

data want;
  set test;
  char=compress(amount||"","");
  len=length(char);
  dot=indexc(char,".");
  before=dot-1;
  after=len-dot;
run;

Re: Count the number of digits before decimal and after decimal

Aayushi_17 — Wed, 19 Dec 2018 10:51:39 GMT

thank you