I'm having trouble sending an attachment via email

Dick_Shryock — Mon, 26 Aug 2013 17:26:45 GMT

I have the attached code in a codenode and when I run it the code create an XLSX file that I can read directly using Excel2010. But when it attempts to attach the file to an email, the email is produced but the attachment give an error message

options symbolgen mlogic;
%let TitleDate = %sysfunc(intnx(Month,%sysfunc(date()),-1,B),yymmd7. );
%put &Titledate;
%let Filename = SeenByEMRes.xlsx;
%put &Filename;
%let FullFileName = &TitleDate. &FileName;
%PUT &FullFileName;
PROC SQL;
   CREATE TABLE WORK.SeenByEMResident AS
   SELECT t1.NAME,
          /* Visits */
            (count   (   t1.PAT_ENC_CSN_ID   )) LABEL="Visits" AS Visits
      FROM WORK.QUERY_FOR_PAT_ENC_HSP_0003 t1
      GROUP BY t1.NAME;
QUIT;

proc export data=SeenByEMResident
outfile="\\sasmeta2\projects\mmc\warehouse\wdata\DataSources\MailItAttach\ED\&fullfilename."
dbms=xlsx replace ;
sheet="Residents";
run ;

%PUT &fullfilename;
ods pdf close;
filename mailit email to="mcmulj@mmc.org"
cc="shryor@mmc.org"
bc=""
from="mcmulj@mmc.org"
attach="\\sasmeta2\projects\mmc\warehouse\wdata\DataSources\MailItAttach\ED\&FullFileName."
/* multiple attachments go between parentheses and are separated by spaces */

subject="Resident Volume &Titledate";

data _null_;
file mailit;
put 'THIS IS AN AUTO GENERATED E-MAIL' ;
put;
put 'Hello,';
put;
put;
put' Please find attached an excel file with your results for:';
put;
put "----> Residency Volume For &Titledate <---";
put;
put;
put 'Joel McMullin';
put 'Center for Performance Improvement';
put 'Maine Medical Center';
put '(207) 662-6735';
run;
filename mailit clear;

And this is the log that was produced:

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET SYSLAST=WORK.QUERY_FOR_PAT_ENC_HSP_0003;
4          %LET _CLIENTTASKLABEL='Program1';
5          %LET _CLIENTPROJECTPATH='R:\EM Residents\Seen_By_EMRes\MH_MMC_ASAP_Seen_By_EMRes.egp';
6          %LET _CLIENTPROJECTNAME='MH_MMC_ASAP_Seen_By_EMRes.egp';
7          %LET _SASPROGRAMFILE=;
8
9          ODS _ALL_ CLOSE;
10         OPTIONS DEV=ACTIVEX;
11         GOPTIONS XPIXELS=0 YPIXELS=0;
12         FILENAME EGSR TEMP;
13         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue
13       ! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/5.1/Styles/HtmlBlue.
13       ! css") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");
SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "D:\sastemp\_TD7712_SASMETA2_\Prc2/"
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
14
15         GOPTIONS ACCESSIBLE;
16         options symbolgen mlogic;
17         %let TitleDate = %sysfunc(intnx(Month,%sysfunc(date()),-1,B),yymmd7. );
18         %put &Titledate;
SYMBOLGEN: Macro variable TITLEDATE resolves to 2013-07
2013-07
19         %let Filename = SeenByEMRes.xlsx;
20         %put &Filename;
SYMBOLGEN: Macro variable FILENAME resolves to SeenByEMRes.xlsx
SeenByEMRes.xlsx
21         %let FullFileName = &TitleDate. &FileName;
SYMBOLGEN: Macro variable TITLEDATE resolves to 2013-07
SYMBOLGEN: Macro variable FILENAME resolves to SeenByEMRes.xlsx
22         %PUT &FullFileName;
SYMBOLGEN: Macro variable FULLFILENAME resolves to 2013-07 SeenByEMRes.xlsx
2013-07 SeenByEMRes.xlsx
23         PROC SQL;
24            CREATE TABLE WORK.SeenByEMResident AS
25            SELECT t1.NAME,
26                   /* Visits */
27                     (count   (   t1.PAT_ENC_CSN_ID   )) LABEL="Visits" AS Visits
28               FROM WORK.QUERY_FOR_PAT_ENC_HSP_0003 t1
29               GROUP BY t1.NAME;
NOTE: Table WORK.SEENBYEMRESIDENT created, with 19 rows and 2 columns.

30         QUIT;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

31
32         proc export data=SeenByEMResident
33         outfile="\\sasmeta2\projects\mmc\warehouse\wdata\DataSources\MailItAttach\ED\&fullfilename.
33       ! "
SYMBOLGEN: Macro variable FULLFILENAME resolves to 2013-07 SeenByEMRes.xlsx
2                                           The SAS System               13:18 Monday, August 26, 2013

34         dbms=xlsx replace ;
35         sheet="Residents";
36         run ;

NOTE: The export data set has 19 observations and 2 variables.
NOTE: "\\sasmeta2\projects\mmc\warehouse\wdata\DataSources\MailItAttach\ED\2013-07 SeenByEMRes.xlsx"
      file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
      real time           0.06 seconds
      cpu time            0.00 seconds

37
38         %PUT &fullfilename;
SYMBOLGEN: Macro variable FULLFILENAME resolves to 2013-07 SeenByEMRes.xlsx
2013-07 SeenByEMRes.xlsx
39         ods pdf close;
40         filename mailit email to="mcmulj@mmc.org"
41           cc="shryor@mmc.org"
42           bc=""
43           from="mcmulj@mmc.org"
SYMBOLGEN: Macro variable FULLFILENAME resolves to 2013-07 SeenByEMRes.xlsx
44         attach="\\sasmeta2\projects\mmc\warehouse\wdata\DataSources\MailItAttach\ED\&FullFileName."
45         /* multiple attachments go between parentheses and are separated by spaces */
46
SYMBOLGEN: Macro variable TITLEDATE resolves to 2013-07
47         subject="Resident Volume &Titledate";
48
49
50         data _null_;
51         file mailit;
52           put 'THIS IS AN AUTO GENERATED E-MAIL' ;
53           put;
54           put 'Hello,';
55           put;
56           put;
57           put' Please find attached an excel file with your results for:';
58           put;
SYMBOLGEN: Macro variable TITLEDATE resolves to 2013-07
59           put "----> Residency Volume For &Titledate <---";
60           put;
61           put;
62           put 'Joel McMullin';
63           put 'Center for Performance Improvement';
64           put 'Maine Medical Center';
65           put '(207) 662-6735';
66           run;

NOTE: The file MAILIT is:
E-Mail Access Device

Message sent
      To:          "mcmulj@mmc.org"
      Cc:          "shryor@mmc.org"
3                                           The SAS System               13:18 Monday, August 26, 2013

      Bcc:         ""
      Subject:     Resident Volume 2013-07
      Attachments: "\\sasmeta2\projects\mmc\warehouse\wdata\DataSources\MailItAttach\ED\2013-07
SeenByEMRes.xlsx"
NOTE: 14 records were written to the file MAILIT.
      The minimum record length was 0.
      The maximum record length was 58.
NOTE: DATA statement used (Total process time):
      real time           2.88 seconds
      cpu time            0.00 seconds

67           filename mailit clear;
NOTE: Fileref MAILIT has been deassigned.
68
69
70
71
72
73         GOPTIONS NOACCESSIBLE;
74         %LET _CLIENTTASKLABEL=;
75         %LET _CLIENTPROJECTPATH=;
76         %LET _CLIENTPROJECTNAME=;
77         %LET _SASPROGRAMFILE=;
78
79         ;*';*";*/;quit;run;
80         ODS _ALL_ CLOSE;
81
82
83         QUIT; RUN;
84

I have also attached a screenshot of the error message that I get when I attempt to open the attached xlsx file

Anyone got any ideas what I'm doing wrong???

Thanks, Dick Shryock

Re: I'm having trouble sending an attachment via email

Fugue — Mon, 26 Aug 2013 18:21:29 GMT

If you click "OK" on the error message, are you then able to open the document? There are a couple of SAS problem notes about this error message at http://support.sas.com/kb/8/093.html and http://support.sas.com/kb/44/344.html . . . not sure if this is a related issue.

topic Re: I'm having trouble sending an attachment via email in SAS Enterprise Guide

I'm having trouble sending an attachment via email

Re: I'm having trouble sending an attachment via email