PCFLIES Error -in SAS Code

amitbjambhulkar — Wed, 18 Sep 2024 03:18:20 GMT

Hello,

Getting below Error. Please let m me know if anyone have face this issue & how to resolve this.

libname myxls PCFILES server="prod" port=9621 path="e:\sas\PCFiles\Costg\loc_code_lu.xlsx";

data comit.loc_code_lu;
set myxls.'sheet1$'n;
run;

ERROR: CLI describe error: [Microsoft][ODBC Excel Driver] 'sheet1$' is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.

Thanks,

Amit

Re: PCFLIES Error -in SAS Code

Kurt_Bremser — Wed, 18 Sep 2024 09:19:58 GMT

Try

set myxls.sheet1;

topic Re: PCFLIES Error -in SAS Code in SAS Programming

PCFLIES Error -in SAS Code

Re: PCFLIES Error -in SAS Code