topic Re: How can I convert a character value with leading zeros to numeric and maintain the leading zeros? in SAS Enterprise Guide

How can I convert a character value with leading zeros to numeric and maintain the leading zeros?

ncsthbell — Fri, 24 Feb 2012 18:50:25 GMT

I have a data item (is SSN) that is defined with character format. The ssn does NOT have any dashes, just numbers. I need to convert this to numeric without losing the leading zeros. I do not see any functions that would do this. Any suggestions on how I can accomplish this?

Thanks!

Re: How can I convert a character value with leading zeros to numeric and maintain the leading zeros?

art297 — Fri, 24 Feb 2012 18:52:08 GMT

Slightly more involved than I originally posted. You have to use a mixture of put and input functions:

data have;

input x $;

z=put(input(x,9.),z9.);

cards;

111

;

How can I convert a character value with leading zeros to numeric and maintain the leading zeros?

TriciaA — Fri, 24 Feb 2012 18:58:30 GMT

Blogged about this topic just last Friday ... check it out ... http://www.bi-notes.com/2012/02/sas-coding-adding-leading-zeros-z-format/

How can I convert a character value with leading zeros to numeric and maintain the leading zeros?

CarlW — Fri, 02 Mar 2012 18:34:48 GMT

Hi, you can convert the ssn into numeric but define the format as Zw.d. eg:

data test;

x='0001451';

run;

data t1;

set test;

format y z7.;

y=x*1;

run;