cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
LipYeong
Level II

How to combined data table from multiple bivariate plot fit model using JSL

I've a multiple bivariate plot and would like to make all group fit model summary into data table. 

Script is working when it's pointing to one group but not working when point to multiple group

Appreciate if anyone could help on this. Thanks

 

Script able to output data table for one group

Names Default To Here( 1 );
dt = Data Table( "ReportSummary" );

biv = dt << Bivariate(
	Y( :Reference_A  ),
	X( :Reference_B ),
	Fit Line( {Line Color( {212, 73, 88} )} ),
	Fit Special(
		Intercept( 0 ),
		Slope( 1 ),
		Centered Polynomial( 0 ),
		{Line Color( {61, 174, 70} )}
	),
    	Where( :Label == "FrequencyA" )
);
reportbiv = biv << Report;
dt = reportbiv["Summary of Fit"][1] << make combined data table;

No output data table while pointing to multiple group

Names Default To Here( 1 );
dt = Data Table( "ReportSummary" );

biv = dt << Bivariate(
	Y( :Reference_A  ),
	X( :Reference_B ),
	Fit Line( {Line Color( {212, 73, 88} )} ),
	Fit Special(
		Intercept( 0 ),
		Slope( 1 ),
		Centered Polynomial( 0 ),
		{Line Color( {61, 174, 70} )}
	),
   	By( :Label ) /*Contained multiple group*/
);
reportbiv = biv << Report;
dt = reportbiv["Summary of Fit"][1] << make combined data table;
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to combined data table from multiple bivariate plot fit model using JSL

The Bivariate report produces a separate output object for each level of the By group.  Therefore, the reference to each level of the report structure is required.  If you change your JSL to the below, it will point to the 1st of the multi level report structures and  generate the output data table

reportbiv = biv[1] << Report;
dt = reportbiv["Summary of Fit"][1] << make combined data table;
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: How to combined data table from multiple bivariate plot fit model using JSL

The Bivariate report produces a separate output object for each level of the By group.  Therefore, the reference to each level of the report structure is required.  If you change your JSL to the below, it will point to the 1st of the multi level report structures and  generate the output data table

reportbiv = biv[1] << Report;
dt = reportbiv["Summary of Fit"][1] << make combined data table;
Jim

Recommended Articles