When i read the excel by libname, it always have error "ERROR: string is duplicated |><t/>|" in one file, but not in another file, would you please help to guide? thank you very much!
The program is listed as follow:
options validvarname=any;
libname _definea xlsx "&dfadam./datasets/define.xlsx";
data _definea.variables;
set _definea.variables;
run;
options validvarname=v7;
Can you use PROC IMPORT?
proc import out= variables
datafile = "&dfadam./datasets/define.xlsx"
dbms = Excel
replace;
sheet = "variables";
getnames = yes;
run;
This problem has been reported occurring when using proc export, not while using the libname statement. You should verify that all updates regarding access to pc-files are installed and that excel has no problems opening the file. And i am not sure that overwriting a sheet in place works at all.
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 25. 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.