Welcome to the JMP User Community!

Latest Discussions

• How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

  Hi, I want to be able, in a scripted formula, to assign a text string to column depending onthe values of another column.For instance:A  B1  Low2  Low3  Low4  Medium5  Medium6  Medium7  High8  High9  High10 HighHow does the formula lok for this?  If(:A<=3,"Low",:A>=3 and :A<7,"Medium",:A>=7,"High") does not work.I Base SAS there is a command, select(); when();when(); ; ; otherwise;end; It is the e...

  poulravn

  Discussions |

  Jul 22, 2013 6:49 AM

  16925 views | 5 replies

• Copy/Paste without Formula Efficiently?

  Could someone tell me the best way to copy/paste an entire column values into a new column efficiently (I have more than a million rows)?The method i'm currently using is to get all values, store them to a list, and then set the values to a column, but I noticed that this is much slower than if you select the column in the table, and click paste on the column.The reason I'm trying to do this is th...

  euge

  Discussions |

  Jul 17, 2013 4:05 PM

  10278 views | 1 replies

• Individual and Moving Range Chart

  I am trying to create an individual and moving range chart by date on the x-axis. I know it is possible given the following article. Control Charts or SPC are easy in JMP 10 with Control Chart BuilderHowever, I am unable to "drop" the dates on the x-axis. Everytime I try, JMP assumes that I am placing it in "subgroup" and converts to an Xbar and R chart. Does anyone know where I need to drop my da...

  chuang

  Discussions |

  Jul 16, 2013 1:32 PM

  7490 views | 9 replies

• How can I automate random row selection?

  Hello All,I'm pretty new to JMP and even newer to JSL. I'm trying to write a script that subsets a number of rows based on the following specifications: if the original table has 1-15 rows, then the subset  of the original table is 2 rows, if the original has 16-25 then the subset of that table is 3 rows, if the orginal has 26-90 then the subset table is 5 rows, etc. Basically just a script to aut...

  danielsh

  Discussions |

  Jul 16, 2013 8:25 AM

  9264 views | 2 replies

• removing duplicate items in a table

  Hi All,i have a table with ~20 columns and about 500 rows, two of these columns are Serial No. and Time stamp, and the rest is miscellaneous measurment data.in some instances i have rows of data that have the same Serial No. but all other values are different.my goal is to write a script to clean up the data table so that only rows with unique Serial No. are left.I want to first select items with ...

  bk

  Discussions |

  Jul 15, 2013 9:39 AM

  12932 views | 3 replies