Welcome to the JMP User Community!

Latest Discussions

• Stratified Data Split into test and control

  Hello JMP Community,  I am trying to split a dataset into Test and Control for a marketing experiment. The data set is unique at the customer id and has a million rows. Both the new datasets must be balanced using two parameters which are annual customer spend (YTD) and last quarter spend (QTD). These parameters are represented in two columns. I am unable to figure out how to create a stratified/b...

  75Innovation

  Discussions |

  Jul 15, 2019 7:17 AM

  2778 views | 2 replies

• How to filter a dataset using a separate dataset with 1000s of IDs (subquery, scripting)

  I have a "BIG" dataset containing several million rows. Each row has a specific IDENT field. IDENT may occur multiple times. I have another, smaller dataset "SMALL", that contains just hundreds of 1000s of rows. Each row has also a specific IDENT field.   Now I just want to keep all the rows from BIG, that have the same IDENT in SMALL. In other words: How to filter BIG using the IDENT field from S...

  Newbie2Jumpie

  Discussions |

  Jul 15, 2019 5:10 AM

  4543 views | 4 replies

• Deleting specified rows

  Hey JMP community, I am extremely new to jmp/jsl (literally just started this week). I have a script that is supposed to select where certain values in a row are less than 3, and then delete those rows. This is the script I have to do so:   dt << select where( :Residual 1 <= 3 ); dt << delete rows;   The code correctly selects the rows I want it to, but upon deleting the rows they "update" themsel...

  kcorder

  Discussions |

  Jul 12, 2019 9:42 AM

  3691 views | 2 replies

• Save file to network

  I'm working on a project that will take some data and export a csv file. I got it to save successfully to the local drive but I was wondering if there is a way to have it save to a different network drive, and what I would need to do this. Thanks

  DRemd

  Discussions |

  Jul 12, 2019 9:04 AM

  2559 views | 3 replies

• Custom DOE with Disallowed Combinations Scr

   Hi, I have 5 factors for a custom DOE and I need two linear constraints:Mean(CAP + RAP + OAP + EAP) + 10 < RRP
  Max(CAP, RAP, OAP, EAP) - Min(CAP, RAP, OAP, EAP) < 150It is ok for CAP, RAP, OAP, EAP and RRP to vary significantly between 100 and 500, but if they vary, I want them to be somewhat close together. For example 450,400,350,450,500 is ok, but 100,500,100,500,500 is not. I've tried the belo...

  PS

  Discussions |

  Jul 12, 2019 12:49 AM

  7125 views | 9 replies