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!
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).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: