topic Re: How to get the last 2 digits from a numeric value in SAS Programming

How to get the last 2 digits from a numeric value

Avenue — Tue, 28 Apr 2015 08:09:28 GMT

Hi Guys,

I am trying to get the last 2 digits from a numeric field. Can you please assist:

If the value is 101234 then I want my output to be 34.

Thanks in advance.

Re: How to get the last 2 digits from a numeric value

user24feb — Tue, 28 Apr 2015 08:21:25 GMT

You're looking for the modulo-function: mod(101234,100) gives 34.

Re: How to get the last 2 digits from a numeric value

zahirraihan — Tue, 28 Apr 2015 08:35:08 GMT

Hi Avenue,

following code will assist you to resolve your problem:

DATA _null_;

x1=101234;

x2=INPUT(SUBSTR(PUT(x1,best.),LENGTH(PUT(x1,best.))-2+1),2.);

PUT x2=;

RUN;

Re: How to get the last 2 digits from a numeric value

Avenue — Tue, 28 Apr 2015 08:40:26 GMT

Works like a charm. Thanks.

Re: How to get the last 2 digits from a numeric value

aswadhama — Thu, 15 Sep 2016 10:23:33 GMT

Worked great.I wanted to get the output where the the numeric values in a column are not incremented by 100.Example:I want to see where the values are 150,192 etc.The valid values are only 100,200,300... etc. I used in proc sql as

and mod(a.XXXXX_AM,100)<>0 and worked great.