01-13-2015 10:28 AM
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="A1P101"; ScanText=Yes; UseDate=Yes; ScanTime=Yes; Run; Thanks for any assistance.
01-13-2015 10:38 AM
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.
01-13-2015 11:33 AM
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.