Dear all,              I am trying to import excel file using libname statement but in my dataset variable name start from second row, actual data from third row and data in first row is of no use. How can I set getname from 2nd row and getdata from 3rd row like proc import.              I am trying to this done using following code:   libname myexcel pcfiles path='\BA1.xlsx' scantime=yes stringdates=no dbmax_text=2000 ; data dv; set myexcel.'DV$'n; run;  Not Using proc import because format of data is getting change. ... View more