ODS XCEL in ZOS environment

[kjkripke]

Hello; 

     I am working in an IBM ZOS mainframe and would like to be able to create an XCEL spreadsheet stored in a pre-allocate PDSE with a desired Member name.  I am not certain how to accomplish this.  Does anyone have experience and can direct me to the correct statements to accomplish this?  

[Cynthia_sas · Accepted solution]

Hi:
When you use ODS EXCEL, you are creating a Microsoft XML equivalent of a zip archive. I'm not sure whether that will work stored in a PDSE. You might want to double check with SAS Tech Support on this and how to create the file (path, filename, file extension) and how to transfer the file to a platform where you can open the file (since Excel is not available on zOS to open the Excel file you create).
Cynthia