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!
Hi,
Its good to check the search first, there are many posts on this, for example:
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.