Itree CHAID crashes due to Missing Data in workspace

Itree CHAID crashes due to Missing Data in workspace

book

Article ID: KB0074062

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0 and later

Description

The Workspace using Advanced Itree CHAID crashes due to missing data in input variables. 

The crash error message is as below:

"Float Invalid Operation. Please carefully review the variables in the data file for unreasonable values."



Cause:

The input variables for Itree CHAID analysis contains missing data which are not recognized as MD code in workspace. 

Resolution

The missing data in input variables are entered as white space or values that are not recognized as MD code in the spreadsheet. User need to define those missing values (e.g. white space in datasheet) as MD code, so that workspace Itree CHAID node could recognize those as MD for analysis.

1. Open the data spreadsheet in workspace

2. Click on the variable with missing values (e.g. white space)

3. Go to "Data | Recode", recode the missing values (e.g. white space) as MD code. Click OK.

For example, variable V80, if V80 = "", recode it to MD code which is usually -999999998 by default. 

Or alternatively Go to "Data | Filter/Recode | Process Missing Data |", define specific missing values or white space as MD code. Click OK.

4. Re-run the Itree CHAID analysis in workspace, the missing values in spreadsheet are then recognized as MD for analysis. 

 

Issue/Introduction

Itree CHAID crashes due to Missing Data in workspace