SAS skip last row with unknown number of rows in proc import -

situation, able import "xls" file if manually delete last row of file before importing it. not know number of observations in file beforehand, therefore cannot use endrow = xx statement skip last row.

proc import      out = testing     datafile = "c:\data\file1.xls"     dbms = xls replace;     namerow = 4;     startrow = 6; run; 

thanks

can save .xls .csv file first? can use data step instead, , eliminate last row based on last observation check or if check specific data. here have set names yourself, not have 'getnames' option.