For example, there are five data files in the "c:\1\" path that look like "Big Class.jmp" structures.
How to classify and summarize the data of "height" column by "age" column for 5 files in memory without "Concatenate".
Achieve the effect as if implemented in the following code:
dir = "c:\1\";
Fs = Files In Directory( dir );
For( d = 1, d <= 5, d++,
d1 = Open( dir || fs[d] );
If( d == 1,
d2 = d1,
d2 << Concatenate( Data Table( d1 ), Append to first table );
Close( d1, nosave );
);
);
d1 = d2<< Summary(
Group( :age ),
Sum( :height ),
Freq( "None" ),
Weight( "None" ),
Link to original data table( 0 )
);