Welcome to the JMP User Community!

Latest Discussions

• Simple method to copy multiple column properties to a new data table?

  I need to copy the column properties for 82 columns to a new data table which has the same number of columns and same column names.  I seem to remember in the past that there was a quick and simple method, using a few mouse clicks and GUI interface (non-scripting method) to do this.  I don't see these options anymore in any of the menus or sub-menus.  Am I making this up, did this capability never...

  notoriousapp

  Discussions |

  Jun 11, 2021 8:29 AM

  17633 views | 10 replies

• Quantiles with missing values

  If I have a column named X with 100 values which is a sequence from {1-100}, and I want to retrieve the 10 smallest values, I know I can use the command below:dt = current data table(); temp1 = dt:X << get values; temp2 = quantile(0.1,temp1); dt << get rows where(:X<temp2);Let's say I'm replacing the 10 largest values (i.e. 91-100) with missing values, is there a way to get the same 10 smallest va...

  Djtjhin

  Discussions |

  Jun 11, 2021 7:45 AM

  1854 views | 3 replies

• How can I use recode to prepend a character string to each value?

  The situation is that I have a column of sequential values "A", "B", "C", ...  and I want to transform them to "Label A", "Label B", "Label C", ...I know how to do this with a column formula or with JSL, but I was wondering if this is possible with Recode?  Perhaps with using a regular expression?  Any ideas on how to do this with Recode? 

  MathStatChem

  Discussions |

  Jun 11, 2021 1:00 AM

  7106 views | 5 replies

• Name Unresolved. Works when I re-do script but not in original script??

  So I have a script that is creating YbyX plots, doing a Tukey T-Test, then creating a combined dt with the p-Values, then selecting and excluding based on the p-Value. I currently have it embedded inside a dt << New Script() function to save it to the source data table. I'm not sure what is going on but when I get to the section to select the p-Values, I get this error:dt1 << select where("p-Value...

  aliegner1

  Discussions |

  Jun 10, 2021 2:50 PM

  2125 views | 1 replies

• Generating Box Plot with Overlayed Histogram?

  Is there a way to generate a box plot with the histogram of the data overlayed on top of the box? Similar to the attached picture from Spotfire. I used Spotfire at my previous company. Now we are using JMP. I'm trying to create some plots that look similar to better understand the data. Thanks.  

  MattBraunstein

  Discussions |

  Jun 10, 2021 9:55 AM

  6092 views | 3 replies