SAS如何导入超过256列数据（Excel）

如题，我用的是从Datasteam下载的公司财务数据，excel(xlsx)格式，公司数据是按列分割的，公司数大于1000。如果直接导入的话，只能导入255列数据。

请问：各位前辈，有什么好的解决办法没？

use the following when import your excel file

DBMS=XLSX REPLACE;

google来的：
I googled for a while and got that by defalt the number of variables for importing excel data is 255 by SAS, because the limit of 256 columes in old version office excel. So, we have to let SAS know that it is a new version .xlsx file by changing the above codes “DBMS=EXCEL REPLACE;” to “DBMS=XLSX REPLACE;”

jl60156 发表于 2015-2-12 23:44
use the following when import your excel file

DBMS=XLSX REPLACE;

Thank you.  The problem has been solved by your solution.  Actually, my problem is not specify the "range" correctly.

teqel 发表于 2015-2-12 23:46
google来的：
I googled for a while and got that by defalt the number of variables for importing exc ...

Thank you very much. I'm sorry to award the first answer because he is a little earlier.

junzhenglee 发表于 2015-2-13 00:18
Thank you very much. I'm sorry to award the first answer because he is a little earlier.

不客气，暂时不缺钱

为什么我这么不能解决呢，就是把EXCEL变成XLSX