Good day,   we want to implement sas solution to automate our reporting schedule... reports will be storing data in excel/pdf format, plus, we will be sending out emails with the attachment.   here is what we are planning to use and request your opinion if they are compatible   sas enterprise guide version 7.15 (believe this is a latest one) windows 2012 will be using SMTP server to send out emails Assuming it will be compatible with all MS office environments (excel), we will just buy one of the cheaper products Please advise if you see any issues   Plus, is there a way I can download sas eg 7.15 and go through the proof of concept phase before purchasing a license. ... View more

Hi,   I want to send emails to multiple recepients (with attachments) using the email addresses that are stored in the data set. Following is the code that I've used and the error message that I am getting.. please advise     ---------------------CODE that I used - --------------------------------------------------     data TBL_EMAIL; input nuid $ 1-7 email_address $ 9-28 report_id $ 32-33 objectname $ 34-47 objecttype $ 49-64; cards; A111111 myemail@Domain.com 1 test report report A111112 myemail@Domain.com 2 test report report ; run;   %macro email(emailid); FILENAME Mailbox EMAIL "&emailid" Subject='Report - Ran okay' ATTACH="M:\Monthly\Report.xlsx"; DATA _NULL_; FILE Mailbox; PUT "Hello"; PUT "Please find the Report as an attachment"; PUT "Thank you"; PUT " "; RUN; %mend email; %macro email_error; FILENAME Mailbox EMAIL 'xx@yy.com' Subject='Report - Error' ; DATA _NULL_; FILE Mailbox; PUT "Hello"; PUT "Please be advised that Report was generated with potential errors"; PUT "Thank you"; PUT " "; RUN; %mend email_error;   data Table2a_; set Table2(where = ( report_id = 14 ) ); if 180000 <= price <= 300000 then call execute ('data _null_; set TBL_EMAIL; where report_id=1; %email('||email_address||'); run;'); else call execute ('%email_error'); run;     ----------------Error Message that I got ------------------------   NOTE: The file MAILBOX is: E-Mail Access Device ERROR: Invalid E-mail recipient.   -----------------------What worked ------------------------------   Following code worked (suggesting that there is something wrong in a way I am calling the email macro)   data Table2a_; set Table2(where = ( location_ID = 14  ) ); if 180000 <= price <= 300000  then call execute ('%email(myemail@Domain.com)'); else call execute ('%email_error'); run;       Thanks ... View more

Hello, I am pulling data from SQL server.   it takes about 1 hour when I use sas and about 3 mints using SQL server Management Studio. data comes back but takes ages to pull it using SAS   here is a sample code that I used to query... please advise   Proc SQL; create table temp_A as select distinct a.number, b.type, c.country, d.city from             R1.dbo.Tbl_Numbers a left join R1.dbo.Tbl_Type b on (a.ID = b.AcID) left join R1.dbo.Tbl_Country c on (a.CID = c.CID) left join R1.dbo.Tbl_City d on (a.ID = d.AcID) where dateDTTM >= '01Jun2016' and dateDTTM < '01Jun2017' and ( upper(b.Comments) like '%HOURS%' or upper(b.History) like '%HOURS%' or upper(b.Group) like '%HOURS%' ) and c.TCode = 3 and d.ACode in ('F', 'C') ;   Thanks ... View more

Hi,   I need to extract month and a year from datetime field and here is what I have so far (which is not working)   %let date1 = '01Jan2017'd;   data temp_data; set DB.TABLE(where = ( datepart(date_comp) > &date1) ); format MONTH_YEAR  monyy7.; MONTH_YEAR = datepart(date_comp); run;     when I open the dataset, it shows month/year (e.g. JAN2017) but when I download it in excel then it changes it to the date again.   please advise   Thanks in advance ... View more