SAS EG export to Excel stopped working in SAS 4.3. CSV and text still work.

[justagba]

Hello,

I had built in the automatic Export as Step In Project so as to expedite my processes. It worked fine before. I now receive the message below:

The open data operation failed. The following error occurred.

Could not open the data source.

I am not sure of what happened. Exporting to CSV and text work fine but for some formatting reasons, I prefer to export to Excel. As there are tens of files, I would prefer not to do the exports manually.

I appreciate any help.

Thank you

[Tom]

There is no SAS 4.3. Did you mean SAS 9.4 maintenance release 3? Or are you trying to specify the release number for Enterprise Guide? I think currently EG is up to release 7.15, so if you are running 4.3 then perhaps it is time to upgrade.

[ballardw]

---

@justagba wrote:

Hello,

I had built in the automatic Export as Step In Project so as to expedite my processes. It worked fine before. I now receive the message below:

The open data operation failed. The following error occurred.

Could not open the data source.

I am not sure of what happened. Exporting to CSV and text work fine but for some formatting reasons, I prefer to export to Excel. As there are tens of files, I would prefer not to do the exports manually.

I appreciate any help.

Thank you

---

So what changed? Did you upgrade SAS (apparently EG)? Relicense SAS (which may mean that certain modules changed such as Access to PC Files to export to Excel). Update OS? Update Office?

Which file type are you exporting to? XLS and XLSX Excel formats are not the same.

Can you post the generated code you use to export "excel"? There are a number of different ways and each has it's own pitfalls.

[justagba]

Yes, we have relicensed. Yes, there were  updates to OS and possibly updates to Office as well. I will see with IT.

Thanks

Justagba

[ballardw]

---

@justagba wrote:

Yes, we have relicensed. Yes, there were  updates to OS and possibly updates to Office as well. I will see with IT.

Thanks

Justagba

---

I would start by checking to see if SAS/ Access to PC Files is included in your new license. If not, that would be one of the more likely culprits. However other ways of creating Access files have been added in later versions of SAS but I am not sure if they work with the EG 4 since the later versions are in the 7.1 or later range.

Since I can think of at least 4 fairly good ways to create Excel files, and couple of others not so good but "work" some of the time, some of those depend on license or installation options.

You really should show us how you are creating the Excel file for more targeted suggestions.

[ChrisHemedinger]

See @CaseySmith's response to this similar question.  Sounds like the same issue, caused by a breaking change in the Microsoft data components.

[justagba]

Thanks everyone for your help.

ChrisHemedinger response  links may shed some light on what the problem seems to be .  I will know for sure if there is a follow up from Microsoft. In the meantime, I am performing my export differently, just not automated.

Justagba