JMP User Community

Latest Discussions

Writing to an SQL database

The SQL connection in JMP is great for reading data - is anyone using it to write data?I have a stored procedure which gathers data and writes it to a new table. It uses a second table to read the list of parameters so it knows what data to collect. I can read this table with JMP but writing to it is far from easy:the text columns are saved as in JMP nvarchar with trailing white spaces - this requ...
stephen_pearson

Discussions |
Aug 23, 2023 3:39 AM

14392 views | 7 replies
convert number to datetime with milliseconds

Hi, I have a column with values of the following format: '20230818103947300000'I was hoping to be able to convert it using the custom format (i.e. <YYYY><MM><dd> etc), but I do not see the option for milliseconds. Of course I can make a long formula to extract each individual element and then adding them together, but I really want to avoid that. For reference, in python I am able to do this in on...
mvanderaa1

Discussions |
Aug 23, 2023 1:56 AM

1814 views | 1 replies
Some basic questions about my first DOE response surface design

Hi everyone, I'm quite new to JMP Pro and the questions I'm about to ask are pretty basic. I have two independent variables and a dependent variable (response), all three measured using a seven-point Likert scale. The goal is to analyze the within-individual perceptual (in)congruence between the independent variables and their influence on the response. My sample size is 260. Question 1: When I c...
MIS

Discussions |
Aug 22, 2023 2:16 PM

2564 views | 5 replies
Hide and exclude in multiple select where

Hello, I have an add-in that performs hide and exclude in a for loop. One thing I observed was that the previous hide and exclude gets overwritten by the next column condition. Additionally, I realized that it also overwrote my manual hide and exclude. I have two questions:

1. Is there a way to concatenate multiple select where and then perform an overall hide and exclude?For( i = 1, i <= N Items( ...
Kenobi

Discussions |
Aug 22, 2023 1:02 PM

1211 views | 2 replies
How to create new data table script with variable directory paths

Hi All, I'm updating a script that I've been working on that after the analysis is done, I want to save a picture of the report window and then save a script to the data table that will open the image if the user wants to do that. Each analysis will generate a new report image, and I need the script saved to the data table reference that updated file name (all are in the same directory). Side ...
SDF1

Discussions |
Aug 22, 2023 12:33 PM

2231 views | 3 replies

Previous
Next

Latest Discussions

convert number to datetime with milliseconds

Hi, I have a column with values of the following format: '20230818103947300000'I was hoping to be able to convert it using the custom format (i.e. <YYYY><MM><dd> etc), but I do not see the option for milliseconds. Of course I can make a long formula to extract each individual element and then adding them together, but I really want to avoid that. For reference, in python I am able to do this in on...
mvanderaa1

Discussions |
Aug 23, 2023 1:56 AM

1814 views | 1 replies
Some basic questions about my first DOE response surface design

Hi everyone, I'm quite new to JMP Pro and the questions I'm about to ask are pretty basic. I have two independent variables and a dependent variable (response), all three measured using a seven-point Likert scale. The goal is to analyze the within-individual perceptual (in)congruence between the independent variables and their influence on the response. My sample size is 260. Question 1: When I c...
MIS

Discussions |
Aug 22, 2023 2:16 PM

2564 views | 5 replies
Hide and exclude in multiple select where

Hello, I have an add-in that performs hide and exclude in a for loop. One thing I observed was that the previous hide and exclude gets overwritten by the next column condition. Additionally, I realized that it also overwrote my manual hide and exclude. I have two questions:

1. Is there a way to concatenate multiple select where and then perform an overall hide and exclude?For( i = 1, i <= N Items( ...
Kenobi

Discussions |
Aug 22, 2023 1:02 PM

1211 views | 2 replies
Path analysis in JMP 16 Pro

I have a data set of 768 rows of data taken over 32 months from plots with different ground vegetation and plant genotypes. Climate data (T, RH, and Rain) were collected during the same period from a nearby weather station. I have density estimated of aphids and occurrence data for ants and generalist predators. I would like to use path analysis in JMP to explore how the exogenous variable of clim...
rahanna

Discussions |
Aug 22, 2023 6:38 AM

2263 views | 2 replies
Degrees of freedom for t-value in DOE confidence interval calculations

Hello. I am new here. I have a 2^3 full factorial screening DOE with 3 centre-points. I am fitting a second-degree interactions model, so there are 4 df left for the Total Error; 2 for lack of fit, 2 for pure error. When I display the Parameter Estimates, the Std Error using the "Default" Error Specification is correct and the 95% CIs use a t-value of 2.776 based on 4 df. When I switch to "Pure Er...
BurnStats

Discussions |
Aug 21, 2023 9:53 PM

1054 views | 1 replies

Previous
Next

Latest Discussions

How to prove that the composition of the chemical mixture before and after treatment is significantly different?

Hello! I need to show that compositions of chemical mixture before and after treatment are significantly different. Composition is given in weight %, so the total of all components' weight % in the mixture is 100%. This also means that if one component weight % in the mixture decreased after treatment all other component weight % should be increased. Can I use "Test Mean" from the Distribution pla...
konstantin

Discussions |
Aug 18, 2023 2:14 PM

724 views | 0 replies
How I Apply the deep learning models RNN and LSTM in JMP pro

I want to apply deep learning models in JMP pro, but unfortunately I can't fine any option in JMP pro, Please guide me how I can apply it into JMP pro (if it is available), if not, is there any add in?
qreza110

Discussions |
Aug 16, 2023 10:46 AM

979 views | 0 replies
Robust Fit Outliers - different row set selected and excluded as outliers

Dear community,I have a stacked data table, and want to exclude outliers by a Label (e.g. an element for some measurements).In the robust fit outlier platform I can detect outliers and than can select or exclude corresponding rows.For my understanding, rows that are selected than or excluded, should be exactly the same ones.And that is the case for the below sample data table used in the JSL below...
Georg

Discussions |
Aug 16, 2023 2:40 AM

868 views | 0 replies
Two-way repeat measures ANOVA - data are not normally distributed

I read the previous posts on the two-way repeat measures ANOVA - Multivariate or univariate analysis, and the full factorial mixed model add-in. Now I have two questions: 1) When the data are not normally distributed, would these methods be still valid for the analysis? Any non-parametric analysis on JMP? I noticed that R programming may have certain packages to provide solutions, but I am not a...
HYang

Discussions |
Aug 14, 2023 1:52 PM

812 views | 0 replies
Graph Builder - Summary Statistics - select aggregation column?

Points plot in Graph builder provides an option to calculate summary statistics.By default, points with same x value are aggregated into one value. Is there an option to select another column to specify groups of point which get aggregated?e.g. to display the median height/weight for different ages - with one click. Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Graph Builde...
hogi

Discussions |
Aug 10, 2023 2:23 AM

1094 views | 0 replies