Hi,
I am using SAS on mainframe (z/OS) and I am creating a excel file using xml. All is going well however since the file being created is in EBCDIC format (format used on mainframes), when I download the file on to my Windows desktop (not FTP, download via website), the file is all messed up (contains only symbols) because of the difference in file format. Ofcourse it works fine when I use FTP to download as FTP takes care of the conversion.
My question is:
. I am using SAS 8.2 (we are due to get upgraded to SAS 9 soon but for now, I have to work in SAS 8.2) and because of the client's requirement for the Excel report, I had to manually code the excel report in xml because there is no other way to create a excel report in SAS 8.2 containing multiple worksheets and column filters.
. Throughout the program, I am only using ODS listing - no other ODS. How can I possibly create the output file in ASCII format?
For example, if I was using ODS html, I could have said something like:
ODS listing close;
ODS html body='/htmlFiles/temp.html' TRANTAB=ASCII;
However, in this case, as I mentioned, I am not using any other ODS option other than the default ODS listing. Can I have something similar for ODS listing? Such as:
ODS listing body='/excelReport/theReport.xls' TRANTAB=ASCII;