topic import multiple csv files and skip the header rows of all files in SAS Programming

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

fengyuwuzu — Thu, 18 Feb 2016 16:39:59 GMT

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!

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

RW9 — Thu, 18 Feb 2016 16:41:17 GMT

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-text-files-that-have/ta-p/223627

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

https://communities.sas.com/t5/SAS-Procedures/problem-of-using-macro-to-import-multiple-csv-files/m-p/86785/highlight/true#M24791

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

data_null__ — Thu, 18 Feb 2016 17:19:58 GMT

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.