Using tabulate to reorder all data table values

Nino

Hello,

 

This is probably an easy question, however so far I just was not able to solve it in JMP 12.

 

I have a data table that I need to reorder. The data table has basically the following outline

Batch	Timepoint	Observation
1	0	2
1	0	2
1	0	2
1	1	4
1	1	4
1	1	4
2	0	...

To process the data table in another programm I need the following outline

Timepoint	Observation Batch 1	Observation Batch 2
0	2
0	2
0	2
1	4
1	4
1	4

While it is pretty straight foward to tabulate the mean values for example by using Analyze-> Tabulate, I just can not find a way to have every observation in the new data table.

Any hints how to do that?

 

Thank you in advance for your help.

 

Nino

ian_jmp

Take a look at the menu option 'Tables > Split' and the associated Help.

 

In JSL:

NamesDefaultToHere(1);

dt1 = New Table( "Stacked",
				Add Rows( 12 ),
				New Column( "Batch",
					Numeric,
					"Nominal",
					Format( "Best", 12 ),
					Set Values( [1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2] )
				),
				New Column( "Timepoint",
					Numeric,
					"Ordinal",
					Format( "Best", 12 ),
					Set Values( [0, 0, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1] )
				),
				New Column( "Observation",
					Numeric,
					"Continuous",
					Format( "Best", 12 ),
					Set Values( [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12] )
				)
			);

// 'Tables > Split'
dt2 = dt1 << Split(
			Split By( :Batch ),
			Split( :Observation ),
			Output Table( "Split" )
			);

Copy and paste the code above into a new script window ('File > New > New Script'), then do 'Edit > Run Script'.