ODS and Base Reporting

Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!
BookmarkSubscribeRSS Feed
wkossack_nspirehealth_com
Calcite | Level 5

I create a spreadsheet with

ods tagsets.ExcelXP

but later I need to open it again to use DDE to manipulate it

error "The converter failed to save the file."

anyway around this?

3 REPLIES 3
Reeza
Super User

I haven't seen this error before, can you post the code you're using that has the issues?

Cynthia_sas
SAS Super FREQ

Hi:

  A quick Google search indicates that this is a MICROSOFT error message and not a SAS error message. So, my guess is that either

1) your DDE is opening the file created by SAS (Spreadsheet Markup Language XML 2003) and DDE doesn't recognize that format or

2) you try some manipulation before Excel is open, or your open of the file fails for some reason.

  To me, this would seem to be a question for a Microsoft forum along the lines of:

If I have an XML 2003 file, how can I open that file and modify it using DDE? I am getting an Excel error that says error "The converter failed to save the file" I would like to know whether anyone else using DDE has had issues with an XML 2003 Spreadsheet Markup Language compliant file.

cynthia

wkossack_nspirehealth_com
Calcite | Level 5

Ah I noticed something....

I could open the file on my PC but on the windows SAS server it would not

XML was set to open with an xml editor not excel.  This problem is now fixed

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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
  • 3 replies
  • 3047 views
  • 0 likes
  • 3 in conversation