DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 55

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

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!

 

Super User
Posts: 3,256

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

[ Edited ]
Posted in reply to angeliquec

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

 

 

Super User
Posts: 10,035

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

Posted in reply to angeliquec

000000

-->

#####0

Contributor
Posts: 55

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

Posted in reply to angeliquec

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/...

Ask a Question
Discussion stats
  • 3 replies
  • 582 views
  • 2 likes
  • 3 in conversation