https://communities.sas.com/t5/SAS-Procedures/Add-Leading-Zero/m-p/14411#M2290 Hello everyone,<BR /> <BR /> I am reading in a numeric field (5 digit zip code). It comes in an excel doc. The leading zero is missing b/c excel doesn't keep the leading zero. Is there a way for me to add the leading zero to the 5 digit zip code (numeric) in my sas dataset?<BR /> <BR /> I would like to keep it as a 'numeric' field.<BR /> <BR /> Thanks for any input! Mon, 09 Nov 2009 22:58:17 GMT KevinC_ 2009-11-09T22:58:17Z https://communities.sas.com/t5/SAS-Procedures/Add-Leading-Zero/m-p/14411#M2290 Hello everyone,<BR /> <BR /> I am reading in a numeric field (5 digit zip code). It comes in an excel doc. The leading zero is missing b/c excel doesn't keep the leading zero. Is there a way for me to add the leading zero to the 5 digit zip code (numeric) in my sas dataset?<BR /> <BR /> I would like to keep it as a 'numeric' field.<BR /> <BR /> Thanks for any input! Mon, 09 Nov 2009 22:58:17 GMT https://communities.sas.com/t5/SAS-Procedures/Add-Leading-Zero/m-p/14411#M2290 KevinC_ 2009-11-09T22:58:17Z https://communities.sas.com/t5/SAS-Procedures/Add-Leading-Zero/m-p/14412#M2291 Hi:<BR /> SAS does not store leading zeroes internally. However, you can ALWAYS display leading zeroes, (in procedure output) by using the Z format.<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a000205244.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a000205244.htm</A><BR /> <BR /> [pre]<BR /> format zipcode z5.;<BR /> [/pre]<BR /> <BR /> cynthia Mon, 09 Nov 2009 23:11:45 GMT https://communities.sas.com/t5/SAS-Procedures/Add-Leading-Zero/m-p/14412#M2291 Cynthia_sas 2009-11-09T23:11:45Z https://communities.sas.com/t5/SAS-Procedures/Add-Leading-Zero/m-p/14413#M2292 Thank you so much, Cynthia! Tue, 10 Nov 2009 14:48:26 GMT https://communities.sas.com/t5/SAS-Procedures/Add-Leading-Zero/m-p/14413#M2292 KevinC_ 2009-11-10T14:48:26Z