Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

renaming variables in E Miner

Reply
N/A
Posts: 1

renaming variables in E Miner

Hi everyone,
Is it possible to rename my variables in E miner? Does this need to be done with a code node? If so can anyone provide sample code?

The reason is that with all the prefixes like REP_ , IMP_, OPT_, etc that get added to the variables, they end up over 30 characters long and Teradata does not acccept these variables when we try to score data using model manager.
SAS Employee
Posts: 31

Re: renaming variables in E Miner

Please also see this tech support note http://support.sas.com/kb/38/578.html

As you indicate I would use the SAS Code node to rename the variables using the macros varaible names for the data sources you want to import and export.

SAS has a 32 character limit.
Teradata has a 30 character limit.
Long variable names is something we look into.
Ask a Question
Discussion stats
  • 1 reply
  • 1146 views
  • 0 likes
  • 2 in conversation