topic Re: Proc Import for Excel File and Some Columns Not Importing in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Proc-Import-for-Excel-File-and-Some-Columns-Not-Importing/m-p/179995#M45912 <HTML><HEAD></HEAD><BODY><P>TBH I avoid using proc import/export.&nbsp; Save the file as CSV file, then write a small datastep import program.&nbsp; You then have full control over columns, formats, and conditions.&nbsp; I can't see why 406 column excel sheet is even usuable.</P></BODY></HTML> Tue, 13 Jan 2015 15:38:35 GMT RW9 2015-01-13T15:38:35Z Proc Import for Excel File and Some Columns Not Importing https://communities.sas.com/t5/SAS-Procedures/Proc-Import-for-Excel-File-and-Some-Columns-Not-Importing/m-p/179994#M45911 <HTML><HEAD></HEAD><BODY><P>Hello I am using SAS to import a Excel 2010 worksheet that has 406 columns, however only 255 columns are importing.&nbsp; I think I've read that there is a 255 column limit but is there no way to work around this?&nbsp; The code I'm currently using is: PROC Import Out=Work.Master_A DataFile=c:\test\worksheet1 DBMS=ExcelCS Replace; Range="A1:OP101"; ScanText=Yes; UseDate=Yes; ScanTime=Yes; Run; Thanks for any assistance.</P></BODY></HTML> Tue, 13 Jan 2015 15:28:40 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Import-for-Excel-File-and-Some-Columns-Not-Importing/m-p/179994#M45911 shellp55 2015-01-13T15:28:40Z Re: Proc Import for Excel File and Some Columns Not Importing https://communities.sas.com/t5/SAS-Procedures/Proc-Import-for-Excel-File-and-Some-Columns-Not-Importing/m-p/179995#M45912 <HTML><HEAD></HEAD><BODY><P>TBH I avoid using proc import/export.&nbsp; Save the file as CSV file, then write a small datastep import program.&nbsp; You then have full control over columns, formats, and conditions.&nbsp; I can't see why 406 column excel sheet is even usuable.</P></BODY></HTML> Tue, 13 Jan 2015 15:38:35 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Import-for-Excel-File-and-Some-Columns-Not-Importing/m-p/179995#M45912 RW9 2015-01-13T15:38:35Z Re: Proc Import for Excel File and Some Columns Not Importing https://communities.sas.com/t5/SAS-Procedures/Proc-Import-for-Excel-File-and-Some-Columns-Not-Importing/m-p/179996#M45913 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 13 Jan 2015 16:33:42 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Import-for-Excel-File-and-Some-Columns-Not-Importing/m-p/179996#M45913 ballardw 2015-01-13T16:33:42Z