BookmarkSubscribeRSS Feed

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;

1 REPLY 1
Kurt_Bremser
Super 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.

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 970 views
  • 0 likes
  • 2 in conversation