Help using Base SAS procedures

Proc Import for Excel File and Some Columns Not Importing

Reply
Regular Contributor
Posts: 152

Proc Import for Excel File and Some Columns Not Importing

Hello I am using SAS to import a Excel 2010 worksheet that has 406 columns, however only 255 columns are importing.  I think I've read that there is a 255 column limit but is there no way to work around this?  The code I'm currently using is: PROC Import Out=Work.Master_A DataFile=c:\test\worksheet1 DBMS=ExcelCS Replace; Range="A1Smiley SurprisedP101"; ScanText=Yes; UseDate=Yes; ScanTime=Yes; Run; Thanks for any assistance.

Super User
Super User
Posts: 7,401

Re: Proc Import for Excel File and Some Columns Not Importing

TBH I avoid using proc import/export.  Save the file as CSV file, then write a small datastep import program.  You then have full control over columns, formats, and conditions.  I can't see why 406 column excel sheet is even usuable.

Super User
Posts: 10,500

Re: Proc Import for Excel File and Some Columns Not Importing

you don't show the full file name for the Excel file. Without an extension of xlsx it could be getting treated as an earlier version with a 255 column limit.

Ask a Question
Discussion stats
  • 2 replies
  • 509 views
  • 0 likes
  • 3 in conversation