topic Re: Exporting, Summarizing, Consolidating for External Reports in Discussions

Exporting, Summarizing, Consolidating for External Reports

BigMoney8 — Thu, 08 Jun 2023 16:27:52 GMT

I've just started using JMP, and I'm struggling with how to export the information I'm getting efficiently for external documents I need to create in MS Word.

I understand how to export results (File>Export), where I'm struggling is figuring out if there are ways to consolidate results, to avoid copy/paste or creating tables and things outside of JMP just to make it "look pretty".

For example, I ran a distribution check of several data columns. Is there a way to get all the histograms together in one area so I can make that a single picture/figure in my final document?

Another example, as part of the distribution analysis, I ran Shapiro-Wilk tests, is there a way to export all of the results to a single table so that I can use that for my external document?

Re: Exporting, Summarizing, Consolidating for External Reports

StarfruitBob — Thu, 16 Mar 2023 21:17:43 GMT

@BigMoney8 Welcome to the JMP community!

Is this what you're looking for? The script below adds 3 table scripts to Big Class.jmp, so scroll down to the bottom of the table scripts list to see them and interact with them. The first two are each separate distribution reports. The last one creates a new window with both reports in them. This script doesn't save anything though, so I encourage you to browse through the Scripting Index and see what syntax of Save, or other function, is correct for your needs.

Names default to here(1);

dt = open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Script( "Distribution 1",
	
	Distribution(
	Nominal Distribution( Column( :age ) ),
	Nominal Distribution( Column( :sex ) )
	)
	
);

dt << New Script( "Distribution 2",
	
	Distribution(
	Nominal Distribution( Column( :age ) ),
	Nominal Distribution( Column( :height ) ),
	Nominal Distribution( Column( :weight ) )
	)
	
);

// Makes a table script - run to see both distribution reports in one window!
dt << New Script( "One window",
	
	New Window( "Combined reports",
		
		V list box( // Distribution 1 report
			
			Distribution(
			Nominal Distribution( Column( :age ) ),
			Nominal Distribution( Column( :sex ) )
			)			
		),
		
		V list box(  // Distribution 2 report
			
			Distribution(
			Nominal Distribution( Column( :age ) ),
			Nominal Distribution( Column( :height ) ),
			Nominal Distribution( Column( :weight ) )
			)			
		),
		
	)	
);

Re: Exporting, Summarizing, Consolidating for External Reports

statman — Fri, 17 Mar 2023 14:29:18 GMT

Welcome to the community. I do not have a great answer for you, sorry. What I typically do is to journal outputs (graphs, tables, etc.) as they are created. I do this for for all of the analysis for each data table. Open journal once and each time you journal (Ctrl>J), the subsequent output is appended to the bottom of the open journal. There are some changes you can make after the outputs are in the journal,. Then I output the journal to Word and make additional modifications.