Thank you so much for your help kurt. ... View more

Questions: Who created this .xls in the first place and how did it get onto the Mainframe?  Ans: Above mentioned SAS has created excel. Would it be possible to change the program that creates the .xls so it only includes the sheets you want to send via email? Ans: Above mentioned SAS has created excel. ... View more

Thank you so much for your time on this post. I have a final question with two scenarios   scenario1: I got email with two excel sheets attached. It worked as expected. DATA REPORT; FORMAT DATE1 MMDDYY8.; CALL SYMPUT ('HDATE',PUT(TODAY(),MMDDYY8.)); FORMAT EMAILDATE MMDDYY8.; PUT "!EM_SUBJECT!" "HDATE11"; FILENAME MYFILE EMAIL FROM= ("KG12456@ABC.COM") TO= ("KG12456@ABC.COM") ATTACH=("USER.GHJK.KKL0M5XR.AMKX.NEWCNTRT" NAME='REPORT1' EXTENSION='XLS' "USER.GHJK.KKL0M5XR.AMKX.OLDCNTRT" NAME='REPORT2' EXTENSION='XLS') TYPE= "TEXT/PLAIN"; DATA REPORT; SET REPORT; FILE MYFILE;     scenario2: I got errors though I have used same files which I used in scenario1. It has keep two files in single excel with tabs. I have highlighted error in bold. DATA REPORT; FORMAT DATE1 MMDDYY8.; CALL SYMPUT ('HDATE',PUT(TODAY(),MMDDYY8.)); FORMAT EMAILDATE MMDDYY8.; PUT "!EM_SUBJECT!" "HDATE11"; FILENAME MYFILE EMAIL FROM= ("KG12456@ABC.COM") TO= ("KG12456@ABC.COM") ATTACH=("USER.GHJK.KKL0M5XR.AMKX.NEWCNTRT" NAME='REPORT1' EXTENSION='XLS' SHEET_NAME='TAB1'                                  ______                                   24 ERROR 24-2: Invalid value for the ATTACH option. "USER.GHJK.KKL0M5XR.AMKX.OLDCNTRT" NAME='REPORT1' EXTENSION='XLS' SHEET_NAME='TAB2') TYPE= "TEXT/PLAIN"; DATA REPORT; SET REPORT; FILE MYFILE; ... View more

It is already in Mainframe XLS format. We dont have facility to define tab name under mainframe dataset. ... View more

Thank you for the reply.  I have to create excelfile with a sheet name. How can I define sheet name. Please shed some light. Here is the error code.   1          DATA REPORT; 2          FORMAT DATE1 MMDDYY8.; 3          CALL SYMPUT ('HDATE',PUT(TODAY(),MMDDYY8.)); 4          FORMAT EMAILDATE MMDDYY8.; 5          PUT "!EM_SUBJECT!" "HDATE11"; 6          FILENAME MYFILE EMAIL 7          FROM= (KG12456@ABC.COM) 8          TO= (KG12456@ABC.COM) 9          ATTACH=("USER.FGHJ.MKINM5XR.XCVX.QWERTY" 10                       NAME='ALTNET_NEW_CONT_RPT' EXTENSION='TXT' 11                 "USER.FGHJ.MKINM5XR.XCVX.ELVRPT" 12                       NAME='SPLIT_CONTRACT_RPT' EXTENSION='XLS' 13                       SHEET_NAME='SHEET1')                                     ________                                     24 ERROR 24-2: Invalid value for the ATTACH option. 14         TYPE= "TEXT/PLAIN"; ERROR: Error in the FILENAME statement. 2                                                          The SAS System     NOTE: Variable DATE1 is uninitialized. NOTE: Variable EMAILDATE is uninitialized. !EM_SUBJECT!HDATE11 NOTE: The data set WORK.REPORT has 1 observations and 2 variables. NOTE: The DATA statement used 0.01 CPU seconds and 19991K.   NOTE: The address space has used a maximum of 876K below the line and 23676K abo     15         DATA REPORT; 16         SET REPORT; 17         FILE MYFILE; ... View more

Thank you for the reply. This is my mainframe dataset "USER.FGHJ.MKINM5XR.XCVX.ELVRPT". I am trying to attach this file as excel. I have to create excelfile with a sheet name. How can I define sheet name. Please shed some light. ... View more