Monday, October 26, 2015

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

proc import file='C:\Users\procx\sample.xls'
        out=test dbms=xls replace;
        sheet=disposition;
        namerow=2;
        startrow=3;
        getnames=yes;
run;

No comments: