| Date: | Fri, 22 Apr 2005 11:14:10 -0400 |
|---|
| Reply-To: | Venita DePuy <depuy001@NOTES.DUKE.EDU> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Venita DePuy <depuy001@NOTES.DUKE.EDU> |
|---|
| Subject: | Outputting to Excel & dropping leading zeros in character field |
|---|
| In-Reply-To: | <7d1193570504220807318a8ba7@mail.gmail.com> |
|---|
| Content-Type: | text/plain; charset="US-ASCII" |
|---|
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
| 
