03-07-2014 10:30 PM
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
03-09-2014 11:49 PM
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.