nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using a subset to select a larger dataset

SciOfMfg

I've got a large data-set of simulation data that needs to be reduced. Table 1: Description, ID, Data1,Data2,...DataN

I double subset on Description, then on Data1. I now know all the ID numbers I need (there are 35 unique ID's)

How can would one take the 35 unique ID's and subset Table 1 on all the rows that match the 35 unique ID's.

Accepted answers

txnelson

You can use a Contains() function to do what you want. Below is a very simple example. The key will how to create a list with your 35 IDs.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

idList = {"KATIE", "LILLIE", "DAVID"};

dt << select where( Contains( idList, :Name ) );

All comments

txnelson

You can use a Contains() function to do what you want. Below is a very simple example. The key will how to create a list with your 35 IDs.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

idList = {"KATIE", "LILLIE", "DAVID"};

dt << select where( Contains( idList, :Name ) );

SciOfMfg

The list of ID's would come from a column in the Subset of the Subset

txnelson

That makes it easy:

dtsub=data table("subsetofsubset");
idList = dtsub:ID << get values;