Home Forums Main Forums SAS Forum How to skip the first 5 rows when use Proc Import to read Excel file into SAS?

  • How to skip the first 5 rows when use Proc Import to read Excel file into SAS?

     Datura updated 3 years, 1 month ago 1 Member · 1 Post
  • Datura

    Member
    February 2, 2021 at 6:44 pm

    Tip 1:
    Save Excel as CSV , tab-delimited text or fixed-width text may be a good option. You will have more control over there. However, if the Excel file is big, it is hard to open it. This is actually not a good choice.

    Note:
    Datarow = is the starting row of Import, but EXCEL import (DBMS=EXCEL) do not allow this option.

    Instead, you can use XLS import (DBMS=XLS) and use option:
    startrow=
    endrow=

    Do you get it?

Log in to reply.

Original Post
0 of 0 posts June 2018
Now