Here it is, no email was sent: 2          %MACRO SENDMAIL;                                                  3           %IF G_FILEEXIST=1 %THEN                                          4            %DO;                                                            5             FILENAME EML EMAIL 'some.one@work.com'                 6              SUBJECT='FILE ATTACHMENT TEST'                                7              ATTACH=("&G_FNAME" CONTENT_TYPE='TEXT/XML' NAME='ATTACT_TEST' 8                      EXTENSION='XML');                                     9             DATA _NULL_;                                                   10             FILE EML;                                                     11              PUT 'THIS IS A TEST...';                                     12            RUN;                                                           13           %END;                                                           14         %MEND;                                                            15         %GLOBAL G_FNAME G_FILEEXIST;                                      16                                                                           17         FILENAME F01 TEMP;                                                18         ODS LISTING CLOSE;                                                19         ODS TAGSETS.EXCELXP FILE=F01 STYLE=MEADOW;                        NOTE: Writing TAGSETS.EXCELXP Body file: F01                                 NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.94 statement for more information.                                              20         PROC PRINT DATA=SASHELP.CLASS; RUN;                               NOTE: There were 19 observations read from the data set SASHELP.CLASS. 21         %LET FEXIST=%SYSFUNC(FEXIST(F01));                            22         DATA _NULL_;                                                  23          SET SASHELP.VEXTFL;                                          24           WHERE FILEREF='F01';                                        25          CALL SYMPUTX('XPATH',XPATH);                                 26         RUN;                                                                                                                                   NOTE: There were 1 observations read from the data set SASHELP.VEXTFL.         WHERE FILEREF='F01';                                               27         %LET G_FNAME=%SYSFUNC(PATHNAME(F01));                                28         %LET G_FILEEXIST=%SYSFUNC(FILEEXIST(&G_FNAME));                      29         %LET XPATHEXIST=%SYSFUNC(FILEEXIST(&XPATH));                         30         %PUT NOTE: BEFORE ODS CLOSE;                                         NOTE: BEFORE ODS CLOSE                                                          31         %PUT NOTE: FEXIST=&FEXIST;                                           NOTE: FEXIST=1                                                                  32         %PUT NOTE: FNAME=&G_FNAME XPATH=&XPATH;                              NOTE: FNAME=SYS11308.T164648.RA000.XXXENR.R0169855 XPATH=SYS11308.T164648.RA000.XXXENR.R0169855 33         %PUT NOTE: FILEEXIST=&G_FILEEXIST XPATHEXIST=&XPATHEXIST;            NOTE: FILEEXIST=0 XPATHEXIST=0                                                  34         %SENDMAIL                                                            35         ODS TAGSETS.EXCELXP CLOSE;                                           36         %LET FEXIST=%SYSFUNC(FEXIST(F01));                                   37         DATA _NULL_;                                                         38          SET SASHELP.VEXTFL;                                                 39           WHERE FILEREF='F01';                                               40          CALL SYMPUTX('XPATH',XPATH);                                        41         RUN;                                                                 NOTE: There were 1 observations read from the data set SASHELP.VEXTFL.          WHERE FILEREF='F01';                                                42         %LET G_FNAME=%SYSFUNC(PATHNAME(F01));                              43         %LET G_FILEEXIST=%SYSFUNC(FILEEXIST(&G_FNAME));                    44         %LET XPATHEXIST=%SYSFUNC(FILEEXIST(&XPATH));                       45         %PUT NOTE: AFTER ODS CLOSE;                                        NOTE: AFTER ODS CLOSE                                                         46         %PUT NOTE: FEXIST=&FEXIST;                                         NOTE: FEXIST=1                                                                  47         %PUT NOTE: FNAME=&G_FNAME XPATH=&XPATH;                              NOTE: FNAME=SYS11308.T164648.RA000.XXXENR.R0169855 XPATH=SYS11308.T164648.RA000.XXXENR.R0169855 48         %PUT NOTE: FILEEXIST=&G_FILEEXIST XPATHEXIST=&XPATHEXIST;            NOTE: FILEEXIST=0 XPATHEXIST=0                                                  49         %SENDMAIL                                                            ... View more

FriedEgg,     I am not sure your code is working as expected. I am getting this error in my log: 15         %GLOBAL G_FNAME G_FILEEXIST;                   16         %LOCAL FEXIST XPATH XPATHEXIST;                ERROR: The %LOCAL statement is not valid in open code.    Should %LOCAL FEXIST XPATH XPATHEXIST;  be put in the data step? ... View more

Peter,      You are probably right in that it is the way I am defining F01, for clarification this is how I have been defining it: FILENAME F01 TEMP;      Then I write my steps to produce my XML file, pointing my ODS to F01. It seems to be working except for I can not attach F01(the fileref) or the Physical file name of F01(%let physical = %sysfunc( pathname( &logical ));) to an email. Is my only option to allocate a dataset for every file I plan on creating, writing my XML to the dataset, then attaching the dataset?      What I am trying to achieve is a program that will create a variable number of XML files, dependent on the data, and email them all out ... View more

I don't often use SQL so I changed my approach to be something I'm a little more familiar with. Here is what I did (from my log):         DATA _NULL_;                                                            set sashelp.vextfl(keep=fileref xpath);                                  where fileref='F01';                                                   call symputx('fpath',xpath,'l');                                                                                                        NOTE: There were 1 observations read from the data set SASHELP.VEXTFL. WHERE fileref='F01';                                                         data _null_;                                                                   FILE MYEMAIL                                                       SYMBOLGEN:  Macro variable FPATH resolves to SYS11306.T163644.RA000.GP461ENR.R0107137           ATTACH  = ("&fpath");                                                        PUT "Test" ;                                                               RUN;                                                                                                                                                 NOTE: The file MYEMAIL is:                                                            E-Mail Access Device                                                                                                                                      ERROR: Error opening attachment file SYS11306.T163644.RA000.GP461ENR.R0107137.  ERROR: Physical file does not exist, SYS11306.T163644.RA000.GP461ENR.R0107137. I don't understand why I get an error stating the Physical file does not exist, when I can get my macro variable to resolve to it? ... View more

Thanks FriedEgg,     I plugged in your solution and it appeared to work becuase I was able to resolve my macro variable &F01 to a full file path, however I am getting this error: WARNING: The quoted string currently being processed has become more than 262 characters long.  You may have unbalanced quotation marks. ERROR: System abend 0C4 occurred in module SASXAL function  VXSPPTH at offset 00005C.      I have no idea where the unbalanced quotation marks are and was not getting them before or what the error message means, and ideas where to start? ... View more

Thanks again Cynthia! With some tweaking of your program I was able to run it (I had to replace ~newline with ~n). I think with the concepts demonstrated in your program and the paper Tom linked I can achieve what I originally set out to accomplish. ... View more

Thanks for the link Tom. I did read that paper and thought it was a viable option. I aslo read this paper: http://www.quintiles.com/elements/media/inthenews/creating-customized-patient-profiles-using-sas-ods-rtf-and-proc-template.pdf It seems the two papers used slightly different approaches. I opted to use proc template to define my tables as it seemed I would have enough control to do what I needed, instead of putting the whole letter into one variable. Since I can't seem to find a way to fix this 'extra row' problem perhaps I was wrong. ... View more

Thanks Cynthia! Your suggestion about creating the CSV file and doing the mail merge may be my best option. It just feels that if I was able to generate the correct RTF I could skip that step and make my process more efficient. ... View more

I am trying to create the entire letter in SAS, so I can create them dynamically based on my data source. What I posted was a snippet of the letter to illustrate the problem I am having. The adress table in the form letter is six columns: 1.) First Name 2.) Last Name 3.) Address line 1 4.) City 5.) State abbr 6.) Zipcode I need the table to wrap or break at defined locations, after last name and before address line1 and after address line 1 and before city. In my template I used glue -1 to force the break but it seems I get an extra row. After doing some google searching and looking around the forum's I can't seem to find a setting to control this extra row. In case it helps I was able to edit the RTF generated and was able to remove "\par" after each break and that eliminated the extra row. ... View more