04-12-2016 09:48 AM
I am facing issues with SAS Email utility when the attachment size is crossing 10 MB.
The data(xml coding) is in Mainframe dataset and I am sending it to the receipients email using Email utility. I am using EXTENSION='xls'. Due to the large size of the file, the job is failing to send an email.
When I downloaded the file manually and did SAVE AS .xlsx, its size reduced considerably.
Is there any way to send the mainframe dataset with .xlsx extension as email attachment?
I have seen couple of posts which were talking about some macro. The macro uses Vbscript and do the conversion in Windows folder. I am not sure whether that will help for mainframe dataset as well.
04-12-2016 10:08 AM
There is another discussion from today on the subject of sending Excel files via email. Simply put, Excel is not a good medium for data transfer, nor is email which is limited in size and not secure. I would advise you to investigate proper data transfer formats - XML, CSV, XPT etc. and validated, secure methods of shipping data such as SFTP, secure portal, secure messaging, databases etc.
04-12-2016 10:21 AM
Do you send data or do you send a report? Data is better sent with a minimalist file format like CSV. If you have a report with formatting (eg using ODS TAGSETS.EXCELXP), then you might try to reduce the file size by compressing, if such a tool is present on your mainframe.
.XLSX is basically XML compressed with a zip algorithm. That's why your manually created xlsx was so small.
04-12-2016 03:43 PM
Our IT department has at times set some sever limits on email accounts. That file would not have been sent because under those settings the total size of a users email mail-box would be exceeded. You might want to check with your IT staff if you are running into a similar situation.