topic Re: dataline starting at row 5? in SAS Programming

dataline starting at row 5?

ybz12003 — Fri, 31 Jan 2020 17:48:48 GMT

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 — Fri, 31 Jan 2020 17:55:14 GMT

would datarow=5 work?

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

ybz12003 — Fri, 31 Jan 2020 18:47:38 GMT

Thanks!