How to create a loop and add column in subset tables and add value based on specific column value?

UserID16644

Hi all, I have a table subset

I have two questions.

1. How can create a loop that adds column "Ref" to every subset table? 

2. Also, is it possible that the value of the created column will be based on the highest number of N Rows with a specific value?

 

For example, the new column to be added will be Ref. Column Ref's value will be based on Column Country, wherein it should add 1 to the highest N Rows Value of America only.

Country	N Rows	Ref
Argentina	4
America	0
America	5	1
Brazil	2
Brazil	4
Canada	2

 

TIA

txnelson

Here is an example of one way to do the looping.  The real issue is how to get the list of tables to loop across.  This example assumes that 

     Tables=>Subset

with a Subset By was used

names default to here(1);
dt =
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

dtSubsetList = dt << Subset(
	By( :sex ),
	All rows,
	Selected columns only( 0 ),
	columns( :name, :age, :height, :weight )
);

for each( {table}, dtSubsetList,
	table << new column( "Ref");
	wait(0);
	table:ref[table << get rows where( :age == col max(:age))]=1;
);