DATA Step, Macro, Functions and more

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

Reply
Super Contributor
Posts: 312

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

[ Edited ]

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!

Super User
Super User
Posts: 7,417
Respected Advisor
Posts: 3,777

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

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.

Ask a Question
Discussion stats
  • 2 replies
  • 420 views
  • 0 likes
  • 3 in conversation