Desktop productivity for business analysts and programmers

Exporting data from Enterprise Guide to Excel gives exceeding 256 column error.

Reply
Learner
Posts: 1

Exporting data from Enterprise Guide to Excel gives exceeding 256 column error.

[ Edited ]

Hi,

 

We are currently running SAS Enterprise Guide x32 V 5.100.0.12019 and the Office add-in x32 of the same version number. These are sequenced and deployed with App-V 5.

We are upgrading from office 2013 to office 2016 in our previous 2013 environment everything works fine (no errors).

In our 2016 Environment if a large amount of data is exported to Excel via SAS Enterprise Guide you get the following error:

 

Excel error.png

 

I have re-sequenced SAS in our 2016 environment and still get the same issue.

Is our SAS version too old to work with office 2016?

Any ideas of a work around for this issue?

Any help will be hugely appreciated.

 

Thanks

 

 

Rich

Super User
Posts: 9,612

Re: Exporting data from Enterprise Guide to Excel gives exceeding 256 column error.

Looks to me like the quite old (current version is 7.13) EG does not recognize the newer Office 2016, and assumes the old limitations.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 13,084

Re: Exporting data from Enterprise Guide to Excel gives exceeding 256 column error.

You might want to post the generated code (or code used).

The 256/ 65535 limit looks like you are attempting to write to version of Excel from 20 years ago and not a current XLSX file.

 

I will say any Excel file with 1800+ columns is a problematic thing to begin with.

Frequent Contributor
Posts: 130

Re: Exporting data from Enterprise Guide to Excel gives exceeding 256 column error.

Can you export to csv rather than Excel?

Ask a Question
Discussion stats
  • 3 replies
  • 139 views
  • 0 likes
  • 4 in conversation