Leading Zero

anonymous_user — Wed, 27 Sep 2017 11:18:56 GMT

Hi,

I am trying to put leading zeros into my code but I can't seem to get it to work, any ideas please?

data test1;
set steve_201708;
length mortgage1 $10.;
mortgage1=(put(input(mortgage,z10.),Z10.));
keep mortgage mortgage1;
run;

Re: Leading Zero

Kurt_Bremser — Wed, 27 Sep 2017 11:30:56 GMT

The input() function requires an informat, and there is no Zw. informat (there is only the output format Zw.)

So you just need to adapt the informat:

data test1;
set steve_201708;
length mortgage1 $10.;
mortgage1=(put(input(mortgage,10.),Z10.));
keep mortgage mortgage1;
run;

Is mortgage really a character variable, or is it numeric? If the latter, just doing

mortgage1=put(mortgage,Z10.);

would be sufficient.