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:@'}
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.