Counting how many IDs have a certain variable

bellhasaring2it

I'm fairly new to JMP so apologies if this is a basic question. I am working on a research project where we are trying to determine how exposure to certain metals affects cognition. I am trying to figure out how many people have data for both of our variables of interest, because some participants only have metal exposure data while others only have cognitive data. Is there a way to get a count for how many people have both variables? I'm using JMP 17 for reference. 

txnelson

Here is an example using the Big Class sample data table.

If one wants to find all of the individuals that are Female and have a Height of 61 inches all that has to be done is to select an example and then select all matching records.

Start by selecting the sample.

Row 2 is a Female with the Height of 61. So first click on the Sex cell for row 2.

Next, the Height cell for the same row needs to be selected.  Since just clicking on the cell will clear the already selected Sex cell, one needs to hold the CNTL key down to indicate that the selection is to be added to the selected cells

Finally, move the cursor to the RowState column and right click on row 2 and select, Select Matching Cells

All of the rows that are matched will be selected and the total number of selected rows is specified in the Row Panel area of the display