Desktop productivity for business analysts and programmers

Exporting Multiple Excel sheets with multiple tabs

Reply
Frequent Contributor
Posts: 89

Exporting Multiple Excel sheets with multiple tabs

Hello everybody,

I have different excel files with multiple tabs to be imported.All excel sheets has data starting row 2 ( 1 row blank and 2nd row header). I saw some online documents but they were not straightforward. I am wondering if any body can help me on that

Thanks

Super User
Super User
Posts: 6,845

Re: Exporting Multiple Excel sheets with multiple tabs

I actually tried creating an excel file with nothing in the first row and data starting in the second row and SAS read it fine.  It found the variable names and everything. Not sure how it knew to do that.

Ask a Question
Discussion stats
  • 1 reply
  • 308 views
  • 0 likes
  • 2 in conversation