topic Re: export to excel in New SAS User

export to excel

VDD — Fri, 09 Nov 2018 02:25:57 GMT

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?

Re: export to excel

novinosrin — Fri, 09 Nov 2018 02:31:45 GMT

"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?

Re: export to excel

Reeza — Fri, 09 Nov 2018 02:37:31 GMT

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

Re: export to excel

VDD — Fri, 09 Nov 2018 02:40:36 GMT

using both xls and xlsx result in the same error.

Re: export to excel

SASKiwi — Fri, 09 Nov 2018 03:36:52 GMT

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.

Re: export to excel

VDD — Fri, 09 Nov 2018 14:59:26 GMT

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