Read XLS with data starts on 3rd row, and column names on 2nd row

This post was kindly contributed by SAS & Statistics - go there to comment and to read the full post.

proc import file=‘C:Usersprocxsample.xls’
        out=test dbms=xls replace;
        sheet=disposition;
        namerow=2;
        startrow=3;
        getnames=yes;

run;

This post was kindly contributed by SAS & Statistics - go there to comment and to read the full post.