The SAS Output Delivery System and reporting techniques

Loading data into an Excel: Limitaitons from ODS Tagsets.ExcelXP

Reply
Contributor
Posts: 37

Loading data into an Excel: Limitaitons from ODS Tagsets.ExcelXP

I'm desperately looking for a techinque where I can load the data into multiple sheets. Besides, I'ld need to use certain formatting options like WRAP or SPANROWS etc, to wrap the rows with similar values. Also, I may prefer to have Titles and Footnotes in the excel. For some reasons ODS Tagsets.ExcelXP doesnt fit into my purpose as all the Char variables which have got no alphabets or special chars within are autmatically converted to Numeric and hence resulting of trimming all the leading 0's towards left of each value. Also, couldnt autofit the width of the cell with the length of the values.

Any help is appreciated. Thanks.

Frequent Contributor
Posts: 129

Re: Loading data into an Excel: Limitaitons from ODS Tagsets.ExcelXP

Pawan,

Check out this paper from Cynthia Zender, http://http://support.sas.com/resources/papers/proceedings11/266-2011.pdf

She shows how to use the ODS tagattr style attribute to accomplish adding leading zeros into spreadsheets through ODS including the excelXP tagsets.

HTH,

Larry

Ask a Question
Discussion stats
  • 1 reply
  • 283 views
  • 3 likes
  • 2 in conversation