Welcome to the JMP User Community!

Latest Discussions

• Conditional value labels for missing values

  I wonder if there's a way to set up conditional value labels based on values from two columns. If I refer to the snapshot table below, I have "column 1" which could either be filled or empty and I also have "column 2" which either be filled or empty. What I'm trying to do is for "column 2" to be formatted like "Column 3". Which is: (i) values formatted to a date format if there's a value AND the "...

  Djtjhin

  Discussions |

  Jun 11, 2021 8:38 AM

  2597 views | 5 replies

• 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

  17626 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

  7104 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