topic string issue in SAS Programming

string issue

mauri0623 — Fri, 03 Jan 2020 16:51:45 GMT

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.

Re: string issue

PeterClemmensen — Fri, 03 Jan 2020 16:55:01 GMT

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

Re: string issue

novinosrin — Fri, 03 Jan 2020 17:02:14 GMT



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

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

Re: string issue

Ksharp — Sat, 04 Jan 2020 10:53:01 GMT


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;