topic Re: The NOREPLACE function is not supported by the XPORT engine. in SAS Programming

The NOREPLACE function is not supported by the XPORT engine.

Shyamkumar — Thu, 10 Dec 2020 16:17:50 GMT

HI All,

Please help where I'm not at all used replace or no replace while generating the xpt files.

Re: The NOREPLACE function is not supported by the XPORT engine.

Reeza — Thu, 10 Dec 2020 17:51:43 GMT

I'm sorry, your question is unclear. What do you have? What do you need? What have you tried - please include any code and logs, especially if you're getting errors.

Re: The NOREPLACE function is not supported by the XPORT engine.

Shyamkumar — Fri, 11 Dec 2020 07:59:00 GMT

");

41 The SAS System
11:14 Thursday, December 10, 2020

SYMBOLGEN: Macro variable R resolves to 2
SYMBOLGEN: Macro variable FT_2 resolves to ce
MPRINT(NEW): libname xpt_dm xport
"/xx/xx/xx/xxx/xxx/xxxx/xxxx/xpt/ce.xpt";
MPRINT(NEW): proc copy in=extracts out=xpt_dm memtype=data;
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable R resolves to 2
SYMBOLGEN: Macro variable FT_2 resolves to ce
MPRINT(NEW): select ce;
MPRINT(NEW): run;
ERROR: The variable name NEWBLINDCOL is illegal for the version 6 file
XPT_DM.CE.DATA.
ERROR: File XPT_DM.CE.DATA has not been saved because copy could not be
completed.
MLOGIC(NEW): %DO loop index variable R is now 3; loop will iterate again.
SYMBOLGEN: Macro variable SDLU_INS_DIR resolves to /RD/SDLU/test
SYMBOLGEN: Macro variable STUDY_NAME resolves to 402162
SYMBOLGEN: Macro variable STUDY_ID_CHAR_NEW resolves to 2859
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable R resolves to 3
SYMBOLGEN: Macro variable FT_3 resolves to dm
MPRINT(NEW): libname xpt_dm xport
"/xx/xxx/xx/x/xxxpt/dm.xpt";
MPRINT(NEW): proc copy in=extracts out=xpt_dm memtype=data;
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable R resolves to 3
SYMBOLGEN: Macro variable FT_3 resolves to dm
MPRINT(NEW): select dm;
MPRINT(NEW): run;
ERROR: The NOREPLACE function is not supported by the XPORT engine.
ERROR: File XPT_DM.DM.DATA has not been saved because copy could not be
completed.
MLOGIC(NEW): %DO l

Re: The NOREPLACE function is not supported by the XPORT engine.

Reeza — Fri, 11 Dec 2020 18:32:33 GMT

ERROR: The variable name NEWBLINDCOL is illegal for the version 6 file
XPT_DM.CE.DATA.

XPT version 6 files have a limit on the length of variable names, 8 characters.

NEWBLINDCOL is 11 characters.

So your data set doesn't meet the requirements to be converted to a XPT data set.

@Shyamkumar wrote:
");

41 The SAS System
11:14 Thursday, December 10, 2020

SYMBOLGEN: Macro variable R resolves to 2
SYMBOLGEN: Macro variable FT_2 resolves to ce
MPRINT(NEW): libname xpt_dm xport
"/xx/xx/xx/xxx/xxx/xxxx/xxxx/xpt/ce.xpt";
MPRINT(NEW): proc copy in=extracts out=xpt_dm memtype=data;
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable R resolves to 2
SYMBOLGEN: Macro variable FT_2 resolves to ce
MPRINT(NEW): select ce;
MPRINT(NEW): run;
ERROR: The variable name NEWBLINDCOL is illegal for the version 6 file
XPT_DM.CE.DATA.
ERROR: File XPT_DM.CE.DATA has not been saved because copy could not be
completed.
MLOGIC(NEW): %DO loop index variable R is now 3; loop will iterate again.
SYMBOLGEN: Macro variable SDLU_INS_DIR resolves to /RD/SDLU/test
SYMBOLGEN: Macro variable STUDY_NAME resolves to 402162
SYMBOLGEN: Macro variable STUDY_ID_CHAR_NEW resolves to 2859
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable R resolves to 3
SYMBOLGEN: Macro variable FT_3 resolves to dm
MPRINT(NEW): libname xpt_dm xport
"/xx/xxx/xx/x/xxxpt/dm.xpt";
MPRINT(NEW): proc copy in=extracts out=xpt_dm memtype=data;
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable R resolves to 3
SYMBOLGEN: Macro variable FT_3 resolves to dm
MPRINT(NEW): select dm;
MPRINT(NEW): run;
ERROR: The NOREPLACE function is not supported by the XPORT engine.
ERROR: File XPT_DM.DM.DATA has not been saved because copy could not be
completed.
MLOGIC(NEW): %DO l