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:
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.