I need help with the Tagset.Excelxp ODS feature. I am working with SAS on the Mainframe. I need to access the output of the freq procedure in Excel. I understand that this will create an XML file that Excel can read.
I successfully submitted the program. After I FTP the file to the PC, Excel gives me an error saying that it is not able to read the file.
I assume this has something to do with the mainframe to PC transfer, but it might be something else also. Any ideas?
ODS TAGSETS.EXCELXP FILE=OUTPUT STYLE=SASWEB;
ODS TAGSETS.EXCELXP CLOSE;
I am using SAS version 9.1 and Excel version 2003.
Message was edited by: SASUser at Sep 15, 2006 12:04 PM
I don't know whether it will help with ExcelXP -- but it's specifically recommended for cross-platform creation of HTML files because RS=NONE specifies that every line gets written out one at a time to the file, with the appropriate carriage return/line feed character at the end of every line and thus, there is no awkward wrapping that might get truncated or messed up by FTP. Since XML is a markup language text file, like HTML, it's worth a try.
The other thing is to see if it makes a difference to FTP as TEXT. Otherwise, you may need to contact Tech Support for more help.