cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
%3CLINGO-SUB%20id%3D%22lingo-sub-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ECopy%20pasting%20means%20and%20std%20deviation%20table%20from%20a%20Oneway%20analysis.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHello%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20time%20posting%20here%20so%20I%20apologize%20if%20I%20miss%20anything.%20I%20wrote%20script%20which%20essentially%20creates%20a%20oneway%20analysis%20for%20user%20imported%20data.%20I%20was%20wondering%20if%20it%20was%20possible%20to%20extract%20(copy%20paste)%20the%20%22Means%20and%20Std%20Deviations%22%20table%20to%20a%20different%20table%20in%20JSL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60127i4B2D68594D2AE9DA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22OhThatArabGuy_1-1703880407651.png%22%20alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAutomation%20and%20Scripting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBasic%20Data%20Analysis%20and%20Modeling%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Copy%20pasting%20means%20and%20std%20deviation%20table%20from%20a%20Oneway%20analysis.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHere%20is%20an%20example%20that%20shows%20how%20to%20take%20the%20complete%20Means%20and%20Std%20table%20and%20create%20a%20new%20data%20table%20from%20it%20and%20also%20and%20example%20of%20how%20to%20take%20a%20specific%20column%20of%20the%20stat%20table%20and%20add%20it%20to%20the%20current%20data%20table.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0Adt%3Dopen(%22%24SAMPLE_DATA%2Fbig%20class.jmp%22)%3B%0A%0AOneway(%0A%20Y(%20%3Aheight%20)%2C%0A%20X(%20%3Asex%20)%2C%0A%20Quantiles(%201%20)%2C%0A%20Means%20and%20Std%20Dev(%201%20)%2C%0A%20t%20Test(%201%20)%2C%0A%20Box%20Plots(%201%20)%2C%0A%20Mean%20Error%20Bars(%201%20)%2C%0A%20Std%20Dev%20Lines(%201%20)%0A)%3B%0A%0AtheReport%20%3D%20current%20report()%3B%0A%0A%2F%2F%20Create%20it%20own%20new%20table%0AtheReport%5B%22Means%20and%20Std%20Deviations%22%2C%20TableBox(1)%5D%20%26lt%3B%26lt%3B%20make%20into%20data%20table%3B%0A%0A%2F%2F%20and%2For%20add%20the%20data%20to%20the%20current%20data%20table%0Adt%20%26lt%3B%26lt%3B%20new%20column(%20%22Mean%22%20)%3B%0AtheMeans%20%3D%20theReport%5B%22Means%20and%20Std%20Deviations%22%2C%20NumberColBox(2)%5D%20%26lt%3B%26lt%3B%20get%3B%0Adt%3AMean%20%26lt%3B%26lt%3B%20set%20values(%20theMeans%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Copy pasting means and std deviation table from a Oneway analysis.

Hello all!

 

First time posting here so I apologize if I miss anything. I wrote script which essentially creates a oneway analysis for user imported data. I was wondering if it was possible to extract (copy paste) the "Means and Std Deviations" table to a different table in JSL.

 

Ex:

OhThatArabGuy_1-1703880407651.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Copy pasting means and std deviation table from a Oneway analysis.

Here is an example that shows how to take the complete Means and Std table and create a new data table from it and also and example of how to take a specific column of the stat table and add it to the current data table.

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

Oneway(
	Y( :height ),
	X( :sex ),
	Quantiles( 1 ),
	Means and Std Dev( 1 ),
	t Test( 1 ),
	Box Plots( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 )
);

theReport = current report();

// Create it own new table
theReport["Means and Std Deviations", TableBox(1)] << make into data table;

// and/or add the data to the current data table
dt << new column( "Mean" );
theMeans = theReport["Means and Std Deviations", NumberColBox(2)] << get;
dt:Mean << set values( theMeans );
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Copy pasting means and std deviation table from a Oneway analysis.

Here is an example that shows how to take the complete Means and Std table and create a new data table from it and also and example of how to take a specific column of the stat table and add it to the current data table.

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

Oneway(
	Y( :height ),
	X( :sex ),
	Quantiles( 1 ),
	Means and Std Dev( 1 ),
	t Test( 1 ),
	Box Plots( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 )
);

theReport = current report();

// Create it own new table
theReport["Means and Std Deviations", TableBox(1)] << make into data table;

// and/or add the data to the current data table
dt << new column( "Mean" );
theMeans = theReport["Means and Std Deviations", NumberColBox(2)] << get;
dt:Mean << set values( theMeans );
Jim