topic Re: Script auto run all selected subset in Discussions

Script auto run all selected subset

tikhahabusamah — Sat, 10 Jun 2023 23:18:02 GMT

Hi,

is there any possibility to run all subset column by name which consist of more than 50 name automatically at the same time?

when I did subset by name, i get all those detail data I want, but I need to click one by one to run fit y by x analysis. is there is a way for me to select all and automatically run fit y by x analysis? all of this subset name might changes everytime.

Re: Script auto run all selected subset

txnelson — Tue, 18 Aug 2020 18:21:49 GMT

Here is a little script that shows and example of one way to do what you want

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

// Get the current number of data tables
numDT = N Table();

// Perform the subsets
dt << Subset(
	By( :age ),
	All rows,
	Selected columns only( 0 ),
	columns( :name, :sex, :height, :weight )
);

// Loop across all new data tables and run Fit Y by X
For( i = 1, i <= N Table() - numDT, i++,
	Data Table( i ) << Bivariate( Y( :height ), X( :weight ) )
);

Re: Script auto run all selected subset

tikhahabusamah — Wed, 19 Aug 2020 12:23:20 GMT

I try to did split by name after subset, which is before run table fit Y by X, but everytime I try to run JMP become not responding anymore. why?

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

// Get the current number of data tables
numDT = N Table();

// Perform the subsets
dt << Subset( By( :age ), All rows, Selected columns only( 0 ), columns( :name, :sex, :height, :weight ) );

// Loop across all new data tables and run Fit Y by X
For( i = 1, i <= N Table() - numDT, i++,
    Data Table( i ) << Split( Split By( :name ), Split( :sex, :height, :weight ) )
);

Re: Script auto run all selected subset

txnelson — Tue, 18 Aug 2020 21:58:02 GMT

The issue is the stopping value for your For() loop. You are specifying

For( i = 1, i <= N Table() - numDT, i++,

and then in your code you are creating a new data table, so the next time the loop happens, the value of

N Table()

has increased by an additional count, so the variable 'i' can never get to the current value of N Table()

Re: Script auto run all selected subset

ts2 — Wed, 19 Aug 2020 04:23:47 GMT

FYI when subsetting you can assign your subset tables as a list rather than using N Table() which could be problematic if you have a bunch of other tables open (typically including the original table subset from).

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

// Perform the subsets
listDT = dt << Subset(
	By( :age ),
	All rows,
	Selected columns only( 0 ),
	columns( :name, :sex, :height, :weight )
);

// Loop across all new data tables and run Fit Y by X
For( i = 1, i <= N Items( listDT ), i++,
	listDT[i] << Bivariate( Y( :height ), X( :weight ) )
);

Re: Script auto run all selected subset

txnelson — Wed, 19 Aug 2020 07:00:58 GMT

@tikhahabusamah

Remove my solution ( @txnelson ) and select @ts2 as the solution. It is a better solution!