topic Re: How to add two decimal points in a numerical value irrespective of its length? in SAS Programming

How to add two decimal points in a numerical value irrespective of its length?

Shradha1 — Tue, 27 Apr 2021 10:50:03 GMT

I have a numerical variable which takes values of varied lengths. I want to add a decimal point before two last two digits in each value. For Example if the original value in a row is 180000, the new value should be 1800.00, and if its 5676456, the new value should be 56764..56

How can I achieve this? Please help

Re: How to add two decimal points in a numerical value irrespective of its length?

PaigeMiller — Tue, 27 Apr 2021 10:52:33 GMT

Divide by 100 and use format 10.2 (or similar)

Re: How to add two decimal points in a numerical value irrespective of its length?

Kurt_Bremser — Tue, 27 Apr 2021 11:21:21 GMT

If you need to do this while reading from an external source, use a proper informat:

data want;
input number 10.2;
format number 10.2;
datalines;
180000
5676456
;