topic ODS XCEL in ZOS environment in SAS Programming

ODS XCEL in ZOS environment

kjkripke — Tue, 22 Nov 2022 18:18:58 GMT

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?

Re: ODS XCEL in ZOS environment

Cynthia_sas — Tue, 22 Nov 2022 18:31:51 GMT

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

Re: ODS XCEL in ZOS environment

kjkripke — Mon, 28 Nov 2022 12:49:42 GMT