Is it possible for me to operate a function on selected rows without using the FOR loop.
k = dt<< Get Rows Where (pt:Parameter = ot:Parameter);
For (i=1,i<= Nrow(k),i++,
pt:value[k] = pt:value[k]/5; // I want the value of selected rows only to be divided by 5.
Is it possible for me to rewrite the code without using simple JMP function for it ? I dont like using too many for loops.
Thanks in advance!
dt = Open("$SAMPLE_DATA/Big Class.jmp");
k = dt << getRowsWhere(:sex == "M");
h = Column(dt, "height") << getValues;
h[k] = h[k]*0.5;
Column(dt, "height") << setValues(h);
It causes JMP to pause for 3 seconds, and I inserted it so that you could see what's happening (run the code and look at the column called 'sex'). You can remove it of course.
Thanks for replies.
Just that i deal with huge amounts of data and running loops for every action increase the processing time. I hope inbuilt functions/operators will be more optimized than me writing loops.