BookmarkSubscribeRSS Feed
psmitty
Calcite | Level 5

Can someone help me.  I have this issue where I'm trying to attach a file to an email and I'm getting this issue.

 

Code:

ods package(tableausummary_full) open nopf;

ods package(tableausummary_full) add file="C:\Caris Downloads\Rapport Reporting\tableausummary_full.txt";

ods package(tableausummary_full) publish archive

 properties(archive_name='tableausummary_full.zip'

 archive_path='C:\Caris Downloads\Rapport Reporting');

ods package(tableausummary_full) close;

run;

options emailsys=smtp emailhost=smtp.XXXX.com emailport=25;

filename mymail email "pamela.smith@XXXX.com" subject="Rapport Credit Update";

data _null_;

file mymail

 attach=("C:\Caris Downloads\Rapport Reporting\tableausummary_full.zip" lrecl=32727);

put 'Hi Sai - ';

put 'attached is update data file';

run; 

 

 

ERROR LOG:

202 ods package(tableausummary_full) open nopf;

203

204 ods package(tableausummary_full) add file="C:\Caris Downloads\Rapport

204! Reporting\tableausummary_full.txt";

205

206 ods package(tableausummary_full) publish archive

207 properties(archive_name='tableausummary_full.zip'

208 archive_path='C:\Caris Downloads\Rapport Reporting');

NOTE: Writing TABLEAUSUMMARY_FULL file: C:\Caris Downloads\Rapport

Reporting\tableausummary_full.zip

209 ods package(tableausummary_full) close;

210 run;

211

212 options emailsys=smtp emailhost=smtp.XXXX.com emailport=25;

213 filename mymail email "pamela.smith@XXXX.com" subject="Rapport Credit Update";

214 data _null_;

215 file mymail

216 attach=("C:\Caris Downloads\Rapport Reporting\tableausummary_full.zip" lrecl=32727);

217 put 'Hi Sai - ';

218 put 'attached is update data file';

219 run;

NOTE: The file MYMAIL is:

E-Mail Access Device

WARNING: Email: 552 5.3.4 Message size exceeds fixed maximum message size

NOTE: 2 records were written to the file MYMAIL.

The minimum record length was 9.

The maximum record length was 28.

NOTE: DATA statement used (Total process time):

real time 54.48 seconds

cpu time 7.37 seconds
2 REPLIES 2
Reeza
Super User

How big is the attachment? Email clients often have limits of 10/25/50 MB but that would be enforced by your IT area. 

 

psmitty
Calcite | Level 5
Its only 15MB which is weird. I sent it through Windows Scheduler and it worked fine. Not sure what happened with SAS logic. Any thoughts?


hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 3211 views
  • 0 likes
  • 2 in conversation