How to filter cases or variables with missing data in TIBCO Statistica?

How to filter cases or variables with missing data in TIBCO Statistica?

book

Article ID: KB0074054

calendar_today

Updated On:

Products Versions
Spotfire Statistica 12.5 and higher

Description

This article details how to filter cases or variables that have missing data in a spreadsheet.

Environment

Windows

Resolution

1. Open the Activities.sta data from the example folder, random missing value are present in this spreadsheet.

2. Under "Data" tab, select "Filter/Recode | Filter Sparse Data..."

3. Click "Variables" to select ALL variables, and click "Cases" to select ALL cases

To filter cases that have any missing value in the row:

4. Enter 100 as the Max percent MD in Variables and 0 as the Max percent MD in Cases (This will delete missing value case-wise)

5. Select "Create new spreadsheet" and Click "OK" to generate a new spreadsheet that excludes rows of any missing value 

Or to filter variables that have any missing value in the column:

4. Enter 0 as the Max percent MD in variables and 100 as the Max percent MD in Cases (This will delete missing value variable-wise)

5. Select "Create new spreadsheet" and Click "OK" to generate a new spreadsheet that excludes columns of any missing value 

Or try different combination to filter sparse cases/variables based on a specific criteria

Note: The Statistica electronic manual included in the installer contains more details and examples about the "Filter Sparse Data feature".

Issue/Introduction

How to filter cases or variables with missing data in TIBCO Statistica?