export to excel

[VDD]

is there a maximin number of columns that SAS will export like 256?

I have a table with 257 columns and I am getting this error

ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: Too many fields defined..
WARNING: File deletion failed for _IMEX_.test.DATA.
ERROR: Export unsuccessful.  See SAS Log for details.

thank you for any assistance.

if there is a maximin number of columns how could I achieve an export with more that is allowed? 

[novinosrin]

"if there is a maximin number of columns how could I achieve an export with more that is allowed"

Very good question and i'm fairly certain no

i'm sure you would have had a look at this http://support.sas.com/kb/13/891.html

http://support.sas.com/kb/34/119.html

but i haven't yet, any luck?

[Reeza]

How are you exporting your data? I thought that issue disappeared with XLSX...

[VDD]

using both xls and xlsx result in the same error.

[SASKiwi · Accepted solution]

Specifying DBMS = Excel could cause this. Try DBMS = XLSX or XLS if you haven't already. I'm assuming you are using PROC EXPORT. Are you? It would help if you posted your code.

[VDD]

fixing the DBMS = xlsx and correctly naming the workbook with the extension xlsx works.