|Date: ||Fri, 22 Apr 2005 08:27:19 -0700|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Nori A." <nabakah@BRAATPAQ.COM>|
|Subject: ||Re: Outputting to Excel & dropping leading zeros in character
If SAS is dropping the leading zero, you may be able to use the z5 format
to output the field.
In excel, you can select the column and use the Custom format 00000.
> Hi all -
> a quick question for a beautiful Friday day -
> One of my co-workers is outputting some SAS output to Excel, via ODS html
> One required field is a county code that has values like '09009' etc. SAS
> drops the leading zeros. This is a key field that needs to be used in
> merges, etc. so we've been trying a variety of methods to get around this.
> The main issue being that this is something she's going to have to do a
> LOT, so doesn't want any extra steps in there if at all possible.
> ie we've looked at outputting to a .csv or .txt file then importing into
> Excel - doesn't work as well as a few extra steps.
> Any quick, easy solutions?
> We've tried just forcing Excel to recognized the fields as text not
> numeric, but can never get the leading zeros back.