topic Re: How to keep leading zeros in an Excel file without affecting the other rows in SAS Programming

How to keep leading zeros in an Excel file without affecting the other rows

angeliquec — Fri, 15 Jan 2016 05:50:13 GMT

Hello,

I have this table:

Row Product_Code

1 1234

2 01234

I want to export this table into excel, maintaining the leading zeroes. I've used style(column)={tagattr='00000'} in the proc report code. Though it maintains the value of the product_code of row 2, it affects the product_code of row 1 as well. How can I prevent the other rows (with lengths less than 5) from having unnecessary leading zeros after export?

Thank you!

Re: How to keep leading zeros in an Excel file without affecting the other rows

SASKiwi — Fri, 15 Jan 2016 06:17:29 GMT

There are a number of SAS notes and papers on this issue including these:

http://support.sas.com/kb/38/105.html

http://support.sas.com/resources/papers/proceedings11/266-2011.pdf

Re: How to keep leading zeros in an Excel file without affecting the other rows

Ksharp — Fri, 15 Jan 2016 06:53:09 GMT

000000

-->

#####0

Re: How to keep leading zeros in an Excel file without affecting the other rows

angeliquec — Fri, 15 Jan 2016 07:13:54 GMT

Thank you for the responses!

But I found the code which also works with proc report -- {tagattr='Format:@'}

https://communities.sas.com/t5/ODS-and-Base-Reporting/Maintain-leading-zeros-in-ExcelXP-output/td-p/84101