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?


sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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