topic Count of digits in numeric field in SAS Programming

Count of digits in numeric field

Anuz — Wed, 16 Nov 2022 11:44:37 GMT

Hi,

Is there a SAS function to calculate the number of digits in a numeric field ?

For example: I have a roll number numeric field. I want the count to show as below

ROLL NUMBER COUNT

1234567 7

12345 5

1212 4

Thank you

PeterClemmensen — Wed, 16 Nov 2022 12:15:16 GMT

If you're working with integers only, then try the approach in the blog post Compute the number of digits in an integer by @Rick_SAS.

data have;
input ROLLNUMBER;
count = ceil(log10(ROLLNUMBER + 1)); 
datalines;
1234567 
12345   
1212    
;

Result:

ROLLNUMBER count
1234567    7
12345      5
1212       4

Tom — Wed, 16 Nov 2022 13:43:15 GMT

If you know the value is an integer (a whole number) then you could just convert it to a string and count the number of digits.

  digits=length(cats(whole_number));

Anuz — Wed, 16 Nov 2022 13:55:07 GMT

thank you @PeterClemmensen . That is exactly what I needed.