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

How to use replacement node to replace null with zero?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

How to use replacement node to replace null with zero?

How to use replacement node to replace null with zero?

cannot google it, only find replace zero with missing

Thank you


Accepted Solutions
Solution
‎10-08-2014 04:32 PM
SAS Employee
Posts: 26

Re: How to use replacement node to replace null with zero?

Ken - Another option for you may be to use the Impute node to replace all missing values throughout the data set with 0.  This node does not offer the same level of control over the replacement criteria on a per variable basis as the Replacement node does, but it does provide other possibly more meaningful options for the replacement value (other than a default constant like 0).  If you haven't already, you may want to consider imputing missing values with the Impute node.  It all depends on how you intend to analyze the data.

To use the Impute node to simply replace all missing values (for all variables) with 0, set the "Default Input Method" (or Default Target Method) to "Default Constant Value" and set the desired value in the entry provided below that.

Good luck with your analysis.

Brett

View solution in original post


All Replies
Super Contributor
Posts: 358

Re: How to use replacement node to replace null with zero?

I think you are looking for OPTION MISSING=0;

Solution
‎10-08-2014 04:32 PM
SAS Employee
Posts: 26

Re: How to use replacement node to replace null with zero?

Ken - Another option for you may be to use the Impute node to replace all missing values throughout the data set with 0.  This node does not offer the same level of control over the replacement criteria on a per variable basis as the Replacement node does, but it does provide other possibly more meaningful options for the replacement value (other than a default constant like 0).  If you haven't already, you may want to consider imputing missing values with the Impute node.  It all depends on how you intend to analyze the data.

To use the Impute node to simply replace all missing values (for all variables) with 0, set the "Default Input Method" (or Default Target Method) to "Default Constant Value" and set the desired value in the entry provided below that.

Good luck with your analysis.

Brett

Trusted Advisor
Posts: 3,215

Re: How to use replacement node to replace null with zero?

NuLL is not equal to missing. The concepts in a RDBMS and statistical environment are different. What are you doing?

---->-- ja karman --<-----
Occasional Contributor
Posts: 10

Re: How to use replacement node to replace null with zero?

Thank for letting me know, basically I have null in the field revenue from client, and it is null because it cannot find any revenue, so they can be replace with 0.

I then will do a cluster analysis

Thank You

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1582 views
  • 0 likes
  • 4 in conversation