Here is an idea, I hope it helps. In this example I will import an excel file that has the email addresses to tblEmail and then email all the addresses in tblEmail I will assume that the column name for the email address is Email. I dont have SAS at home so I cant test this. /* if you have a table with the email addresses then you dont need this */ PROC IMPORT OUT = WORK.IMPORT      /* CREATE THE TABLE TO IMPORT THE DATA INTO */ DATAFILE = "C:\DATA.XLS"     /* EXCEL FILE TO IMPORT */ REPLACE; /* REPLACE THE TABLE IF IT IS ALREADY THERE /* SHEET = "SHEET1"; /* THE NAME OF THE SHEET TO IMPORT */ GETNAMES=YES; /* COLUMN HEADERS */ RUN; /* let send out the email to everyone */ FILENAME OUTBOX EMAIL; DATA _NULL_; SET WORK.IMPORT END =EOF; FILE OUTBOX FROM = "YOU@YOU.COM" SUBJECT = "HOPE THIS WORKS!" TYPE = "TEXT/HTML"; PUT '!EM_TO!' EMAIL; PUT "Hello!"; PUT "<br><br>"; PUT "I hope this works out for you."; PUT '!EM_SEND!' / '!EM_NEWMSG!'; IF EOF THEN PUT '!EM_ABORT!'; RUN; RUN; This should send an email to each person seperatly until it reaches the end of the table. If your getting the pop-up that asks your permission to send a email with outlook you need to adjust your SASV9.CFG file for SMTP instead of outlook: Right above the area in the file that says something like: /*--------------------------------------------------------------------------------\ | Warning: Install Application edits below this line. User  | |               options should be added above ths comment | |               box..... This is what you want to add: /* Note: Sets up email to use SMTP */ -emailsys SMTP -emailhost EXCHANGEHOST.WHATEVER.WHATEVER.COM /* put your exchange server info here */ -emailport 25 /* 25 works for me, might have to check with your admin */ ... View more

Hi ya, here is an example of How I format the date... data _null_; dt = today(); startdate = (intnx('month',dt,-1)); enddate = intnx('month',dt,0)-1; call symput ('startdate',put(startdate,mmddyy10.)); call symput ('enddate',put(enddate,mmddyy10.)); format startdate enddate mmddyy10.; run; %let startdt = %BQUOTE(')&startdate%BQUOTE('); %let Enddt= %BQUOTE(')&enddate%BQUOTE('); proc sql; create table steff.NB_ATT_plcytrm as select distinct * from connection to db2( select * from edw.table_a where effective_dt >= date(&startdt.) and effective_dt < date(&enddt.) ); quit; ... View more

Hi DanglyticS, Try this out: /*------------ START SAS CODE EXAMPLE ------------- */ DATA _NULL_; DT = TODAY(); TIMESTAMP = DT;      IF DT = INTNX('MONTH',DT,1)-1           THEN DO;                USAGE_TIMESTAMP = DT;      END;           ELSE DO;                 USAGE_TIMESTAMP = INTNX('MONTH',DT,0)-1;      END; PUT USAGE_TIMESTAMP=;  /* PRINT DATE IN LOG TO MAKE SURE IT IS CORRECT FORMAT */ FORMAT USAGE_TIMESTAMP DATE9.; RUN; /*-------------------- END SAS CODE EXAMPLE ---------------- */ I hope this helps you out. Jon S. ... View more