topic Re: adding zeros to make same length in SAS Enterprise Guide

adding zeros to make same length

woo — Wed, 09 Jul 2014 17:44:14 GMT

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

-----------

987654

892345

6787

9867543

87651234

want dataset should looks like this....

-----------

0000987654

0000892345

0000006787

0009867543

0087651234

Thanks.

Re: adding zeros to make same length

slchen — Wed, 09 Jul 2014 17:56:08 GMT

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

Re: adding zeros to make same length

Reeza — Wed, 09 Jul 2014 17:56:26 GMT

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

Re: adding zeros to make same length

woo — Wed, 09 Jul 2014 18:02:15 GMT

thanks a lot Reeza for your quick response.

I checked and it worked...