topic Re: Where do I insert HEADER=NO into LIBNAME Statement for Importing Excel worksheet? in New SAS User

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

lsandell — Sun, 13 Sep 2020 19:28:42 GMT

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.

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

Reeza — Sun, 13 Sep 2020 21:18:20 GMT

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.