Where do I insert HEADER=NO into LIBNAME Statement for Importing Excel worksheet?

[lsandell]

I am importing an Excel worksheet data file to my program, but the variables do not have headers. Where in my LIBNAME statement do I put HEADER=NO?

Code:

LIBNAME Labs XLSX "&CourseRoot/Data/Laboratory.xlsx";

Thanks from a new SAS student.

[Reeza · Accepted solution]

Did you try this:

LIBNAME Labs XLSX "&CourseRoot/Data/Laboratory.xlsx" header=no;

---

@lsandell wrote:

I am importing an Excel worksheet data file to my program, but the variables do not have headers. Where in my LIBNAME statement do I put HEADER=NO?

Code:

LIBNAME Labs XLSX "&CourseRoot/Data/Laboratory.xlsx";

Thanks from a new SAS student.

---