topic Add Trailing 0 in SAS Programming

Add Trailing 0

msharma1788 — Fri, 27 Apr 2018 08:56:45 GMT

Hi Team,

I have a Zip Code 1235

0234

Need result as 12350000

02340000

Re: Add Trailing 0

RW9 — Fri, 27 Apr 2018 09:03:43 GMT

Post test data in the form of a datastep. I am now having to guess if that zip code is a character or numeric variable! if its numeric then you convert it character:

data want;
  set have;
  new_zip=put(zip_code,z8.);
run;

If its already character:

data want;
  set have;
  new_zip=cats(new_zip,"0000");
run;

Re: Add Trailing 0

Oligolas — Fri, 27 Apr 2018 09:14:03 GMT

Hi,

this will do the trick:

data have;
zip='1235';output;
zip='0234';output;
run;
data want;
   length newzip $10;
   set have;
   newzip=strip(zip)||repeat('0',7-lengthn(strip(zip)));
run;

Re: Add Trailing 0

Ksharp — Fri, 27 Apr 2018 12:49:54 GMT

data have;
zip='1235';output;
zip='0234';output;
run;
data want;
   length zip $ 8;
   set have;
   newzip=translate(left(zip),'0',' ');
run;

Re: Add Trailing 0

ballardw — Fri, 27 Apr 2018 15:25:31 GMT

@msharma1788 wrote:

Hi Team,

I have a Zip Code 1235

                               0234

Need result as        12350000

                                02340000

I have to say that is the oddest Zip code requirement unless this is a non-United States postal code. US Zipcodes are either 5 character or 5digits a dash and 4 digits: 12345-7890 example.