Data Menu

The Data menu is available only when a spreadsheet is open. The following commands are available on the Data menu.

Input Spreadsheet

Direct Mode

Transpose

Block

File

Merge

Subset

Random Sampling

Data Filtering/Recoding

Filter Duplicate Cases

Filter Sparse Data

Process Invariant Variables

Recode Outliers

Process Missing Data

MD Imputation

Replace Missing Data

Statistica Extract, Transform, and Load (ETL)

Time-Indexed

ID-Based

Sort

Auto Filter

Auto Filter

Set as Selection Conditions

Mark Cloaked Cases Excluded

Mark Cloaked Cases Hidden

Cloak Excluded Cases

Cloak Hidden Cases

Verify Data

Verify Data

Find Next Invalid Case

Variable Specs

All Variable Specs

Bundle Manager

Text Labels Editor

Case Names Manager

Variables

Add

Move

Copy

Delete

Cases

Case States

Excluded

Hidden

Label

Marked

Edit Case States

Clear Case States

Copy To Variable

Copy From Variable

Color or Mark by Category

Add

Move

Copy

Delete

Batch Transformation Formulas

Recalculate Spreadsheet Formulas

Rank

Recode

Shift (Lag)

Standardize

Date Operations

Unstacking/Stacking

Seed Random Number

Box-Cox Transformation

Get External Data:

Open Query from File

Create Query

Edit Query

Properties

Refresh Data

Delete Query

Cancel Query

Streaming DB Connector

Statistica Extract, Transform, and Load (ETL)

Time-Indexed

ID-Based

Enterprise Tools

Update Monitor Data

Suspend/Resume Auto Update

Save Window Configuration

Clear Window Configuration