How to sum scores across multiple columns with condition?I have a data set that includes 1600 subjects and more than 100 variables/questions. I need to calculate the total score across the 33 question items (Q1 thru Q33) ranging from 0 to 4 for each subject where the score of each question >= 2 excluding 0 and 1. Any help/suggestions/directions are greatly appreciated.
Thank you
Hella
PS. I am using JMP Pro 16.2
AnalyticsData TableScriptingRe: How to sum scores across multiple columns with condition?Jim,
Thank you. Worked like a charm!
Helal
Re: How to sum scores across multiple columns with condition?Here is one way to calculate the values. It is an efficient way to calculate the final score.
Names Default To Here(1);
dt = current data table();
dt<<NEW column=""></NEW>
