Hi Guys, I'm facing a wierd problem with my code which was actually working fine earlier. I'm trying to export my data into excel in 2 different tabs, 1st one is working fine but 2nd one is not. 1st (Works complete fine): libname xls excel "D:\CRAS Pack Template.xlsm"; proc datasets lib=xls nolist; delete PerformanceData; run; quit; data xls.PerformanceData; set out.CRAS_Performance; run; libname xls clear; 2nd (Getting error, was working earlier): libname xls excel "D:\CRAS Pack Template.xlsm"; proc datasets lib=xls nolist; delete RetailerFraud; run; quit; data xls.RetailerFraud; set RetailerFraud; run; libname xls clear; The error which I'm getting now is: NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: ERROR: UNABLE TO ACCESS MESSAGE 728.6 ERROR: Critical YP Subsystem error opening message library. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set WORK.RETAILERFRAUD. WARNING: The data set XLS.RetailerFraud may be incomplete. When this step was stopped there were 0 observations and 12 variables. ERROR: ROLLBACK issued due to errors for data set XLS.RetailerFraud.DATA. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds I know this can be achived by other SAS commands like 'ODS excel' or 'Proc export' etc, however I'm not preferring to change the existing code which was working fine. Also I'm using SAS 9.4 TS Level 1M3. Thanks for your help. -Nitin
... View more