Example of Concatenating Data Tables and Table Variables | JMP 13.2

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Reshape Data • Concatenate Data Tables • Example of Concatenating Data Tables and Table Variables

•

Example of Concatenating Data Tables and Table Variables

For example, suppose that two cancer trials were conducted at two different hospitals. One of the trials’ data is in the Cancer1.jmp data table, and the other trial’s data is in the Cancer2.jmp data table.

To consolidate the data and the variables into one table, follow these steps:

1.

Select Help > Sample Data Library and open Cancer1.jmp andCancer2.jmp.

Notice that there are two distinct table variables: Dosage Amount and Location. In the concatenated table, columns are created for these two table variables.

2.

From the Cancer1.jmp data table, select Tables > Concatenate.

3.

Select Cancer2 and click Add.

4.

Data and Variables Concatenated

The data and the variables are concatenated. The variables appear as columns in the concatenated table. The notes from each data table are added to the new data table as table variables.

•

Help created on 9/19/2017