LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (April 2005, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 22 Apr 2005 08:27:19 -0700
Reply-To:   nabakah@BRAATPAQ.COM
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 field
Comments:   To: Venita DePuy <depuy001@NOTES.DUKE.EDU>
In-Reply-To:   <OF206DDB6F.1BF3A485-ON85256FEB.00535B0C-85256FEB.0053B270@notes.duke. edu>
Content-Type:   text/plain;charset=iso-8859-1

Venita, 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.

hth Nori

> 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 > output. > 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. > > Thanks! > Venita >

Back to: Top of message | Previous page | Main SAS-L page