How to get the last 2 digits from a numeric value

[Avenue]

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.

[user24feb]

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

[Avenue]

Works like a charm. Thanks.

[aswadhama]

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.

[zahirraihan]

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;