BookmarkSubscribeRSS Feed
Shyamkumar
Calcite | Level 5

HI All,

 

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

3 REPLIES 3
Reeza
Super User
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.
Shyamkumar
Calcite | Level 5
");

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
Reeza
Super User

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

 

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1725 views
  • 0 likes
  • 2 in conversation