That is what I thought but no. Error says bad command or used out of order ... View more

But that deletes the variable names as well. If 1 <_n_ < 3 then delete; you think it will work? DATAROWS=3; should work but I don't know where it goes in the program as it rejected them all. ... View more

SAS 9.4 and xls Variable names are in row 1 Gobble goop I want to skip in row 2 Data begins row 3 ... View more

They are in the first row but need to skip row two and start data at row 3 ... View more

If only, but it is not working. The program below is what I have to work with and datarow=3, firstobs=3, 3n, specifying a range and using getnames=yes - nothing worked. PROC IMPORT OUT= work.test1a DATAFILE= "C:\Users\knorwoo1\Documents\My SAS Files\9.4\BIOE 813\test1\Test1A.xls" DBMS=XLS REPLACE; GETNAMES=YES; RANGE="Sheet1$"; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; proc print; run; ... View more

well how do you drop row 2 because nothing I have done works. ... View more