Thank You for the response. Here is my actual requirement. Steps: 1) I get my input files in local machine(windows) 2) Need to run VBA code to read multiple input file and make one file 3) Need to read input file from SAS EG( from Unix env) 4) run some sas logic and create  output Excel file 5) export into windows and run vba code to format the report 6) Send report in email as attachment. currently we are doing this steps manually. Now i would need to automate it. Since i am using SAS EG i am struggling to copy files from windows to unix automatically vice versa .Another issue is DDE is not working in SAS EG to run VBA codes. Can any one help me on this to understand the best possible solution. Thanks. ... View more

Awesome. Thanks Amir. ... View more

Thanks all !!. I have tried Reeza's approach and it working fine. Thanks for such great response ... View more

Hello- I have prepared data set which has dates and holidays list. needed logic to check for prev-working day. code: options symbolgen mlogic mprint;                                                                                                %macro abc;                                                                                                                            ddmmyy9.;                                                                                                             dt= 1 %to 365;                                                                                                                      'day','31-dec-2012'd,REP,'e');                                                                                         downame10.); 'day','31-dec-2012'd,REP,'e'),DDMMYY9.); ; %mend abc;                                                                                                                             print data = dates; ; calender; dates; (rep_date in('02-jan-2013'd,'14-jan-2013'd,'15-jan-2013'd,'16-jan-2013'd,'01-mar-2013'd)) 1,7)) then  holiday = 'Y'; else holiday = 'N'; ; print; holiday ='Y';run; ... View more

Thank You!! I need to check the public holidays as well, suppose holidays are continuously from  dec20 to dec 25. during these days macro variable should catch dec19. ... View more