The following code generate a report . proc sql; SELECT PROMO_NBR, PROMO_DESC, Count(PID) as Total FROM eza_lead_report GROUP BY PROMO_NBR, PROMO_DESC; quit; The report should shared by email. Error message : ERROR: Email: The connection was refused. Email code for using : ............................................................................................................................................................... FILENAME outmail EMAIL SUBJECT="Results as of %sysfunc(date(),yymmdd10.)" FROM= "ex10testq@mtbdev.com" TO= "pmuttineni_contractor@mtb.com" ATTACH= "/madata/MAExports/LeadFiles/data.pdf"; FILENAME output EMAIL SUBJECT= "EZA Leads Report Summary" FROM= "ex10testq@mtbdev.com" TO= "pmuttineni_contractor@mtb.com" CT= "text/html" ; ODS HTML BODY=output STYLE=sasweb; TITLE JUSTIFY=left "Total Sales by Country and Product type as of %sysfunc(date(),yymmdd10.)"; /*PROC REPORT DATA=eza_lead_report NOWD STYLE(REPORT)=[PREHTML="<hr>"] ; COLUMNS PROMO_NBR PROMO_DESC,Count; DEFINE PROMO_NBR /GROUP; DEFINE PROMO_DESC/GROUP; DEFINE PID/SUM ; RUN;*/ title1 "Report genarated on %sysfunc(date(),worddate18.)"; proc sql ; create table eza_lead_report as select * from Standard; quit; proc sql; SELECT PROMO_NBR, PROMO_DESC, Count(PID) as Total FROM eza_lead_report GROUP BY PROMO_NBR, PROMO_DESC; quit; ODS HTML CLOSE; DATA _NULL_; FILE outmail; PUT "Here are the results for your last query"; RUN;
... View more