Help using Base SAS procedures

Excel column limitation on import?

Reply
Contributor
Posts: 26

Excel column limitation on import?

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;

Respected Advisor
Posts: 3,777

Re: Excel column limitation on import?

Just guesing.  Try DBMS=XLSX;

Ask a Question
Discussion stats
  • 1 reply
  • 196 views
  • 3 likes
  • 2 in conversation