topic Re: how can i convert numeric id to character id with trailing zeros? I need 6 digit character. in SAS Programming

how can i convert numeric id to character id with leading zeros? I need 6 digit character.

bhandara — Thu, 03 Sep 2020 01:32:34 GMT

I have numeric values like:

126

145698

I want to convert them into 6 digit character with trailing zeros. The above numbers should appear as:

000012

000126

145698

nazmul — Tue, 01 Sep 2020 01:39:18 GMT

data new; set old;

zip5_char15 = put(gvkey, $6.);

length zipx $ 6;

zipx = left(zip5_char15);

gvkey_char = substr(("00000"||zipx),length(zipx),6);

drop zip5_char15 zipx;

run;

bhandara — Tue, 01 Sep 2020 01:40:15 GMT

Thanks. This was very quick. I appreciate it.

Ksharp — Tue, 01 Sep 2020 11:44:20 GMT

data have;
input x;
want=put(x,z6.);
cards;
12
126
145698
;

RichardDeVen — Tue, 01 Sep 2020 11:52:48 GMT

The question is about how to get LEADING zeros not TRAILING zeros. Edit your question title if possible.

bhandara — Thu, 03 Sep 2020 01:33:09 GMT

Thanks. I just corrected it.