JMP User Community

Latest Discussions

JSL help: How can I open an excel spreadsheets and delete duplicates?

I have my script (from the excel import wizard) as well as the example attached. All those columns are there but I just removed the data. I am mainly looking to open an excel spreadsheet and only keep columns B and C while also deleting duplicate rows. I keep getting errors when debugging that the This is my script so far. I don't have a duplicate delete portion because I keep trying to deal wit...
Hobbi

Discussions |
Oct 27, 2021 1:47 PM

1857 views | 2 replies
Repeated measures analysis data setup

Hello all!I am trying to figure out how to set up my data to run repeated measure analysis on the attached dataset. I have different samples which are divided into two groups and those samples are tested at different time points. Output is change from baseline for 3 different attributes (x, y and z). Also, where is option to run repeated measure in JMP Pro? Thanks.
statlearner

Discussions |
Oct 27, 2021 10:10 AM

879 views | 2 replies
JSL Help: How to create all permutations of a vector or a list

I am trying to figure out the best way to write some JSL to enumerate all the permutations of a vector or list. One algorithm I've found, that looks promising, is Heap's Algorithm https://en.wikipedia.org/wiki/Heap%27s_algorithm , but I just can't seem to figure out how to code this up. Can someone help me out here? I realize that the larger the size of a vector or list, the size of the outpu...
MathStatChem

Discussions |
Oct 27, 2021 9:46 AM

4699 views | 5 replies
User Input List for Regression Analysis

I have an input box where users can select columns to be run in a regression report. (Long story on why I want to do this.) This part works great. I then insert the list of columns into a list. When I try to put the list or even just a few of the column names into the regression report. It doesn’t work. What should I do to make this work? The user input list readout looks like this: {"Column 1",...
dkraeuter_sunne

Discussions |
Oct 27, 2021 8:10 AM

1006 views | 2 replies
I/O Problem. Unable to get End of File marker. Unable to get End of File marker.

Hi, I have a problem with my script.I am running a script that modifies a data table which will be saved after the change (not closed). Other colleagues use this file (only read, not write mode). But unfortunately, I got now different types of error messages within the Log window. And on top the file is not saved. The messages are:I/O Problem. Unable to get End of File marker.I/O Problem. "somthin...
mkennke

Discussions |
Oct 27, 2021 2:38 AM

4498 views | 2 replies

Previous
Next

Latest Discussions

User Input List for Regression Analysis

I have an input box where users can select columns to be run in a regression report. (Long story on why I want to do this.) This part works great. I then insert the list of columns into a list. When I try to put the list or even just a few of the column names into the regression report. It doesn’t work. What should I do to make this work? The user input list readout looks like this: {"Column 1",...
dkraeuter_sunne

Discussions |
Oct 27, 2021 8:10 AM

1006 views | 2 replies
I/O Problem. Unable to get End of File marker. Unable to get End of File marker.

Hi, I have a problem with my script.I am running a script that modifies a data table which will be saved after the change (not closed). Other colleagues use this file (only read, not write mode). But unfortunately, I got now different types of error messages within the Log window. And on top the file is not saved. The messages are:I/O Problem. Unable to get End of File marker.I/O Problem. "somthin...
mkennke

Discussions |
Oct 27, 2021 2:38 AM

4498 views | 2 replies
JMP script to substract column value, if nth column have no data i need to take N-1 column value

Hi Team, Please help to suggest some solution for below issueNeed to create a script that can work in both situation,column 8 = column 7-column6 but if column 6 is having empty cell then , column 8 = column 7-column 5 Note: column name is variable controlInput:
jinsejoseph

Discussions |
Oct 26, 2021 2:20 PM

921 views | 3 replies
Random blocking added to Covariates

I am trying to afix a random effect blocking variable to an existing design which I treat as covariates. The program seems to be bringing in the blocking variable as a fixed effect. How do I make the blocking variable a random effect?
DrRubber

Discussions |
Oct 26, 2021 11:14 AM

622 views | 1 replies
Variability Chart Platform Factor Re-Insert Positions (Not Swapping)

Hello JMP Community, I understand dragging between any two factors swaps the location pairs in the Variability Chart platform. Is there a way to drag to specifically re-insert the factors instead? For example, can I drag "Layout" between "Horizontal" and "Wafer ID" in the attached screenshot instead of performing multiple drags to have the intended result? I am aware I can do this reordering with ...
Technician

Discussions |
Oct 26, 2021 11:04 AM

799 views | 0 replies

Previous
Next

Latest Discussions

Variability Chart Platform Factor Re-Insert Positions (Not Swapping)

Hello JMP Community, I understand dragging between any two factors swaps the location pairs in the Variability Chart platform. Is there a way to drag to specifically re-insert the factors instead? For example, can I drag "Layout" between "Horizontal" and "Wafer ID" in the attached screenshot instead of performing multiple drags to have the intended result? I am aware I can do this reordering with ...
Technician

Discussions |
Oct 26, 2021 11:04 AM

799 views | 0 replies
how can I use structural equation model to make predictions?

Hi, I built a structural equation model and it works well. I would like use the model to make some predictions. Basically, what I want to do is to change the value of a variable and then JMP can calculate the values of other variables. Is there any way i can output the model equation so that I can use it to predict? Thanks.
lujc07

Discussions |
Oct 22, 2021 11:54 AM

548 views | 0 replies
Get (x & y) intercept values from linear fit of the linear region of a curve/data and store them in a new column

I have JMP data table with data from several parts for which a Capacitance 'C' has been measured as a function of reverse voltage 'V' (0 to -5 V in -0.1V step). A plot of [1/C]^2 vs V has a linear part for small reverse bias (say from 0 V to -0.5V and data is available at 0, -0.1, -0.2, -03, -0.4 -0.5 V within this range). How to do a linear fit to the points between 0 to -5V for each part, extrac...
Neo

Discussions |
Oct 22, 2021 10:15 AM

556 views | 0 replies
Debugger report for finding bottlenecks

I'm trying to find bottlenecks in a large script with many includes. I can run the debugger to profile the script but I'm wondering if there's a better way than just looking through each included script for the highest number. I'm imagining a pareto. Anyone know a good method to analyze script performance?
vince_faller

Discussions |
Oct 22, 2021 7:31 AM

478 views | 0 replies
world map server compatibility

I have successfully used 1-2 world map servers in the past through GraphBuilder but am encountering issues recently (JMP Pro 16). I can't figure out if it's something on my/JMP's end, or the WMS themselves. For instance, the US government has all these presumably WMS-like mapping products: Note: tiled services may show up as Web Map Tile Service (WMTS), rather than WMS. Most software that can loa...
abmayfield

Discussions |
Oct 22, 2021 4:56 AM

544 views | 0 replies