JSL Companion

3

Modifying and Combining Data Tables

Introduction

Manipulate Rows

Row States

Modify Column Information

Create and Delete Columns

Modify and Subset Portions of Tables

Restructure Tables

Reference and Apply Column Properties

Data Table Variables and Properties

Introduction

Before analyzing any data, the data often need to be cleansed and restructured for the analysis. This is a critical and time-consuming step. There are estimates that as much as 80% of the time spent on analyses is used for this first step. Fortunately, one of the more powerful and useful aspects of JMP is its ability to manipulate and restructure data. With JSL, it is possible to script these time-consuming tasks, and reduce the required effort spent on this step of the analysis. ...