I'm not sure if this is the place to post this, if not, please let me know the proper place. I created a project in EG using proc report to create an excel spreadsheet that has 3 different tabs and then email the file. This is placed in a macro so it can go through a loop within a file to grab specific information for a region and then email to that regions manager. This works perfect in EG, however, when I put this as a job in DIS - using the exact same code - my email gets sent with the attachment, however I can't open it, it's telling me the file is corrupt. Every email for every file I'm creating is corrupt. What's the difference? What do I need to modifiy in DIS to make this work?
Thanks!
The problem you are getting could be this one:
http://support.sas.com/techsup/notes/v8/18/345.html
You need to ensure that the content type option is set when emailing so when you try to open the attachment it knows what to open it with.
I recently ran into an example of an XLS file that Excel said was corrupted and couldn't get it to open in Excel. But proc import could read it.
I take that as another reason to avoid Excel format files and recommend considering CSV. Yes CSV doesn't support multiple tabs. Since you say this is proc report output perhaps RTF would be acceptable.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.