Thanks for the help.
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.
Thanks.
Message was edited by: TSP