02-23-2018 04:48 AM - edited 02-23-2018 04:48 AM
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:
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.
Need further help from the community? Please ask a new question.