The SAS Output Delivery System and reporting techniques

TAGSET.EXCELXP z/OS question

Reply
Frequent Contributor
Posts: 75

TAGSET.EXCELXP z/OS question

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:

  • Is e-mailing basic spreadsheets from z/OS using Base SAS possible and if so, is my code sound?
  • Is there a better way to store the xml code, possibly through Unix System Services?

Thanks.

Attachment
SAS Super FREQ
Posts: 8,820

Re: TAGSET.EXCELXP z/OS question

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

Ask a Question
Discussion stats
  • 1 reply
  • 558 views
  • 0 likes
  • 2 in conversation