Hello, I want to add  two different tables/Dataset in the email body. I am using the below code to generate the email but it takes only one dataset to put it on the email body.   options emailsys=smtp emailhost=XXXXX.com emailport=25; filename REPORT "C:\Results_Bus.html"; filename mymail email To = ("XXXX.com") From = "XXXX.com" subject="Results" content_type = "text/html" ;   ods html file=REPORT; ods noptitle NOPROCTITLE;   PROC REPORT DATA=X nowd HEADLINE HEADSKIP style (report) = {background = white font_size = 8pt font_face = "Verdana" font_size = 8pt just=left} style (column) = {background = white CELLHEIGHT = 3.5% font_face = "Verdana" font_size = 8pt just=left} style (header) = {foreground = cx5e2750 font_face="Verdana" font_size = 9pt just=left background = white} ; run; ods html close;   data _null_; infile REPORT; file mymail; input; if _infile_ ne '</html>' then put _infile_; else do; PUT '<p>** end of email****</p></html>'; END; run;   If I add another Proc report statement with the second dataset  then the email body has two title(The sas system) and looks like two different sections..  Is there a way I can remove the title and make it look like one email body...   PROC REPORT DATA=Y nowd HEADLINE HEADSKIP style (report) = {background = white font_size = 8pt font_face = "Verdana" font_size = 8pt just=left} style (column) = {background = white CELLHEIGHT = 3.5% font_face = "Verdana" font_size = 8pt just=left} style (header) = {foreground = cx5e2750 font_face="Verdana" font_size = 9pt just=left background = white} ; run;    Email Generated :   The SAS System   A B C D Business 7 56 42     The SAS System   X Y Z XY Comp 3 68 34   ** end of email**** ... View more

Hello, Need help in converting a string value to date datatype in my data set. Date was stored in string field and now I want to change it to format mmddyy10.   String values:  12/03/2016 11/29/2016  06/18/2014     ... View more

I need some help to delete few rows from the below table based on some conditions.   For some IDs  for a Year the table has two entries one with value in the amt field and other is empty. I have to delete the records of the IDs which has more than 1 entry for a year and the amt field is empty. Please help.   ID Year Amt   70000031 2009 .   70000031 2010 .   70000031 2011 .  Needs to Be Deleted 70000031 2011 526.2906   70000031 2012 .   70000031 2013 200   70000031 2014 .   70000031 2015 .   70000031 2016 .  Needs to Be Deleted 70000031 2016 119   70000895 2009 .   70000895 2010 100   70000895 2011 .   70000895 2012 .  Needs to Be Deleted 70000895 2012 2186.864   70000895 2013 .   70000895 2014 .   70000895 2015 .  Needs to Be Deleted 70000895 2015 340.2716   70000895 2016 .   70000895 2017 6789   ... View more

Hello I am using the below code to send email but it throws a truncation warning and email failed to send. Looks like filename only takes record length of 256 .Can you please help to increase the length.Thank you   %Macro FinalEmail1(); options emailsys=smtp emailhost=one.two.com emailport=25; filename mymail email To = ("psivxaXXXXXX@Repl.com" "XXXXXXXXAVVVVV@Repl.com" "XXXXXAAAAAA@Repl.com" "XXXXXXXAXXXAAAAA@Repl.com") From = "X@Repl.com" subject="REPORT Address Weekly - CUST-Address SUCESS XXXXXX" attach = ("C:\Internal\Auto\Weekly\Logs\NECT-Address.log" LRECL=32727); Data _Null_;  File MyMail;  Put ;  Put "&FinalMessage_Address";  Put ; Run; %Mend;     Error : 128        %Macro FinalEmail1(); 129        options emailsys=smtp emailhost=one.two.com emailport=25; 130        WARNING: Truncated record. filename mymail email To = ("psivxaXXXXXX@Repl.com" "XXXXXXXXAVVVVV@Repl.com" "XXXXXAAAAAA@Repl.com" "XXXXXXXAXXXAAAAA@Repl.com") From = "X@Repl.com" subject="REPORT Address Weekly - CUST-Address SUCESS XXXXXX" attach = ("C:\Internal\Auto\Weekly\Logs\NECT     ... View more

I like to copy data from one dataset to another example from dataset B to dataset A but if there are 0 zero records in dataset B it should not overwrite dataset A.  Is there any where clause option I can add in the set option to check  this. Thanks   Data A; set B; run; ... View more

I need to assign values to global macro variable based on a if condition , But it fails with error  ERROR 180-322: Statement is not valid or it is used out of proper order.   %global Status; data Hello; Infile 'C:\Users\FSAX.txt' truncover; input a_line $2000. ;   if index(a_line, 'ERROR:') > 0 then do; Main = 1; end;   If Main = 1  then %Let Status = 'Failed : ';   run;   This macro varibale Status is used in other macro functions. ... View more

In macro I am trying to read a string from a file and then send email if it exists.I am using the below code for that and getting few errors.Can someone help me to fix the errors.   %macro FileProcess; Infile 'C:\Users\FSAX.txt' truncover; input a_line $200.; %if index(a_line, 'ERROR:') > 0 %then %do; %Let Message = "Hello"; %Email(); %end; %Mend; %FileProcess;       NOTE: Line generated by the invoked macro "FILEPROCESS". 1 Infile 'C:\Users\FSAX.txt' truncover; ------ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "FILEPROCESS". 1 input a_line $200.; ----- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR: Required operator not found in expression: index(a_line, 'ERROR:') > 0 ERROR: The macro FILEPROCESS will stop executing.   ... View more