How to compare 1,000 sets of paired data at once?

Sakai

When analyzing data with more than 1000 sets of paired data, it could not select more than 1000 times, such as A vs B, C vs D, etc…

How can I summarize them in an Excel table, which I can compare all paired data at once?

txnelson

Below is a simple script that will run for your data.  The script assumes that you have read in the 2 workbooks into JMP, as 2 separate tables.  It then determines the names of the columns in each data table, joins the tables together, and then runs the Matched Pairs platform.  I have attached the 2 JMP tables I used from your Excel workbook. 

Additionally, I created my own sample data table with 3000 matched columns and ran the Matched Pairs platform on all 3000 columns, and it worked without error.

Names Default To Here( 1 );

// Create a pointer to the Pre data table and get
// a list of the columns in it
dt1 = Data Table( "sample data_Sheet1" );
colList1 = dt1 << get column names( continuous );

// Create a pointer to the Post data table and get
// a list of the columns in it
dt2 = Data Table( "sample data_Sheet2" );
colList2 = dt2 << get column names( continuous );

// Join the data tables together
dtJoined = dt1 << Join(
	With( dt2 ),
	By Matching Columns( :ID = :ID ),
	Drop multiples( 0, 0 ),
	Include Nonmatches( 0, 0 ),
	Preserve main table order( 1 )
);

// create a new list in the column order required for the Matched Pairs platform
// which is pre1, post1, pre2, post2, etc.
finalList = {};
For( i = 1, i <= N Items( colList1 ), i++,
	Insert Into( finalList, colList1[i] );
	Insert Into( finalList, colList2[i] );
);

// Run the matched pairs
dtJoined << Matched Pairs(
	Y( Eval( finalList ) ),
	Separate Pairs( 1 ),
	Reference Frame( 1 ),
	Wilcoxon Signed Rank( 1 )
);

 

sample data_Sheet1.jmp

sample data_Sheet2.jmp