Welcome to the JMP User Community!

Latest Discussions

• Using Char to compare numeric and character values

  Hi,Is it possible to compare numeric and character values? I want to compare two columns (identical or different values). One column has a numeric date and one has a character date and as I need to compare only parts of it I want to use substring. The below script runs, but it doesn´t get me the correct result as all appears to be different (which is not the case). Am I using Char wrong? If( Subst...

  JulieSAppel

  Discussions |

  Feb 7, 2023 4:58 AM

  3669 views | 8 replies

• Authenticate DBC user and pass before storing them for future use

  Hi,I am writing some code to pull data from an ODBC connection. I want to test if the username and password entered are valid. The script is as follows: dbc = Create Database Connection("Driver={Oracle in instantclient11_1}; DBQ=" || target || "; UID=" || user || ";PWD=" || pass || ";FBS=12800000;");I found some solutions suggesting checking if dbc is empty to see if the connection was created as ...

  SivaSubram5313

  Discussions |

  Feb 7, 2023 4:52 AM

  1325 views | 2 replies

• Bad RMSE for Validation data

  HiUsing "Fit Model" I have created a model to identify moisture content in a product using different process parameters. The model is fine (Rsq=0.97) and a fairly low RMSE. The variables used all have Logworth higher than the limit.  The problem arises when I want to take in new data for validation. Here the prediction is very bad. The data that I want to validate is not very different from the da...

  AAYH

  Discussions |

  Feb 7, 2023 3:27 AM

  3135 views | 6 replies

• formula not automatically evaluated until clicking apply button

  Hello. I made a script adding a column with a conditional formula , the output resulted to a null column only until you click apply in the column formula, I want to automatically output it , I asked colleague to try my data and script , it worked with them. what could be the problem with my jmp16.new column("Remarks01",character,nominal,formula(If( :Remarsk00 == "Y",     "1_a",     "2_b" ))); 

  sos012523

  Discussions |

  Feb 6, 2023 11:57 PM

  1246 views | 2 replies

• How do I calculate partial r-squared on a multivariate regression model

  Hello, I have run a multivariate model on JMP, and am now trying to find the partial r-squared for each of my independent variables, but I am having some trouble figuring out how. Would anyone be able to help me answer these 2 questions:1. Is "partial r-squared" the same as "Squared Partial Correlation Coefficients"?2. How would I be able to calculate the partial r-squared? Any help at all would b...

  XH

  Discussions |

  Feb 6, 2023 9:41 PM

  19948 views | 5 replies