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.
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;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.