adding zeros to make same length

Solved
Super Contributor
Posts: 419

adding zeros to make same length

I have one numeric variable "a" as describe below (tot obs is like 100k). i want to add "0" (zeros) to make this num variable length 10. How can i do that?

have dataset

a

-----------

987654

892345

6787

9867543

87651234

want dataset should looks like this....

a

-----------

0000987654

0000892345

0000006787

0009867543

0087651234

Thanks.

Accepted Solutions
Solution
‎07-09-2014 01:56 PM
Super User
Posts: 24,018

Re: adding zeros to make same length

using a put statement and the Z10 format. This will make a character variable though, as numbers can't have leading zeros.

new_num=put(num, z10.);

All Replies
Super Contributor
Posts: 275

Re: adding zeros to make same length

data have;
input x;
_x=put(input(strip(x),10.),z10.);
cards;
987654
892345
6787
9867543
87651234
;
run;

Solution
‎07-09-2014 01:56 PM
Super User
Posts: 24,018

Re: adding zeros to make same length

using a put statement and the Z10 format. This will make a character variable though, as numbers can't have leading zeros.

new_num=put(num, z10.);

Super Contributor
Posts: 419

Re: adding zeros to make same length

thanks a lot Reeza for your quick response.

I checked and it worked...

🔒 This topic is solved and locked.