Desktop productivity for business analysts and programmers

adding zeros to make same length

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 318
Accepted Solution

adding zeros to make same length

Hello Friends please help me on this issue....

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
Grand Advisor
Posts: 17,358

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.);

View solution in original post


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
Grand Advisor
Posts: 17,358

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
Super Contributor
Posts: 318

Re: adding zeros to make same length

thanks a lot Reeza for your quick response.

I checked and it worked...

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 437 views
  • 0 likes
  • 3 in conversation