Welcome to the JMP User Community!

Latest Discussions

• Tabulate: Showing missing values when using formula derived categorical variables

  Hello,I am putting together a script to build a table that will use a formula derived categorical variable as the columns.  This scipt will be used on different data sets so I'd like to generalize it to show all values in the categorical variable even if the current data set does not show the value. For example, say I have data set containing list of test subjects of different ages like so:ID    A...

  KD

  Discussions |

  Aug 30, 2018 9:28 AM

  6764 views | 5 replies

• Process Capability Screening by Group

  Hi, I have been using the process screening platform to calculate Cpk and Ppk values. Using the "by group" function I am able to use a separate table to define different LSL and USL values depending on the type of the process.  One thing I run into is that by changing the type of the process data column from continuous to ordinal the Cpk calculated are different, particularly at low values of the ...

  bgeaibreyi

  Discussions |

  Aug 30, 2018 6:47 AM

  8896 views | 3 replies

• How can I copy a new table data copy with column names to after the last column of another table?

  For example, the Boston Housing.jmp Summary calculation produces a new table that wants to copy all the column names and data from the new table to the first row after the last column of Boston Housing.jmp.Thank you very much!   dt = Open( "$SAMPLE_DATA/Boston Housing.jmp" ); dt << Summary( Group( :chas, :tax ), Mean( :mvalue ), Subgroup( :radial ), Freq( "None" ), Weight( "None" ) ) ……？？  

  lwx228

  Discussions |

  Aug 30, 2018 12:56 AM

  5704 views | 4 replies

• Adding two columns in a table when one of columns can be blank

  Hi, I have added bunch of data tables (Combined data table, attached) and found out the column Y and SPC_Y are indeed the same variable (Name change during the test). So I need to combine these columns. I wrote the following script and the added column (Y+SPC_Y) is blank.       dt=current data table(); // Two Columns Name that are the same Y and SPC_Y dt<<new column("Y+SPC_Y", continious); f...

  AT

  Discussions |

  Aug 29, 2018 5:59 PM

  6140 views | 4 replies

• Determine if time is between certain hours

  Casual jmp 12 userHow do I have jmp determine if a time is between certain hours on any day?I want to create a column to show (Y/N) if the time when data was taken is between 12:00 AM and 7:00 AM.  So the below data points would be Yes then No.Data taken at random times and transferred into jmp as shown in the examples below.     Data (Example)         Between 12 and 7? (Desired result)11/11/2017 ...

  Elby

  Discussions |

  Aug 29, 2018 12:11 PM

  4258 views | 1 replies