How to add "0" to parts of decimals.

Khaladdin — Fri, 23 Feb 2018 09:48:54 GMT

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.

Re: How to add "0" to parts of decimals.

WarrenKuhfeld — Fri, 23 Feb 2018 10:48:30 GMT

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;

topic Re: How to add "0" to parts of decimals. in SAS Programming

How to add "0" to parts of decimals.

Re: How to add "0" to parts of decimals.