warning using libname to convert excel sheet to SAS dataset

[mei1006]

 Many thanks for the information. For my issue,  warning is caused by a character "≥ " in a xlsx file, when I use libname to convert it into SAS dataset. The original text in the xlsx file is"≥ 9 g/dL" and the imported text in my work sas file is " 9 g/dL".

Here is my code:

%let inxls=path/ final.xlsx;

libname inxls xlsx "&inxls";

proc datasets lib=inxls nolist;

modify PDANDAI / CORRECTENCODING='utf-8';

quit;

Here give my ERROR:

ERROR: Update access is not supported for file INXLS.PD_AND_AI.DATA.

data a;

set inxls.PDandAI ;

run;

could you please let me know how I modfy the program to get this resolved?

Many thanks for your help!

[Kurt_Bremser]

I would try an encoding option in the libname, but I have no idea if that would work.

If you work in a UTF environment, it would be best to run SAS with UTF encoding. That must be set at startup (commandline or config option).