PCFLIES Error -in SAS Code

[amitbjambhulkar]

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

[Kurt_Bremser]

Try

set myxls.sheet1;