cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
SPradh
Level I

Sampling data every n points

Hi everyone,

 

I am trying to sample data every 50 rows and check if values in a column, F, gives F(50)-F(1)>1. I don't want to use the lag function as it should only sample at row 1, 50, 100, 150 and so on.

 

Thanks in advance!

 

 

 

1 REPLY 1
txnelson
Super User

Re: Sampling data every n points

Use the mod(), "modulus" function:

names default to here(1);
dt= current data table();
dt<<select where(mod(row(),50)==0);
dt << subset(selected rows(1),selected columns(0));

     Help==>Scripting Index==>Functions==>Mod 

Jim