string is duplicated

[Chunling]

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;

[qoit]

Can you use PROC IMPORT?

proc import out= variables

    datafile = "&dfadam./datasets/define.xlsx"

    dbms = Excel

replace;

    sheet = "variables";

    getnames = yes;

run;

[andreas_lds]

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.