If you don't mind storing CSV's instead of spreadsheet, you can use PROC EXPORT
like this:
proc export data=HSMFSRBO outfile='/tmp/hsmfsrbo.csv'
dbms=csv replace label;
This code writes the CSV file out to the /tmp directory for the system it runs
on. Sadly, it'll take an extra step to get it into a PDS.
Robert Crawford
Mainframe Management
United Services Automobile Association
(210) 913-3822
"Nothing can be beautiful which is not true."
John Ruskin
Please send requests to mainframe management through our front door at
go/mfmfrontdoor
-----Original Message-----
From: IBM Mainframe Discussion List <[email protected]> On Behalf Of
Kenneth J. Kripke
Sent: Tuesday, November 22, 2022 12:25 PM
To: [email protected]
Subject: EXTERNAL: SAS ODS in the Mainframe environment
Hello;
I realize this is not the correct forum to be asking questions regarding
SAS, but, it appears that SAS-L is no longer available?
The question is as follows:
I would like to produce an XCEL spreadsheet written to a member of a
pre-allocated PDSE. I have fiddled with the various statements to accomplish
this, but, to no avail.
The type of data to be stored is the result of a PROC PRINT with character
data. Does anyone else on the list have some experience and suggestions on
this?
Kenneth J. Kripke
[email protected] <mailto:[email protected]>
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
[email protected] with the message: INFO IBM-MAIN
USAA Classification: Public
Disclaimer: This email and any attachments are the property of USAA and may
contain confidential and/or privileged material. If you are not the intended
recipient, any use, disclosure or copying of this email or any attachments is
unauthorized. If you received this email in error, please immediately notify
the sender and delete the email and any attachments from your computer.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
