Date: Wed, 14 Dec 2005 16:07:46 -0500
Reply-To: Frida Aminova <faminova@PACE.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Frida Aminova <faminova@PACE.EDU>
Organization: Pace University
Subject: Re: Using Excel Engine Libname
Content-Type: text/plain; charset=us-ascii
Thank you for your input on this...I will definitely try the
alternatives you have recommended.
Although, to satisfy my clients for now, I am using tagsets.MSOffice2K to
create two separate files and attach separate files to represent two
different spreadsheets, which seems to be working fine.
The following is only a part of I have coded in the meantime:
Ods Listing Close ;
Title 'Missing Information' ;
Proc Print Data=Issue_One Noobs ;
Ods Tagsets.MSOffice2K Close ;
Now, I just need to have code more to create multiple-sheets within
one excel file.
Again, thank you for your suggestions - you all are so very helpful. I will
work on this and let you know what happens.
Junior Programmer, IAO
Pace University, DoIT
Phone: (212) 346-1436
Email: FAminova at Pace dot Edu
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David L
Sent: Wednesday, December 14, 2005 2:40 PM
Subject: Re: [SAS-L] Using Excel Engine Libname
> Thank you very much for your response.
>I tried using ct="application/octet-stream", but it did not work. I talked
>to one of our system administrators; he thinks that it's the Sun Netscape
>Mailserver itself because he was able to track the heading of the email
>said the server won't let through certain MIME attachments as David Cassell
>has pointed this out in his response on this. Hopefully, they will resolve
>this 'issue' soon. As soon as it gets resolved, I will post out the
>Again, thank you very much for your time and efforts everyone on this!
Woo-hoo! Another lucky guess hits the target! :-)
Frida, it may take a while to get the problems resolved at the MTA, which in
case is Sun Netscape Mailserver. In the meantime, you can do a couple
 Send a URL to the Excel spreadsheet, instead of the spreadsheet itself.
Then you can stick the URL in your message and have no attachments.
 Drop the HTML in the messge, so there is no chance that the mail server
decide to go to MIME just because it recognized some non-text. This does
appear to be happening to you when you send email without the attachment,
so it may not be a problem. But just in case...
 If you don't find the 'send the URL instead' idea serviceable, you could
sending the tables as text or HTML and inserting them in the email body
instead of as an attachment. That also ought to dodge around the MIME
You know, MIME is *supposed* to be a standard. I don't understand why so
apps have so much trouble with it. I *really* don't understand why Sun has
much trouble with it. Sun MailFool - umm, I mean MailTool - or its MTA has
problems with multiple attachments for as long as I can remember. (Which is
roughly back to the Pleistocene Era. :-)
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Express yourself instantly with MSN Messenger! Download today - it's FREE!