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-42611%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E7%B7%A8%E5%AF%AB%E5%B0%8E%E5%87%BA%E8%A1%A8%E7%9A%84%E8%85%B3%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42611%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%EF%BC%8C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%88%91%E6%83%B3%E7%9F%A5%E9%81%93%E5%A6%82%E4%BD%95%E7%B7%A8%E5%AF%AB%E8%85%B3%E6%9C%AC%E4%BE%86%E8%87%AA%E5%8B%95%E5%B0%8E%E5%87%BA%E8%BC%B8%E5%87%BA%E6%96%87%E4%BB%B6%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E8%A1%A8%EF%BC%9F%20%E6%88%91%E9%9C%80%E8%A6%81%E8%A8%88%E7%AE%97%E5%A4%A7%E9%87%8F%E6%95%B8%E6%93%9A%E7%9A%84%E7%BD%AE%E4%BF%A1%E5%8D%80%E9%96%93%EF%BC%8C%E4%B8%A6%E5%B8%8C%E6%9C%9B%20JMP%20%E8%87%AA%E5%8B%95%E5%B0%87%E9%80%99%E4%BA%9B%E7%BD%AE%E4%BF%A1%E5%8D%80%E9%96%93%E8%A4%87%E8%A3%BD%E5%88%B0%20.txt%20%E6%88%96%20.csv%20%E6%96%87%E4%BB%B6%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42648%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E7%B7%A8%E5%AF%AB%E5%B0%8E%E5%87%BA%E8%A1%A8%E7%9A%84%E8%85%B3%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42648%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20%E4%B8%AD%E7%9A%84%E4%BB%BB%E4%BD%95%E9%A1%AF%E7%A4%BA%E8%A1%A8%E9%83%BD%E5%8F%AF%E4%BB%A5%E8%BD%89%E6%8F%9B%E7%82%BA%E6%95%B8%E6%93%9A%E8%A1%A8%E3%80%82%20%E4%BB%A5%E4%BA%A4%E4%BA%92%E6%96%B9%E5%BC%8F%EF%BC%8C%E6%82%A8%E5%9C%A8%E8%A1%A8%E4%B8%8A%E5%96%AE%E6%93%8A%E9%BC%A0%E6%A8%99%E5%8F%B3%E9%8D%B5%E4%B8%A6%E9%81%B8%E6%93%87%E2%80%9C%E8%A3%BD%E4%BD%9C%E6%88%90%E6%95%B8%E6%93%9A%E8%A1%A8%E2%80%9D%E6%88%96%E2%80%9C%E8%A3%BD%E4%BD%9C%E6%88%90%E7%B5%84%E5%90%88%E6%95%B8%E6%93%9A%E8%A1%A8%E2%80%9D%E3%80%82%3C%2FP%3E%0A%3CP%3E%E8%A6%81%E5%9C%A8%E8%85%B3%E6%9C%AC%E4%B8%AD%E5%9F%B7%E8%A1%8C%E6%AD%A4%E6%93%8D%E4%BD%9C%EF%BC%8C%E8%AB%8B%E5%B0%87%E2%80%9C%E8%A3%BD%E4%BD%9C%E6%88%90%E6%95%B8%E6%93%9A%E8%A1%A8%E2%80%9D%E7%9A%84%E6%B6%88%E6%81%AF%E5%82%B3%E9%81%9E%E7%B5%A6%E5%B0%8D%E8%B1%A1%E3%80%82%3C%2FP%3E%0A%3CP%3E%E9%80%99%E6%98%AF%E8%85%B3%E6%9C%AC%E7%B4%A2%E5%BC%95%E4%B8%AD%E7%9A%84%E7%A4%BA%E4%BE%8B%3C%2FP%3E%0A%3CP%3E%E5%B9%AB%E5%8A%A9%3D%3D%26gt%3B%E8%85%B3%E6%9C%AC%E7%B4%A2%E5%BC%95%3D%3D%26gt%3B%E8%A3%BD%E4%BD%9C%E6%88%90%E6%95%B8%E6%93%9A%E8%A1%A8%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0AOpen(%20%22%24SAMPLE_DATA%2FBaltic.jmp%22%20)%3B%0Ap%20%3D%20PLS(%0A%20Y(%20%3Als%2C%20%3Aha%2C%20%3Adt%20)%2C%0A%20X(%0A%20%20%3Av1%2C%0A%20%20%3Av2%2C%0A%20%20%3Av3%2C%0A%20%20%3Av4%2C%0A%20%20%3Av5%2C%0A%20%20%3Av6%2C%0A%20%20%3Av7%2C%0A%20%20%3Av8%2C%0A%20%20%3Av9%2C%0A%20%20%3Av10%2C%0A%20%20%3Av11%2C%0A%20%20%3Av12%0A%20)%0A)%3B%0Apr%20%3D%20p%20%26lt%3B%26lt%3B%20report%3B%0Apr%5BOutline%20Box(%202%20)%5D%20%26lt%3B%26lt%3B%20Close%3B%0Apr%5BOutline%20Box(%203%20)%5D%20%26lt%3B%26lt%3B%20Close%3B%0Atb%20%3D%20pr%5BTable%20Box(%201%20)%5D%3B%0Atb%20%26lt%3B%26lt%3B%20Make%20Into%20Data%20Table%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42647%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E7%B7%A8%E5%AF%AB%E5%B0%8E%E5%87%BA%E8%A1%A8%E7%9A%84%E8%85%B3%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42647%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%AC%9D%E8%AC%9D%EF%BC%8C%E4%BD%86%E6%88%91%E9%9C%80%E8%A6%81%E4%B8%80%E5%80%8B%E8%85%B3%E6%9C%AC%E4%BE%86%E5%B0%8E%E5%87%BA%3CEM%3E%E8%BC%B8%E5%87%BA%3C%2FEM%3E%E8%A1%A8%EF%BC%8C%E8%80%8C%E4%B8%8D%E6%98%AF%E6%95%B8%E6%93%9A%E8%A1%A8%E3%80%82%20%E5%9B%A0%E6%AD%A4%EF%BC%8C%E4%BE%8B%E5%A6%82%EF%BC%8CJMP%20%E5%B0%87%E4%BF%9D%E5%AD%98%E8%85%B3%E6%9C%AC%E4%BB%A5%E5%9C%A8%E7%95%B6%E5%89%8D%E7%8B%80%E6%85%8B%E4%B8%8B%E9%87%8D%E7%8F%BE%E5%88%86%E6%9E%90%EF%BC%9B%E6%88%91%E9%9C%80%E8%A6%81%E5%B0%87%E9%80%99%E4%BA%9B%E5%88%86%E6%9E%90%E7%9A%84%E7%B5%90%E6%9E%9C%E5%B0%8E%E5%87%BA%E5%88%B0%20.csv%20%E6%96%87%E4%BB%B6%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42623%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E7%B7%A8%E5%AF%AB%E5%B0%8E%E5%87%BA%E8%A1%A8%E7%9A%84%E8%85%B3%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42623%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%B8%8B%E9%9D%A2%E6%98%AF%E7%9B%B4%E6%8E%A5%E5%BE%9E%E8%85%B3%E6%9C%AC%E7%B4%A2%E5%BC%95%E4%B8%AD%E7%8D%B2%E5%8F%96%E7%9A%84%E9%97%9C%E6%96%BC%E5%A6%82%E4%BD%95%E5%B0%87%E6%95%B8%E6%93%9A%E8%A1%A8%E4%BF%9D%E5%AD%98%E7%82%BA%E8%BC%B8%E5%87%BA%E6%A0%BC%E5%BC%8F%E7%9A%84%E7%A4%BA%E4%BE%8B%EF%BC%9A%3C%2FP%3E%0A%3CP%3E%E5%B9%AB%E5%8A%A9%3D%3D.%E8%85%B3%E6%9C%AC%E7%B4%A2%E5%BC%95%3D%3D%26gt%3B%E6%95%B8%E6%93%9A%E8%A1%A8%3D%3D%26gt%3B%E5%8F%A6%E5%AD%98%E7%82%BA%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0Adt%20%26lt%3B%26lt%3B%20Save(%20%22%24temp%5Cdeleteme%20Big%20Class.jmp%22%20)%3B%20%2F%2F%20explicit%20location%0AIf(%20dt%20%26lt%3B%26lt%3B%20Save(%20%22%22%20)%2C%0A%20Write(%20%22%5C!nsaved%20to%20%22%20%7C%7C%20(dt%20%26lt%3B%26lt%3B%20GetPath)%20)%2C%0A%20Write(%20%22%5C!nsave%20canceled%22%20)%0A)%3B%20%2F%2F%20prompt%0Adt%20%26lt%3B%26lt%3B%20Save(%20%22%24temp%5Cdeleteme%20Big%20Class.csv%22%20)%3B%20%2F%2F%20convert%20to%20CSV%20format%0AClose(%20dt%2C%20%22NoSave%22%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
rmay
Level I

writing script to export tables

Hi,

 

I was wondering how to write a script to automate exportation of specific tables in an output file? I need to calculate confidence intervals for a large set of data, and would like JMP to automatically copy those confidence intervals to either a .txt or .csv file. 

3 REPLIES 3
txnelson
Super User

Re: writing script to export tables

Here is an example taken directly from the Scripting Index on how to save a data table to an output format:

     Help==.Scripting Index==>Data Table==>Save As

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Save( "$temp\deleteme Big Class.jmp" ); // explicit location
If( dt << Save( "" ),
	Write( "\!nsaved to " || (dt << GetPath) ),
	Write( "\!nsave canceled" )
); // prompt
dt << Save( "$temp\deleteme Big Class.csv" ); // convert to CSV format
Close( dt, "NoSave" );
Jim
rmay
Level I

Re: writing script to export tables

Thanks, but I need a script to export output tables, not a data table. So for example, JMP will save scripts to reproduce analyses in the current state; I need to export the results of those analyses to a .csv file. 

txnelson
Super User

Re: writing script to export tables

Any display table in JMP can be turned into a data table.  Interactively, you right mouse click on the table and select "Make into Data Table" or "Make into Combined Data Table".

To do this in a script, you pass a message of "Make into Data Table" to the object.

Here is the example from the Scripting Index

     Help==>Scripting Index==>Make Into Data Table

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Baltic.jmp" );
p = PLS(
	Y( :ls, :ha, :dt ),
	X(
		:v1,
		:v2,
		:v3,
		:v4,
		:v5,
		:v6,
		:v7,
		:v8,
		:v9,
		:v10,
		:v11,
		:v12
	)
);
pr = p << report;
pr[Outline Box( 2 )] << Close;
pr[Outline Box( 3 )] << Close;
tb = pr[Table Box( 1 )];
tb << Make Into Data Table;
Jim

Recommended Articles