dataline starting at row 5?

[ybz12003]

Hello,

When I import the Excel sheet, my dataline starts at row 5.  Please let me know how to specify this?  Thank you.

proc import datafile=ddd out=Crosswalk dbms=excel replace;
		getnames=yes;
		mixed=yes;
		scantext=yes;
run;

[novinosrin · Accepted solution]

would datarow=5 work?

proc import datafile=ddd out=Crosswalk dbms=excel replace;
		getnames=yes;
		mixed=yes;
		scantext=yes;
               datarow=5;
run;

[ybz12003]

Thanks!