Excel column limitation on import?

mostater — Mon, 15 Apr 2013 20:39:31 GMT

Hi all,

I am currently running SAS v9.3 on a 64-bit OS, I am using the following code to import data from an Excel file. The file contains 275 columns (variables) but only the first 255 are getting imported. I've read previous discussions on this and it seems like this shouldn't be an issue with version 9.3. Is my code missing something? I have tried adding the option "version='2007';" but it was not successful.

Thanks in advance for any help someone can offer!

proc import datafile='V:\ProjectDirectory\DatafileName.xlsx' out=getdata replace dbms=excelcs;

sheet='SASInput';

usedate=no;

scantime=yes;

run;

proc contents data=getdata varnum;

run;

Re: Excel column limitation on import?

data_null__ — Mon, 15 Apr 2013 21:46:59 GMT

Just guesing. Try DBMS=XLSX;

topic Re: Excel column limitation on import? in SAS Procedures

Excel column limitation on import?

Re: Excel column limitation on import?