cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
JensRiege
Level IV

Multiple Contingency Tables - How do I get the name of the filter category

I am creating a report based on a very large set of Contingency tables created by using Fit Y by X,  by factor Z.  Example:

A Data Table has three columns X, Y, Z

When I select Analyze, Fit Y by X, By factor Z,  I get all contigency tables, where each table is for each Z factor.  

The only row in each contingency table I want is the row% so I deselected display of the other three rows before selecting Make into a Data Table after right clicking on the red arrow.

After turning off Mosic Plots and Tests, and leaving just the Contingency tables, I want to concatenate all of these tables into a single table with a column that lists the Z factor for each table. Since each Z factor does not appear to be stored with each Contingency Table, how to I capture this Z factor data to be assocated with each contingency table?

4 REPLIES 4
JensRiege
Level IV

Re: Multiple Contingency Tables - How do I get the name of the filter category

This is some of the code I have so far, assuming that there are multiple contingency tables open:

Names Default To Here( 1 );
Clear Log();
// Create a list of all table names:
dtList = {};
For( i = 1, i <= N Table(), i++,
	dt = Data Table( i );
	Insert Into( dtList, dt );
);
Eval( dtList[1] ) << New Column( "added column", set each value( 5 ) );
Show( dtList );

// Trying to create a single table from all of the Open Contingency Tables
For( i = N Table(), i >= 0, i--,
	Concatenate( dtList[i], "Append to first table", "Create source column" )
);
ron_horne
Super User (Alumni)

Re: Multiple Contingency Tables - How do I get the name of the filter category

Hi @JensRiege 

i would attempt using other platforms to produce the final table you are looking for.

the first thing that comes in mind is Analyze >> Tabulate.

image.png

second option: Table >> summary

image.png

i find these much more versatile and controllable.

please let us know if this helps at all.

ron

 

JensRiege
Level IV

Re: Multiple Contingency Tables - How do I get the name of the filter category

Thank you Ron for your suggestion.

I am reviewing the documentation on the Tabulate Platform to see if I can get the same results that the Contingency Analysis provides in the Analyze Fit Y by X platform.

ron_horne
Super User (Alumni)

Re: Multiple Contingency Tables - How do I get the name of the filter category

Hi @JensRiege ,

Try to see the two scripts in the attached data table.

if you need any help from there let us know.

ron