Counting the number of columns with specific value

Question

Hi,

I have a data table with columns (around 60) representing the different question code and rows respresenting individual student id and their corresponding scores obtained for each questions. Each student was given a different set of booklets with different questions. The scores given for each question is either 0 (no credit) or 1(partial credit) or 2(full credit) and missing values for those question which a student did not get in his/her booklet. I would like to get the count of questions for which the score was not a missing value and > 0 (ie.,1 and 2) in a new column.  Below is my sample data table.

CNTSCHIDCNTSTUIDGENDERL6 - M00GQ01SL2 - M033Q01SL4 - M034Q01SL3 - M155Q02CL5 - M155Q03C7020000170205783Male010107020000170205411Female10.117020000170205421Male1.0217020000170201886Female1020.7020000170206437Female11221

Thanks in advance.

txnelson · Accepted Answer

To do this interactively I would do the following:

1.  Go to

Tables==>Stack

2. Select all of the response columns as columns to be stacked.

3. Click on OK

4. In the newly created data table, go to the column named "Data" and find a cell with a "0" value.

5. Click on that cell to select it.

6. You indicated that you did not want to have any zero values counted, so now right click on the selected cell, and select "Select Matching Cells".

7. Go to the pull down menu "Rows", click on it and select "Delete Rows"

( You could repeat the same steps for the rows that have missing values, but since missing values are egnored by JMP platforms, it isn't necessary.)

8. Now to count the values, go to

Tables==>Summary

9. Select the column named "Data" for the statistic column, selecting "N" as the statistic to be calculated.

10. Select the column named "CNTSTUID" and place it in the Group selection box.

11. Click on "OK"

The new data table will give you a count for each student for the number of questions with responses greater than zero.