JMP User Community

Latest Discussions

How to consider multiple rows for a given Participant ID

This is a pretty elementary question, but how should one go about analysis of a large human clinical research data set with multiple rows for a given participant? Lets say there are columns titled "ParticipantID", "Visit", and "HasBeard" each containing categorical data. For each ParticipantID (i.e. 001; 002; 003) there are multiple study Visits (i.e. V1; V2; V3 etc) with each Visit containing uni...
colez

Discussions |
Feb 9, 2021 6:40 AM

3899 views | 7 replies
list box widget not working as expected.

Here is a simple snippet which pops up a list box and when an item is selected it should simply return the item to the log window. In reality I have a function which will do something with the returned item. However, in JMP 15 it always return the item twice which is odd behavior. Maybe this is an unintended use case and I need to use this widget another way. myListBox = listBox({"A", "B", "C"},...
thickey

Discussions |
Feb 9, 2021 6:39 AM

1255 views | 4 replies
envelope calculate function

HelloI have data were I calculate a column with the moving average usingCol Moving Average()for a parameter.I am wondering if there is a function to calculate the min and max envelope line of the data i am not aware ofor is it necessary to program it in jsl?Best regards
nusopiti

Discussions |
Feb 8, 2021 9:40 PM

771 views | 1 replies
How to keep all charaters before a period?

Hi all, This is a simple question I am sure...but I have a column filled with file names "xfsfds.csv" and "sdfdgdfg.csv" What if I want to just keep the names in the column, and get rid of all the ".csv" at the end? Thanks!
schou1994

Discussions |
Feb 8, 2021 4:33 PM

807 views | 1 replies
Display box that can both input column name and numeric value

Is there a display box that can take both column name and numeric value ? I'm trying to create a window where users can either select a column from column list (like a col list box) or insert a constant value (like a number edit box).
Djtjhin

Discussions |
Feb 8, 2021 8:25 AM

1645 views | 6 replies

Previous
Next

Latest Discussions

How to consider multiple rows for a given Participant ID

This is a pretty elementary question, but how should one go about analysis of a large human clinical research data set with multiple rows for a given participant? Lets say there are columns titled "ParticipantID", "Visit", and "HasBeard" each containing categorical data. For each ParticipantID (i.e. 001; 002; 003) there are multiple study Visits (i.e. V1; V2; V3 etc) with each Visit containing uni...
colez

Discussions |
Feb 9, 2021 6:40 AM

3899 views | 7 replies
envelope calculate function

HelloI have data were I calculate a column with the moving average usingCol Moving Average()for a parameter.I am wondering if there is a function to calculate the min and max envelope line of the data i am not aware ofor is it necessary to program it in jsl?Best regards
nusopiti

Discussions |
Feb 8, 2021 9:40 PM

771 views | 1 replies
Display box that can both input column name and numeric value

Is there a display box that can take both column name and numeric value ? I'm trying to create a window where users can either select a column from column list (like a col list box) or insert a constant value (like a number edit box).
Djtjhin

Discussions |
Feb 8, 2021 8:25 AM

1645 views | 6 replies
Genetic Algorithms, Simulated Annealing, etc. for Optimizing QSAR Regression Equations

I am interested in creating regression equations for QSAR-related problems. The general idea is to find a linear regression equation from a pool of many (>200) independent variables or descriptors to predict one dependent variable. Typically, the number of rows/observations is small (n=50 at a minimum). There are ways to do this using Generalized Regression in JMP. While the penalized regressio...
PrakashMadhav

Discussions |
Feb 8, 2021 8:19 AM

2013 views | 5 replies
ANOM for Variances : What is this RMSE refering to ?

RMSE is refering ??
How exactly RMSE is being calculated ? RMSE = Sqrt [ Sum of Square (Predicted - Actual ) / N ] If above formula , then what is predicted & square?
==> predicted is variance of each group ?
==> actual overall variance ?
Loga

Discussions |
Feb 8, 2021 5:21 AM

1273 views | 2 replies

Previous
Next

Latest Discussions

generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

832 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1070 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

2991 views | 0 replies
Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1162 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1051 views | 0 replies