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
Resolved it on my own now. Don't understand the root cause but the issue was somehow related to Excel only and not SAS. Deleted the Excel tab and created a new tab with the same name and it worked fine.
Thanks all for looking.
-Nitin
I don't know if the following is relevant to your situation, or not, but take a look at:
http://support.sas.com/kb/57/485.html
Art, CEO, AnalystFinder.com
Thanks Art for your response.
I had already googled this page before posting in this community. My solution has nothing to do with Hive so that is not relavant. In fact on Google I did not find any page on this particular error string ".... message 728.6" or even "Critical YP subsystem error....".
Thanks,
-Nitin
I posted that note because of its title:
Art, CEO, AnalystFinder.com
Resolved it on my own now. Don't understand the root cause but the issue was somehow related to Excel only and not SAS. Deleted the Excel tab and created a new tab with the same name and it worked fine.
Thanks all for looking.
-Nitin
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.