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, 9 months ago 1 Member · 1 Post
SAS Forum
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?