topic Operating on selected rows in Discussions

Operating on selected rows

akash_nigam_gma — Wed, 06 Jan 2016 06:57:34 GMT

Hello Everyone,

Is it possible for me to operate a function on selected rows without using the FOR loop.

For example

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!

regards,

Akash

Re: Operating on selected rows

ian_jmp — Wed, 06 Jan 2016 08:48:57 GMT

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

Wait(3);

k = dt << getRowsWhere(:sex == "M");

h = Column(dt, "height") << getValues;

h[k] = h[k]*0.5;

Column(dt, "height") << setValues(h);

Re: Operating on selected rows

ms — Wed, 06 Jan 2016 10:15:36 GMT

Or try the "Divide To" assignment:

dt:height[k] /= 5

Re: Operating on selected rows

David_Burnham — Thu, 07 Jan 2016 16:50:01 GMT

Just curious, why don't you like using loops?

Re: Operating on selected rows

akash_nigam_gma — Sun, 10 Jan 2016 16:15:53 GMT

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.

Re: Operating on selected rows

anders_bankefor — Mon, 11 Jan 2016 13:39:18 GMT

Hi Ian,

what does "Wait(3);" do in this context?

Anders

Re: Operating on selected rows

ian_jmp — Mon, 11 Jan 2016 13:49:25 GMT

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.