413441_en-US

liliconcom

How to write a script for selecting several columns (>1000) in a data table as input for an Analysis (e.g. inverse correlations)

Hi I am new to JSL and would like to make a script for selecting multiple columns (>1000) and to use them an input for analysis. For example using the Mulitvariate analysis tool and calculating the inverse correlation.
I have made a script for selecting two columns for Bivariate analysis but how to extend it for multiple columns as used in e.g Mulitvariate analysis. 

 

I have tried to find clues at this forum but I do something wrong and I am stuck. I would be very greatful if someone could help me with this. 

 

Best Regards /Anders 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
xvar = .;
yvar = .;
win = New Window( "Example of Returning Values",
 <<MODAL></MODAL>

AnalyticsData TableScriptingRe: How to write a script for selecting several columns (>1000) in a data table as input for an Analysis (e.g. inverse correlations)

Thanks, that's a very simple way! 

Re: How to write a script for selecting several columns (>1000) in a data table as input for an Analysis (e.g. inverse correlations)

Thanks Jarmo.

A good suggestion for lower level of customization and simpler use. /Anders 

Re: How to write a script for selecting several columns (>1000) in a data table as input for an Analysis (e.g. inverse correlations)

I like this a lot!

Re: How to write a script for selecting several columns (>1000) in a data table as input for an Analysis (e.g. inverse correlations)

You could also take a look at Column Dialog instead of building modal new window. Depending on the level of customization you need, it might be simpler to use.

 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Solubility.jmp");
colDiag = Column Dialog(y = ColList("Y", Data Type("Numeric")));
dt << Multivariate(Y(colDiag["y"]));

Re: How to write a script for selecting several columns (>1000) in a data table as input for an Analysis (e.g. inverse correlations)

You were headed in the right direction.  Your original script limited the Yvar to only 1 variable, and so by removing that restriction it lets one choose multiple variables, which then are transferred as a list to the Multivariate input.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
xvar = .;
yvar = .;
win = New Window( "Example of Returning Values",
 <<MODAL></MODAL>