topic Re: Looking for a function which counts the number of numeric digits in a variable in ODS and Base Reporting

Looking for a function which counts the number of numeric digits in a variable

RobertNYC — Tue, 01 May 2018 22:26:52 GMT

Hi all,

Just like the tile says, I'm Looking for a function which counts the number of numeric digits in a variable. I know there is an easy answer to this question but can't seem to find it. Thanks

ID	Number count
17465	5
571567	6
29	2
144	3
5	1

Re: Looking for a function which counts the number of numeric digits in a variable

novinosrin — Tue, 01 May 2018 22:34:36 GMT

if your id is char, length function will do

count=length(id);

Re: Looking for a function which counts the number of numeric digits in a variable

RobertNYC — Tue, 01 May 2018 22:35:34 GMT

Sorry I should have specified ID is a numeric variable

Re: Looking for a function which counts the number of numeric digits in a variable

Shmuel — Tue, 01 May 2018 22:35:51 GMT

AS the variable is char type you can use:

count = length(strip(ID));

Re: Looking for a function which counts the number of numeric digits in a variable

novinosrin — Tue, 01 May 2018 22:41:32 GMT

Well in that case @Shmuel solution will work for both. However with a log note-->NOTE: Numeric values have been converted to character
values at the places given by: (Line) : (Column).

Re: Looking for a function which counts the number of numeric digits in a variable

PGStats — Tue, 01 May 2018 22:42:53 GMT

data have;
input x;
format x best.;
nbDigits = lengthn(compress(put(x, best. -l)," ","kd"));
datalines;
1
12
123
0000123
0.00123
-123
123000
;

proc print; run;

                                                   nb
                              Obs          x    Digits

                               1           1       1
                               2          12       2
                               3         123       3
                               4         123       3
                               5     0.00123       6
                               6        -123       3
                               7      123000       6

Re: Looking for a function which counts the number of numeric digits in a variable

art297 — Tue, 01 May 2018 23:53:04 GMT

Depends upon what you want! Should 000123 count as 3 digits, or six?. If it's the latter, you could use:

data have;
  input x $;
  nbDigits = lengthn(compress(x,,"kd"));
  datalines;
1
12
123
123 4
0000123
0.00123
-123
123000
;

Art, CEO, AnalystFinder.com

Re: Looking for a function which counts the number of numeric digits in a variable

Ksharp — Wed, 02 May 2018 13:31:15 GMT

data have;
input id;
count=int(log10(id))+1;
cards;
17465	
571567	
29	
144	
5
;
run;
proc print;run;