Welcome to the JMP User Community!

Latest Discussions

• Setting Spec Limits using Column Data

  Hi,I have a query that produces a data table with parameter test results and spec limits listed in different columns (example below). Is there a script that can set the spec limits to each parameter? Would I need to rearrange my data table for this to work? Sample IDParameterLSLUSLResultSample 1Parameter 15106Sample 2Parameter 15107Sample 3Parameter 2143Sample 4Parameter 2142Sample 5Parameter 3102...

  Austin

  Discussions |

  Jun 11, 2021 8:41 AM

  2548 views | 3 replies

• 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

  2592 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

  17608 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

  1850 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

  7096 views | 5 replies