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%3E%E4%BB%8E%E5%8D%95%E5%90%91%E5%88%86%E6%9E%90%E4%B8%AD%E5%A4%8D%E5%88%B6%E7%B2%98%E8%B4%B4%E5%B9%B3%E5%9D%87%E5%80%BC%E5%92%8C%E6%A0%87%E5%87%86%E5%81%8F%E5%B7%AE%E8%A1%A8%E3%80%82%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%A4%A7%E5%AE%B6%E5%A5%BD%EF%BC%81%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E7%AC%AC%E4%B8%80%E6%AC%A1%E5%9C%A8%E8%BF%99%E9%87%8C%E5%8F%91%E5%B8%96%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%9C%89%E4%BB%80%E4%B9%88%E9%81%97%E6%BC%8F%E7%9A%84%E8%AF%9D%EF%BC%8C%E6%88%91%E6%B7%B1%E8%A1%A8%E6%AD%89%E6%84%8F%E3%80%82%20%E6%88%91%E7%BC%96%E5%86%99%E7%9A%84%E8%84%9A%E6%9C%AC%E6%9C%AC%E8%B4%A8%E4%B8%8A%E6%98%AF%E4%B8%BA%E7%94%A8%E6%88%B7%E5%AF%BC%E5%85%A5%E7%9A%84%E6%95%B0%E6%8D%AE%E5%88%9B%E5%BB%BA%E5%8D%95%E5%90%91%E5%88%86%E6%9E%90%E3%80%82%20%E6%88%91%E6%83%B3%E7%9F%A5%E9%81%93%E6%98%AF%E5%90%A6%E5%8F%AF%E4%BB%A5%E5%B0%86%E2%80%9C%E5%B9%B3%E5%9D%87%E5%80%BC%E5%92%8C%E6%A0%87%E5%87%86%E5%81%8F%E5%B7%AE%E2%80%9D%E8%A1%A8%E6%8F%90%E5%8F%96%EF%BC%88%E5%A4%8D%E5%88%B6%E7%B2%98%E8%B4%B4%EF%BC%89%E5%88%B0%20JSL%20%E4%B8%AD%E7%9A%84%E5%8F%A6%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%AD%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E5%89%8D%E4%BB%BB%EF%BC%9A%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%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%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%3E%E8%87%AA%E5%8A%A8%E5%8C%96%E5%92%8C%E8%84%9A%E6%9C%AC%E7%BC%96%E5%86%99%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E5%9F%BA%E7%A1%80%E6%95%B0%E6%8D%AE%E5%88%86%E6%9E%90%E5%92%8C%E5%BB%BA%E6%A8%A1%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E8%A7%86%E7%AA%97%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%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E4%BB%8E%E5%8D%95%E5%90%91%E5%88%86%E6%9E%90%E4%B8%AD%E5%A4%8D%E5%88%B6%E7%B2%98%E8%B4%B4%E5%B9%B3%E5%9D%87%E5%80%BC%E5%92%8C%E6%A0%87%E5%87%86%E5%81%8F%E5%B7%AE%E8%A1%A8%E3%80%82%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BB%A5%E4%B8%8B%E7%A4%BA%E4%BE%8B%E5%B1%95%E7%A4%BA%E4%BA%86%E5%A6%82%E4%BD%95%E8%8E%B7%E5%8F%96%E5%AE%8C%E6%95%B4%E7%9A%84%20Means%20%E5%92%8C%20Std%20%E8%A1%A8%E5%B9%B6%E4%BB%8E%E4%B8%AD%E5%88%9B%E5%BB%BA%E6%96%B0%E7%9A%84%E6%95%B0%E6%8D%AE%E8%A1%A8%EF%BC%8C%E4%BB%A5%E5%8F%8A%E5%A6%82%E4%BD%95%E8%8E%B7%E5%8F%96%20stat%20%E8%A1%A8%E7%9A%84%E7%89%B9%E5%AE%9A%E5%88%97%E5%B9%B6%E5%B0%86%E5%85%B6%E6%B7%BB%E5%8A%A0%E5%88%B0%E5%BD%93%E5%89%8D%E6%95%B0%E6%8D%AE%E8%A1%A8%E7%9A%84%E7%A4%BA%E4%BE%8B%E3%80%82%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