The code I’m using.
ods listing close ;
ods path sashelp.tmplmst(read);
ods tagsets.ExcelXP file="tsp_01.xml" style=Statistical ;
proc print data=work.temp01 noobs ;
id var1 ;
by var1 ;
ods tagsets.ExcelXP close ;
ods listing ;
The problem I haven’t been able to find a fix for is the second variable in my dataset is a mixture of numbers and characters so when I input the file into excel some of the variable’s in the column move to the right and the others move to the left. I would like all the values in that column to be characters. How do you do this?
I tried using PROC REPORT and something strange happened, all the values turned to 0. The column only has 1 character per cell either alpha or numeric but now it only show 0's.
I also found the same style option in the PROC PRINT document and tried it as well and it had the same problem.
I did find the following while looking through the XML file. N 0.97463
I removed ss:Formula="0" from the XML file and reloaded the file into Excel and it displayed correctly. Does any one know why or how that ss:Formula="0" was added to the XML file, it appears to be what is causing the problem.
I use tagattr='format:text' but it is probably the same as the @ option.
One difficulty with text is that the word wrapping does not work on the latest version of the ExcelXP tagset (June 2007). I had to edit it to make it work properly. It's got something to do with the additional __r __c and __l elements not inheriting parent attributes, so I removed those DEFINEs, which are new to this version of the tagset compared to the previous one.
Message was edited by: Roddy