Inputting multiple files using a wildcard

Accepted Solution Solved
Reply
Super User
Posts: 19,770
Accepted Solution

Inputting multiple files using a wildcard

I'm importing multiple files using a wild card to read all .txt files in a folder.

The data structure is the same but each file does have a header row.

I think there's a way to get SAS to ignore the first row of each file but I can't remember how and haven't found it via google.

firstobs=2 only works for the first dataset.

Any help is appreciated.

Thanks!


Accepted Solutions
Solution
‎12-18-2012 01:20 PM
Respected Advisor
Posts: 3,799

Re: Inputting multiple files using a wildcard

You can use EOV to detect the "change to a new file" and just execute INPUT; to skip the line.

View solution in original post


All Replies
Solution
‎12-18-2012 01:20 PM
Respected Advisor
Posts: 3,799

Re: Inputting multiple files using a wildcard

You can use EOV to detect the "change to a new file" and just execute INPUT; to skip the line.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 252 views
  • 1 like
  • 2 in conversation