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

Hi

I'm creating an Excel file with ods Excel. I don't have any warning, error or critical note in the log.

But when I open it, I get error messages: see pictures as attached files.

 

sas_excel_error.JPGsas_excel_error2.JPGWhen I try to open the log listing repairs I see:

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error153160_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\xxformat\Documents\SASUniversityEdition\myfolders\client\ruiz\result\20181113\201811_.xlsx'</summary><repairedRecords><repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord></repairedRecords></recoveryLog>

 

 

 

Have you already experienced something similar?

Best Regards,

 

I'm using

9.04.01M5P091317) SAS Studio 3.7 on Windows 10.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
xxformat_com
Barite | Level 11

Hi, Thanks for your feedback. In the end I had to change my data selection to be displayed in the Excel file to meet my client needs and don't get anymore the message. So I can only see 2 reasons for the issue : 1/ too many records in the dataset created with proc sql 2/ specific values in the data which could cause the problem.

View solution in original post

4 REPLIES 4
Tom
Super User Tom
Super User

Show the code that actually made the file or better the log.  

Usually I have seen errors when trying to open Excel files it is because the ODS statements ran but the step that was supposed to make the actual data never ran.

Reeza
Super User
I’ve seen this and it’s a bad error. It usually means you made a mistake in the code somewhere.
Cynthia_sas
Diamond | Level 26
Hi:
Most of the time when I've gotten this error, it's because I am using ODS style= overrides and I've made a mistake in specifying something incorrectly, so the generated XML is bad. Seeing the exact code you ran and your log messages will be the most helpful.
Cynthia
xxformat_com
Barite | Level 11

Hi, Thanks for your feedback. In the end I had to change my data selection to be displayed in the Excel file to meet my client needs and don't get anymore the message. So I can only see 2 reasons for the issue : 1/ too many records in the dataset created with proc sql 2/ specific values in the data which could cause the problem.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 3816 views
  • 0 likes
  • 4 in conversation