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

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1624 views
  • 0 likes
  • 2 in conversation