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!
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;
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;
1
11
111
;
Blogged about this topic just last Friday ... check it out ... http://www.bi-notes.com/2012/02/sas-coding-adding-leading-zeros-z-format/
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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.