Hi, I'm trying to use data step to import & merge many similarly structured CSV files into one, where their first few lines are like: Title Retrieved on xxx . Var1,Var2,Var3 1,2,3... Apparently the actual data begins at row 5, so I tried first: data Want; infile '&path:\*.csv' dlm=',' missover dsd firstobs=5; input var1 var2 var3; run; But the outcome turned out to be that the entering four rows were skipped for the first file, but not for the rest. Namely I had: Var1,Var2,Var3 1,2,3 Title,.,. Retrieved on xxx,.,. .,.,. 4,5,6... I then tried the infile option evo= to skip lines for every files: data Want; infile '&path:\*.csv' dlm=',' missover dsd evo=evo firstobs=5; input @; if evo then input; input var1 var2 var3; evo=0; run; But it didn't work. I have concrete confidence that the above would work for files with row 1 being its header and data beginning at row 2 when you set firstobs=2; However it seemed the same would not work for my scenario. Any help would be appreciated!
... View more
