I have created a new program that collects a JSON file from the facebook API. Because facebook allows foreign utf-8 symbols I was unable to use the JSON engine to parse the file. To solve this I run SAS with unicode support. This all works now but my email notification that sends at the end of the program will not work in this utf-8 mode. What do i have to do to send an email while in the utf-8 encoding? do i have to use an encoding statement somewhere? *This is the send code -Works in regular sas but does not work while in utf-8 mode:; ods listing close; ods noptitle; ods msoffice2k file=outbox1 style=sapphire; ods escapechar='^'; title1 "&pdate Facebook Lead Ads Daily Update^n ^n ."; proc odstext; p "--The Facebook Lead Ads Data Update has Completed"; p " "; p "There were ^{style[textdecoration=underline color=red fontweight=bold] &AddedRecords } added to the table Today."; p " "; p "Reporting Available Here--- "; p '<a href= linkaddresshere.xlsx>SharePoint FB_LeadAds Report</a> '; p '<a href=linkaddresshere>DataStudio Subscriptions Report</a> '; run; title; ods msoffice2k close; ods listing;   ... View more

I have a sas program that collects all the data i need but when i try and export it to excel i loose my connection to "local". this code exports 4 seperate files and will fail after 2 export no matter which two i export. This code has worked before but is not working now. Could this be a firewall issue? Need some help. here is the export code that causes the disconnect. All tables exported are less then 2000 lines.If I run in EG it tells me i lost connection, if i run is base it just closes out after exporting two files and gives no errors. /*-------------------------------------------------------*/ /*-----------------Export To Excel File------------------*/ /*-------------------------------------------------------*/ PROC EXPORT DATA=BIS_Campaign OUTFILE= "\\cifs1\blahblahblah\BIS_Campaign.xlsx" DBMS=EXCEL REPLACE; SHEET="Sheet1"; NEWFILE=Yes; RUN;   PROC EXPORT DATA=BIS_Sub OUTFILE= "\\cifs1\blahblahblah\BIS_Subs.xlsx" DBMS=EXCEL REPLACE; SHEET="Sheet1"; NEWFILE=Yes; RUN; PROC EXPORT DATA=BIS_Wait_Final OUTFILE= "\\cifs1\blahblahblah\BIS_SubDetail.xlsx" DBMS=EXCEL REPLACE; SHEET="Sheet1"; NEWFILE=Yes; RUN; PROC EXPORT DATA=BIS_Sent_Final OUTFILE= "\\cifs1\blahblahblah\BIS_Sent.xlsx" DBMS=EXCEL REPLACE; SHEET="Sheet1"; NEWFILE=Yes; RUN; ... View more