I am using EG7.1, which should with SAS9.4. I wrote the following codes. it can not export the same sheet, each data set automatically generated different sheet. options noxwait xsync; x copy "temp_v0.xlsx" &excel_out; libname xls excel &excel_out ; run; proc datasets lib = xls nolist; delete Summary Rejected1 Rejected2 Point_O_New Point_overall_Existed ; quit; data xls.Summary; set RDP_Sum_t ; run; data xls.Rejected1; set RDP_Sum_Reject ;run; data xls.Rejected2; set RDP_Sum_Reject2 ; run; data xls.Point_overall_Existed ; set Point_1(where=( EXISTINGCUSTOMER='true')); run; libname xls clear; I will try your approach. Thank you very much
... View more