topic Re: add 'zero' to get Nine digit number in SAS Programming

add 'zero' to get Nine digit number

Alexxxxxxx — Fri, 30 Sep 2022 13:49:44 GMT

Dear all,

is there a way to add leading zeros?

I have the ‘Have’ row and expect to get the 'Want' row (add 'zero' to get Nine digit number, No need to convert to Num).

Have	Want
123456789	123456789
12345678	012345678
1234567	001234567
123456	000123456
12345	000012345
1234	000001234
123	000000123
12	000000012
1	000000001

Could you please give me some advice about this?

Many thanks in advance.

data have ;
  input variable :$29.;
cards;
123456789
12345678
1234567
123456
12345
1234
123
12
1
;

Re: add 'zero' to get Nine digit number

Tom — Fri, 30 Sep 2022 14:02:22 GMT

9 digit or 29 digit?

Check out this old question: https://communities.sas.com/t5/SAS-Programming/char-function-add-left-zeroes/m-p/785107#M250540

data have ;
  input variable :$9.;
cards;
123456789
12345678
1234567
123456
12345
1234
123
12
1
;

data want;
  set have;
  variable = translate(right(variable),'0',' ');
run;

If you want the 9 digit number that is stored in a variable that is actually longer than 9 bytes then change to:

  variable = translate(right(substr(variable,1,9)),'0',' ');

Re: add 'zero' to get Nine digit number

PeterClemmensen — Fri, 30 Sep 2022 14:03:16 GMT

Try this

data have ;
  input variable :$29.;
cards;
123456789
12345678
1234567
123456
12345
1234
123
12
1
;

data want;
   set have;
   newvar = put(input(variable, 9.), z9.);
run;