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?
@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:
That does not help me at all, after running the code it tells me I still get the same errors.
@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:
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.