topic Re: Why am I getting this error and how to resolve it in SAS Programming

Why am I getting this error and how to resolve it

sas_university — Wed, 23 Nov 2022 09:33:09 GMT

Re: Why am I getting this error and how to resolve it

PeterClemmensen — Wed, 23 Nov 2022 09:48:58 GMT

Very hard to say from a bad picture. But definitely drop the BDAYBook1.xlsx part of the Libname Statement.

Re: Why am I getting this error and how to resolve it

SASKiwi — Thu, 24 Nov 2022 03:47:00 GMT

Typically you get that error if there is a mismatch in bitness between SAS and MS Office. For example, SAS is 64-bit and Office is 32-bit. This only applies to the EXCEL LIBNAME engine.

Try LIBNAME bday XLSX "<Your Excel spreadsheet path>";

Re: Why am I getting this error and how to resolve it

Ksharp — Thu, 24 Nov 2022 04:10:22 GMT

Try :
1) libname bday XLSX "c:\.............xlsx";
2) libname bday EXCEL "c:\.............xlsx";