topic Libname statement in SAS Procedures

Libname statement

98ighcfdvxcghjk — Mon, 17 Feb 2020 16:21:57 GMT

Hello,

I always have trouble starting procedures in SAS and I can never create a libname statement correctly on the first try. What i have currently is:

libname xl XLSX "c:NidiaSAS\SASLearn\h188a.xlsx";
run;

But it gives me the errors

ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.

I am not sure what I am doing wrong, can someone show me how to fix it so it can read my data?

Re: Libname statement

SASJedi — Mon, 17 Feb 2020 16:25:20 GMT

Please check out the solution to this problem at https://communities.sas.com/t5/SAS-Analytics-U/ERROR-XLSX-engine-cannot-be-found/m-p/567972/highlight/true#M8660
If that doesn't clear it up, let me know.

Re: Libname statement

98ighcfdvxcghjk — Mon, 17 Feb 2020 16:27:13 GMT

That does not help me at all, after running the code it tells me I still get the same errors.

Re: Libname statement

PaigeMiller — Mon, 17 Feb 2020 16:28:53 GMT

@98ighcfdvxcghjk wrote:

Hello,

I always have trouble starting procedures in SAS and I can never create a libname statement correctly on the first try. What i have currently is:

libname xl XLSX "c:NidiaSAS\SASLearn\h188a.xlsx";

How about this:

libname xl XLSX "c:\NidiaSAS\SASLearn\h188a.xlsx";

with a backslash after c: