BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
NitinP
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
NitinP
Fluorite | Level 6

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

View solution in original post

4 REPLIES 4
art297
Opal | Level 21

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

 

NitinP
Fluorite | Level 6

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

art297
Opal | Level 21

I posted that note because of its title: 

When you attempt to read data from a Hive view, "YP Subsystem" and "UNABLE TO ACCESS MESSAGE 828.1248" errors occur in SAS® Enterprise Guide®

Art, CEO, AnalystFinder.com

 

NitinP
Fluorite | Level 6

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

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1674 views
  • 0 likes
  • 2 in conversation