DATA Step, Macro, Functions and more

Leading Zero

Reply
anonymous_user
Posts: 0

Leading Zero

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;

Super User
Posts: 10,280

Re: Leading Zero

Posted in reply to anonymous_user

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 85 views
  • 0 likes
  • 2 in conversation