topic Re: import an excel file with more than 256 columns in SAS Programming

import an excel file with more than 256 columns

sasphd — Fri, 10 Dec 2021 17:38:03 GMT

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

Re: import an excel file with more than 256 columns

ChrisHemedinger — Fri, 10 Dec 2021 18:01:21 GMT

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;