Subscribe Bookmark RSS Feed

Using Column Lists

robot

Community Trekker

Joined:

Feb 27, 2012

I would like to grab a list of column names, and then use that list to subset a data table.  An example script is below; I get an error because it seems that JMP does not recognize the list as column names.  What is the correct syntax to use here?  I am using JMP11.  Thanks!

// Example.

Names Default To Here( 1 );

bigClass = Open( "$SAMPLE_DATA/Big Class.jmp" );

names = bigClass << Get Column Names( Numeric );

sub = bigClass << Subset( Columns( names ) );

1 REPLY
robot

Community Trekker

Joined:

Feb 27, 2012

Never mind.  Got it.

// Example.

Names Default To Here( 1 );

bigClass = Open( "$SAMPLE_DATA/Big Class.jmp" );

names = bigClass << Get Column Names( Numeric );

sub = bigClass << Subset( Columns( Eval( names ) ) );