04-28-2015 04:09 AM
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.
09-15-2016 06:23 AM
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.
04-28-2015 04:35 AM
following code will assist you to resolve your problem: