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!
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
000000
-->
#####0
Thank you for the responses!
But I found the code which also works with proc report -- {tagattr='Format:@'}
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.