Re: warning using libname to convert excel sheet to SAS dataset

mei1006 — Mon, 02 Oct 2017 18:35:36 GMT

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!

Re: warning using libname to convert excel sheet to SAS dataset

Kurt_Bremser — Mon, 02 Oct 2017 19:02:20 GMT

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).

topic Re: warning using libname to convert excel sheet to SAS dataset in ODS and Base Reporting

Re: warning using libname to convert excel sheet to SAS dataset

Re: warning using libname to convert excel sheet to SAS dataset