How to add "0" to parts of decimals.

[Khaladdin]

Hi all,

I have a quick question related to SAS programming. I have a data set and this data set contains of decimals. I want to "0" to the integer and fractional parts of some decimals. I want to explain it by using just quick example. So, I have the following data set:

     Observation          Decimal

      1                             32.25

      2                             33.2

      3                              2.56

      4                              1.5

And, I want the following data set:

     Observation               Decimal           Want

     1                                  32.25              32.25

     2                                  33.4                33.40

     3                                  2.56                02.56

     4                                  1.5                   01.50

So, as you can see, I add 0 before the integer part if integer part consists of one character (for example it was 2.56 and i want 02.56 - add 0 before 2, since integer part just one character (2)). Additionally, I add the 0 after the fractional part if fractional part consists of one character (for example it was 33.2 and I want 33.20 - add 0 after 4, since  fractional part just one character).

I hope I can explain it. Many thanks in advance for your help.

[WarrenKuhfeld · Accepted solution]

Use the Z format (leading zero format).

data x;
input y;
format y z5.2;
datalines;
 32.25
 33.2
  2.56
 1.5
 ;
 proc print; run;