import multiple csv files and skip the header rows of all files

fengyuwuzu · Posted 02-18-2016 11:30 AM

each csv file has a header row. when I used the code below, the header row of the first file is skpped, but all header rows from the second file were kept.

data mydata;
infile "c:\temp\*.csv" dlm=',' missover dsd lrecl=32767 firstobs=2;
input
var1
var2 $
var3
var4 
...
;

how to solve this problem? Thanks!

RW9 · Posted 02-18-2016 11:41 AM

Hi,

Its good to check the search first, there are many posts on this, for example:

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-tex...

https://communities.sas.com/t5/Base-SAS-Programming/Help-merging-multiple-CSV-files-to-a-dataset/m-p...

https://communities.sas.com/t5/SAS-Procedures/problem-of-using-macro-to-import-multiple-csv-files/m-...

data_null__ · Posted 02-18-2016 12:19 PM

Start by looking up the INFILE statement option EOV=. It is useful for determining the first line of each file when reading from a concatenated FILEREF.

import multiple csv files and skip the header rows of all files

Re: import multiple csv files and skip the header rows of all files

Re: import multiple csv files and skip the header rows of all files

import multiple csv files and skip the header rows of all files

Re: import multiple csv files and skip the header rows of all files

Re: import multiple csv files and skip the header rows of all files

Click image to register for webinar

Classroom Training Available!