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 >