- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.);
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
data have;
input x;
_x=put(input(strip(x),10.),z10.);
cards;
987654
892345
6787
9867543
87651234
;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.);
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
thanks a lot Reeza for your quick response.
I checked and it worked...