cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ECopiez-collez%20les%20moyens%20et%20le%20tableau%20des%20%C3%A9carts%20types%20%C3%A0%20partir%20d'une%20analyse%20Oneway.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EBonjour%20%C3%A0%20tous!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EC'est%20la%20premi%C3%A8re%20fois%20que%20je%20poste%20ici%2C%20donc%20je%20m'excuse%20si%20quelque%20chose%20me%20manque.%20J'ai%20%C3%A9crit%20un%20script%20qui%20cr%C3%A9e%20essentiellement%20une%20analyse%20unidirectionnelle%20pour%20les%20donn%C3%A9es%20import%C3%A9es%20par%20l'utilisateur.%20Je%20me%20demandais%20s'il%20%C3%A9tait%20possible%20d'extraire%20(copier-coller)%20le%20tableau%20%22Moyennes%20et%20%C3%A9carts%20types%22%20dans%20une%20autre%20table%20en%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%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%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%3EAutomatisation%20et%20scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalyse%20et%20mod%C3%A9lisation%20des%20donn%C3%A9es%20de%20base%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eles%20fen%C3%AAtres%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%20%3A%20Copier-coller%20les%20moyennes%20et%20le%20tableau%20des%20%C3%A9carts%20types%20%C3%A0%20partir%20d'une%20analyse%20Oneway.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EVoici%20un%20exemple%20qui%20montre%20comment%20prendre%20la%20table%20compl%C3%A8te%20Means%20and%20Std%20et%20cr%C3%A9er%20une%20nouvelle%20table%20de%20donn%C3%A9es%20%C3%A0%20partir%20de%20celle-ci%2C%20ainsi%20qu'un%20exemple%20de%20la%20fa%C3%A7on%20de%20prendre%20une%20colonne%20sp%C3%A9cifique%20de%20la%20table%20stat%20et%20de%20l'ajouter%20%C3%A0%20la%20table%20de%20donn%C3%A9es%20actuelle.%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

Recommended Articles