import an excel file with more than 256 columns

[sasphd]

Hello;

I want to import excel data file to sas. My file has 455 columns but SAS import only 256. 

I use proc import

proc import datafile = 'C:\MaRecherche\Value added infrastructure MFs\database\_0_Fundname_Morningstar.xlsx' DBMS = Excel OUT = mret_morningstar ; sheet="mret_morningstar";

thanks

[ChrisHemedinger · Accepted solution]

Try using DBMS=XLSX -- it's a more recent method that handles the larger capacity of modern Excel files.

proc import 
 datafile = 'C:\MaRecherche\Value added infrastructure MFs\database\_0_Fundname_Morningstar.xlsx' 
 DBMS = XLSX 
 OUT = mret_morningstar ; 
 sheet="mret_morningstar";
run;