topic string is duplicated in SAS Programming

string is duplicated

Chunling — Fri, 19 Feb 2021 02:21:42 GMT

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;

Re: string is duplicated

qoit — Fri, 19 Feb 2021 03:05:23 GMT

Can you use PROC IMPORT?

proc import out= variables

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

dbms = Excel

replace;

sheet = "variables";

getnames = yes;

run;

Re: string is duplicated

andreas_lds — Fri, 19 Feb 2021 05:49:38 GMT

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.