Welcome to the JMP User Community!

Latest Discussions

• Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

  I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!   

  yovugaro

  Discussions |

  Mar 22, 2021 2:22 AM

  1360 views | 1 replies

• JMP and SQL queries

  Hey guys, I have two related questions that would be great if I'll find a solution to:
  1. is there a  way that JMP can alter a field in SQL query? I mean that I wish to run JSL code that will ask from a user the date range (for example), it will update it into the relevant field in my SQL query and will run this query. 2. Is it possible to create JSL code that will ask from the user if to run X que...

  Stas

  Discussions |

  Mar 22, 2021 12:16 AM

  2615 views | 2 replies

• JSON to data table: how to avoid NULL columns being automatically dropped?

  Hi All, I'm using JMP 15 and have JSL that retrieves a JSON payload via Http Request(), runs it through Char to Blob(), and then open()s it in a data table. The JSON payload content is dynamic, but is always mappable to a tabular format (rows and columns). The issue: if any keys in the JSON have all NULL values, they are not included in the data table (i.e., no columns are created for these keys)....

  andykpdf

  Discussions |

  Mar 21, 2021 2:19 PM

  8116 views | 6 replies

• Seperating year by Quarters

  I am trying to seperate the year by quarters using dates. I was looking at documentation and it gave the extract function.EXTRACT( datepart, datetime, )I am not sure how quiet to use it, my idea is if data is between Jan 1st and March 28th its Q1 etcI could use if (Jan1st <:Date< Jan1st + In Weeks( 13 ), "Q1",                      Jan1st + In Weeks( 13 )+ In Days(1) <:Date< (Jan1st + In Weeks( 13 ...

  jearls11

  Discussions |

  Mar 20, 2021 11:06 AM

  2448 views | 3 replies

• Capturing degradation fit parameters to table?

  How do I capture reliability degradation fit parameters to table? The four bolded lines are the crux of what I am trying to do. Fitting the degradation and then simply capturing the fit parameters in a column.   Script below:     Degradation( Y( :current ), Time( :time ), Label( :DUT ), Application( Repeated Measures Degradation ), Connect Data Markers( 1 ), Show Fitted Lin...

  galactus3000

  Discussions |

  Mar 20, 2021 4:23 AM

  10260 views | 11 replies