I'm trying to play around with e-mailing basic 'excel' documents from z/OS. So far I've been able to create a simple workbook with one spreadsheet saved in a PDSE member. I can browse the member and see the xml code. But when I e-mail as attachment, it comes up empty. I don't think its a problem with the ODS logic but with what type of attachment I'm trying to tell the mainframe SMTP to send.
My questions are:
Thanks.
Hi:
When you use ODS TAGSETS.EXCELXP you are creating an XML file -- the XML file describes a Microsoft 2003 Workbook according to the Microsoft specification. Some email systems prohibit sending (and receiving) XML files. Whether your system allows emailing of XML files is a question for your company's mail group. Emailing any file from z/OS is possible, assuming that all the startup options about emailing and SAS have been set appropriately and that you have checked with your mail folks to be sure that they allow emailing of XML and that the copy of SAS that you use has the right email options set. You should check the documentation. All the system options start with "EMAIL..." () In addition, if you are creating the files in EBCDIC, you may want to create the files in ASCII, using options as shown here (SAS(R) 9.4 Companion for z/OS, Second Edition) -- this site has an example of writing ODS output to Unix System Services. Since everything about email is so specific to your operating system and setup, you might want to open a track with Tech Support for more specific help.
cynthia
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.