| Date: | Tue, 13 Dec 2005 17:39:52 -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 |
|---|
| In-Reply-To: | <0IRG000YDHMML440@mmp2.pace.edu> |
|---|
| Content-type: | text/plain; charset=us-ascii |
|---|
David:
Thank you for your effort to assist me on this. The following are the specs
you've asked for:
SAS version ---- SAS 9.1.3
OS ---- Windows XP workstation, which will be put to
Windows 2003 Server once the issue is resolved
email client ---- Outlook 2003
email protocol (is it SMTP?) ---- Yes, SMTP
email server (program, and OS it sits on) ---- Sun Netscape
MailServer
Sincerely,
Frida Aminova
Junior Programmer, IAO
Pace University, DoIT
Phone: (212) 346-1436
Email: FAminova at Pace dot Edu
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David L
Cassell
Sent: Tuesday, December 13, 2005 2:36 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Using Excel Engine Libname
faminova@PACE.EDU wrote:
>1 Libname Issues 'C:\Projects\Issue1.xls' ;
>NOTE: Libref ISSUES was successfully assigned as follows:
> Engine: EXCEL
> Physical Name: C:\Projects\Issue1.xls
>2
>3 Filename SENDTO EMAIL TO = ( 'faminova@pace.edu')
>4 SUBJECT = ('Some Processing Issues')
>5 TYPE = ('Text/Html')
>6 ATTACH = ('C:\Projects\Issue1.xls');
>7
>8 Data Issues.Example1 ;
>9 Set Issue_One ;
>10 Run ;
>
>NOTE: SAS variable labels, formats, and lengths are not written to DBMS
>tables.
>NOTE: There were 95 observations read from the data set WORK.ISSUE_ONE.
>NOTE: The data set ISSUES.Example1 has 95 observations and 26 variables.
>NOTE: DATA statement used (Total process time):
> real time 0.01 seconds
> cpu time 0.01 seconds
>
>
>11
>12 Data Issues.Example2 ;
>13 Set Issue_Two ;
>14 run ;
>
>NOTE: SAS variable labels, formats, and lengths are not written to DBMS
>tables.
>NOTE: There were 8 observations read from the data set WORK.ISSUE_TWO.
>NOTE: The data set ISSUES.Example2 has 8 observations and 26 variables.
>NOTE: DATA statement used (Total process time):
> real time 0.00 seconds
> cpu time 0.00 seconds
>
>
>15
>16 Libname Issues Clear ;
>NOTE: Libref ISSUES has been deassigned.
>17
>18
>19 Data _Null_;
>20 File SENDTO ;
>21 Put '<HTML><HEAD>'
>22 '<TITLE>Processing Issues</TITLE></HEAD>'
>23 '<BODY><BR>'
>24 '<TABLE BORDER="0" WIDTH="477" '
>25 'CELEPADDING="0" CELLSPACING="0">'
>26 '<TR><TD ALIGN="Center" WIDTH="300">'
>27 '<I><B><FONT COLOR="#669900" FACE="Georgia" SIZE="6">'
>28 'Processing Issues</FONT></B>'
>29 '</I></TD></TR>'
>30 '<TR><TD><FONT COLOR="#669900" FACE="Georgia">'
>31 '<B><I><BR>'
>32 'Please see the attached document for your further review.'
>33 ' Thank you.'
>34 '</I></B></FONT></TD></TR>'
>35 '</TABLE></BODY></HTML>'
>36 ;
>37 Run ;
>
>NOTE: The file SENDTO is:
> E-Mail Access Device
>
>Message sent
> To: 'faminova@pace.edu'
> Cc:
> Bcc:
> Subject: Some Processing Issues
> Attachments: ( 'C:\Projects\Issue1.xls' )
>NOTE: 2 records were written to the file SENDTO.
> The minimum record length was 170.
> The maximum record length was 252.
>NOTE: DATA statement used (Total process time):
> real time 0.39 seconds
> cpu time 0.01 seconds
I won't criticize the use of HTML in the message, but I will say that I
don't like to
get HTML messages. I guess you don't mind.
The rest of your code looks alright, and the log messages look viable.
Your other message has what *looks* like a MIME envelope, but it isn't. I
say that
because it wasn't stripped off by the listserv at UGA. If you have attached
a real
MIME attachment, it would not have come through. So perhaps the problem is
that your MIME attachments are malformed.
If that is the case, then the problem may be further upstream. You are
using a
default email device for your output. That may not be workable for you.
Could
you write back to SAS-L and tell us:
your SAS version
your OS
your email client
your email protocol (is it SMTP?)
your email server (program, and OS it sits on)
whether your sysadmin has given you and your SAS program the privileges to
send MIME attachments in automated mails (just ask your admin people)
I have seen email messages lke this go haywire due to all kinds of
weirdness.
Using Lotus Notes as an email server and client. Using Sun Mailtool to
build the
MIME envelopes. You see, mail normally is sent using SMTP (Simple Mail
Transport
Protocol) through a Mail Transport Agent (your email server), to a Mail User
Agent (your email reader). But adding on MIME attachments nails a whole new
set of problems and protocols onto the side of your email message. So you
need to look into your whole email system to help us track this one down.
HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
| 
