JMP User Community

Latest Discussions

How to stop an SQL query

Hello, I'm looking for a to stop a SQL query running in background from JSL, to close a script neatly in case the user wants to exit before the query is completed. I am using JMP 18.0.1. thanks Matteo
matteo_patelmo

Discussions |
Jul 15, 2024 11:59 PM

2526 views | 5 replies
How does JSL get the file name of an image already opened with JMP?

Thanks!//img=Open("$SAMPLE_IMAGES/tile.jpg"); pp= Current Window(); na=pp << Window Class Name();//？？
lala

Discussions |
Jul 15, 2024 11:04 PM

3065 views | 8 replies
ANOM

I have an ANOM summary report I generated in JMP. I wanted to extract the Group means in each row of the report and save to a new data table (Run Chart) using JSL scripting, any help ?
kd_kel

Discussions |
Jul 15, 2024 10:47 PM

1874 views | 4 replies
Normality and Capability

Hi,1) in Minitab I am able to test multiple variables for normality, can I do the same in JMP? - see picture - Prob_normality2) In Minitab I can have Before and After, can I replicate for JMP? - see CPK Before and After3) In CPk na Minitab you can see PPM for nonconformance instead of %, can I get also PPM instead? Thank you Michal
MichaH

Discussions |
Jul 15, 2024 9:51 PM

6756 views | 12 replies
getting matched entries from 3 different columns

Hi, I have 3 columns with dates of different types imaging tests done in a timeframe. I'd like to see if an individual had done AT LEAST 1 of the 3 different methods in this timeframe. For example: I have entries for US, CT and MRI at baseline. An individual could have done US and MRI = yes at least 1 method. If the person did not have done any imaging test, it would be = no for at least 1 metho...
axm8717

Discussions |
Jul 15, 2024 9:36 AM

1090 views | 3 replies

Previous
Next

Latest Discussions

How to apply a formula to all columns in another table?

I am trying to take a table and apply a moving average to every function to every column. The script below is what I am trying, based on what I saw in another thread here. The goal is to make a new table and then apply the function while referencing the original. However, I keep getting a scoped data table access error. Test = Open("C:\Users\abrokaw\Desktop\JMP MA Test Table.jmp"); //open value...
GroupEdgeColt67

Discussions |
Jul 15, 2024 9:02 AM

1179 views | 3 replies
Turn off "Suppress Eval" on all columns

Is there a way to turn off "Suppress Eval" for all columns? (It seems to have automatically turned on "Suppress Eval" when I saved a .jrp, and I need to evaluate many formula columns in this data table.)
MarkJSchwab

Discussions |
Jul 15, 2024 6:39 AM

1634 views | 4 replies
Negatively skewed data

I am trying to run a multiple regression test in JMP, but my residual data did not meet the distribution assumption. Skewness was -1.21, and kurtosis was 4.52, so my data is negatively skewed. How do I proceed? (I'm somewhat of a newbie.) We haven't learned about transformations such as log or square root. I tried both of these by adding them separately as formulas for the residual data column, bu...
StacyKJones

Discussions |
Jul 15, 2024 4:10 AM

2720 views | 4 replies
SQL Query Case Sensitivity Issue

I'm using JSL to retrieve data from a MySQL database. However, I've encountered an issue where the filtering conditions in my SQL query are case-insensitive by default. This means that the results returned are the same regardless of the case of the filter value.

Here are the two scripts that produce the same results:
Script 1:
New SQL Query(
Version( 130 ),
Connection(
"ODBC:DATABASE=my_database;DSN=my_...
Arthur

Discussions |
Jul 15, 2024 2:17 AM

1894 views | 5 replies
Default Error Bar Color

Hello,I was wondering if there was a way to create a default colour for error bars in JMP (e.g. under Preferences > Platforms)? At present, the JMP default is to colour them the same colour as the bar in a bar chart (albeit, maybe a shade darker). This can make it quite difficult to read. Apologies if this has been answered in a previous post. Thanks for the help.
Heteroscedastic

Discussions |
Jul 15, 2024 1:59 AM

2131 views | 5 replies

Previous
Next

Latest Discussions

Feedback : 404 page for adobe svg plugin

Setup : JMP 17.0.0 on Win11.I create boxplots and export to HTML (default graphics format = SVG).
On line 16 of the html file, there is an autogenerated link to adobe :pluginspage="http://www.adobe.com/svg/viewer/install/"This webpage doesn't exist and I think the Adobe SVG Viewer is not available anymore, so the above link should be removed.https://web.archive.org/web/20121221000422/http://www.ado...
kkchen

Discussions |
Jul 7, 2024 10:33 PM

614 views | 0 replies
How do I get the partial eta squared for a model with random effects?

Hello, I am conducting a two-way ANOVA with a random effect and need to report the partial eta squared. Does anyone know how to do this or calculate it from values displayed in the output? I tried the add-on but it does not support models with random effects. For the model I have a dependent variable and my model effects looks like:variable1variable2variable1*variable2variable3 & random all variab...
ELM890

Discussions |
Jul 2, 2024 9:53 AM

764 views | 0 replies
Hyperparameters and neural network architecture

Hello,I'm trying to reproduce the results obtained on JMP with the "Neural" model by adding nested cross-validation, which is not possible on the software. However, the architecture is very unclear and I can't understand the calculations performed by the model. I don't have access to certain information such as batch size, optimizer used, loss, learning rate (except the one for the boosting), and ...
Grizzly

Discussions |
Jul 2, 2024 5:42 AM

536 views | 0 replies
Questions about Calculating Confidence Intervals in "Agreement within Raters" - Attributive Analyses

Hello everyone, I am currently analyzing "Agreement within Raters" and would like to better understand how these confidence intervals are calculated. My main questions are:What steps or methods are used to calculate confidence intervals in "Agreement within Raters" of Attributive analyses?Which statistical distribution is typically used for these calculations? Could anyone recommend some literatur...
DToniato

Discussions |
Jun 26, 2024 6:03 AM

637 views | 0 replies
Creating a biomarker combination variable

Hi. I want to analyze how well two biomarkers work together in the detection of diseased from healthy and compare the combination to the single markers. I have previously done such analysis in SPSS using binary logistic regression and then simply running ROC-analysis for single markers and combination. With JMP I cannot find how to combine two biomarkers using a logistic regression analysis. Could...
kahuhti

Discussions |
Jun 25, 2024 11:56 PM

593 views | 0 replies