https://communities.sas.com/t5/SAS-Programming/How-to-readin-with-fixed-count-of-Columns-with-PROC-IMPORT/m-p/885214#M349770 <P>Using Proc IMPORT to readin huge CSV files with lots of columns.</P> <P>&nbsp;</P> <P>Say the CSV file has 100 columns and ONLY like to readin the first 90 columns, how to do it?!</P> <P>Here is DATAROW option... but no DATACOLUMN option, or right?!</P> Tue, 18 Jul 2023 07:34:13 GMT hellohere 2023-07-18T07:34:13Z https://communities.sas.com/t5/SAS-Programming/How-to-readin-with-fixed-count-of-Columns-with-PROC-IMPORT/m-p/885214#M349770 <P>Using Proc IMPORT to readin huge CSV files with lots of columns.</P> <P>&nbsp;</P> <P>Say the CSV file has 100 columns and ONLY like to readin the first 90 columns, how to do it?!</P> <P>Here is DATAROW option... but no DATACOLUMN option, or right?!</P> Tue, 18 Jul 2023 07:34:13 GMT https://communities.sas.com/t5/SAS-Programming/How-to-readin-with-fixed-count-of-Columns-with-PROC-IMPORT/m-p/885214#M349770 hellohere 2023-07-18T07:34:13Z https://communities.sas.com/t5/SAS-Programming/How-to-readin-with-fixed-count-of-Columns-with-PROC-IMPORT/m-p/885216#M349771 <P>Do <STRONG>NOT</STRONG> use PROC IMPORT for csv files. Write the DATA step yourself, and you get full control.</P> <P>You can take the DATA step that PROC IMPORT writes to the log as a starting point. During the adaptation, weed out all the unnecessary stuff that IMPORT does, and make the code readable.</P> Tue, 18 Jul 2023 07:44:12 GMT https://communities.sas.com/t5/SAS-Programming/How-to-readin-with-fixed-count-of-Columns-with-PROC-IMPORT/m-p/885216#M349771 Kurt_Bremser 2023-07-18T07:44:12Z