string issue

[mauri0623]

I have a character string that look like the following

5000000

4000000

3000000

I want it to show as

05000000

04000000

03000000

I know I can concatenate a leading zero to fix this, but There are many rows in the dataset that are missing this leading zero. I am looking for some kind of formating.

[PeterClemmensen]

So you want it formated to a fixed length of 8 correct?

[novinosrin · Accepted solution]

data have;
input str $10.;
cards;
5000000
4000000
3000000
;

data want;
set have;
want=put(input(str,32.),z8.);
run;

[Ksharp]

data have;
input str $10.;
cards;
5000000
4000000
3000000
;

data want;
 set have;
 length want $ 8;
 want=left(str);
 want=translate(right(want),'0',' ');
run;