cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
gemmahodgson
Level II

How do I save the eigenvalues from PCA into dataset?

Hi

I am using JMP Pro 13 doing PCA and although I can see all the output I need on the screen, I want to be able to extrct the eigenvalues and use them as weights for another anlaysis, so I need them in a dataset, but there doens't appear to be any option to get them out. The only thing I can save is the principal components...does anyone know how you can save the other parts of the output? Either via scripting or interactive is fine.

Thanks in advance

Gemma

7 REPLIES 7

Re: How do I save the eigenvalues from PCA into dataset?

Try right-clicking on the table and choose Make into Data Table.

Dan Obermiller
gemmahodgson
Level II

Re: How do I save the eigenvalues from PCA into dataset?

Thanks for your quick answer Dan, I found that, however I need to do it lots of times (as I have to do 12 PCAs) so I wanted to run it in JSL as a script, where the PCA is done (by consumer) and the eigenvalues exported each time...any ideas on that?


txnelson
Super User

Re: How do I save the eigenvalues from PCA into dataset?

Here is a simple example of a script creating the Eigenvalue data table

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

pc=dt << Principal Components(
	Y( :NPN1, :PNP1, :PNP2, :NPN2, :PNP3 ),
	Estimation Method( "Default" ),
	"on Correlations",
	Eigenvalues( 1 ),
	SendToReport(
		Dispatch(
			{"Summary Plots"},
			"PCA Summary Plots",
			FrameBox,
			{Frame Size( 43, 40 )}
		),
		Dispatch(
			{"Summary Plots"},
			"PCA Summary Plots",
			FrameBox( 2 ),
			{Frame Size( 53, 40 )}
		)
	)
);
report(pc)["Eigenvalues"][1][1]<<make into data table;
Jim
gemmahodgson
Level II

Re: How do I save the eigenvalues from PCA into dataset?

That's great thank you so much - I will try it now! Can't believe all the v quick replies - I was expecting to wait weeks!


julian
Community Manager Community Manager

Re: How do I save the eigenvalues from PCA into dataset?

Hi Gemma,

 

If I'm understanding your question correctly you want to save the table of eigenvalues shown in the JMP PCA report for all the extracted components. If that's right, a simple way to do this is to right-click the table in the report and select "Make into Data Table."

 

I hope this helps!

 

Julian

MakeIntoDataTable.gif

 

 

 

 

julian
Community Manager Community Manager

Re: How do I save the eigenvalues from PCA into dataset?

Oops, I see now that Jim already responded with a great method for handling this across many reports!
louv
Staff (Retired)

Re: How do I save the eigenvalues from PCA into dataset?