- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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:
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If that doesn't clear it up, let me know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
That does not help me at all, after running the code it tells me I still get the same errors.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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:
Paige Miller