Welcome to the JMP User Community!

Latest Discussions

• Non-parametric coefficient of determination

  Dear, I have a question about the use of the coefficient of determination (which is part of the output from a regression model). For the study I'm ready to analyze the data, I want to use the coefficient of determination (COD) to examine the relationship between my dependent variables which represent each column (see annex). But, as I found out each dependent variables (column) has a non consisten...

  tomasVH

  Discussions |

  Aug 21, 2019 10:52 AM

  2232 views | 2 replies

• replacing numbers with strings

  hey,i have a column COL_A, which has 31 rows for wach number between 1 - 31 ( 31 rows of 1, 31 rows of 2 .... etc), and i want to replace those numbers with 31 strings in a specifiec order, for example:if my string are in this order: horse, cat, dog ....etc, i want to replace the 1's with horse, the 2's with cat, the 3's with dog...., what is the best and fastest way to do it?

  adham_saif

  Discussions |

  Aug 21, 2019 3:55 AM

  3429 views | 3 replies

• Merging time series with timestamp and duration

  I would like to merge the following tables 1 (time series with certain events, ~2000 datapoints) and 2 (time series with duration and amplitude data, ~1,000,000 datapoints) into a table like 3: 1:timestampevent20:23:56:962A event20:24:14:964B event...... 2:time [s]amplitude0-0.0004577640.00006250.0642700195...... 3:timestamptime [s]eventamplitude20:23:56:9620A event-0.00045776420:23:56:9620.000062...

  WHG

  Discussions |

  Aug 21, 2019 3:19 AM

  3361 views | 5 replies

• how to use join, update and concatenate

  Hi need more information when to use this tools:  join, update and concatenate.Witch one shoul i use to combine to two table that have same column names  but different ID patients? How to add all the patients and make one table? Another question is how to update a table with new data?

  Batista

  Discussions |

  Aug 20, 2019 6:02 PM

  6869 views | 3 replies

• How to pass a date to an SQL Query in JMP

  I’m getting a data sheet via SQL into JMP. One column is a :Date column. I’d like to pick the last date (Max value) or "last date-1 day" from this :Date column and transfer this date into an update querry, where CustomSQL( “ … Date >= ...) is.

  Thomas1

  Discussions |

  Aug 20, 2019 8:22 AM

  2804 views | 1 replies