JMP User Community

Latest Discussions

Unable to delete columns in a datatable

Good morning, I am currently writing a script in order to extract data from an Excel file and format the data table.A typical exemple is enclosed to this post.My concern is that I cannot delete the last columns (6th column to the end). Do you have any clue on what the problem is? Thanks in advance for your help!
j_bonnouvrier

Discussions |
Jan 13, 2017 2:07 AM

11687 views | 2 replies
Script to export AIC into new data table

I am comparing AIC results for multiple models in the Fit Parametric Survival platform. At this point, I have a script to run all the models with produces multiple windows, and I and copy/pasting the AIC and other outputs into an excel file one by one. Needless to day, this is a time consuming & wasting process. I'm a novice in JSL, would anybody be able to help me produce an automated process to ...
jpmontagne

Discussions |
Jan 13, 2017 12:33 AM

13459 views | 11 replies
JMP - Excel VBA Automation

Hi, I am using JMP automation to get particular row number based on the selected data using "SelectRowsWhere" function, but I could not get the row number value is there any other way to get the row number. see below my code.Sub getrownum()
Dim MyJMP As JMP.Application
Dim JMPDoc As JMP.Document
Dim DT As JMP.DataTable
Set MyJMP = CreateObject("JMP.Application")
Set JMPDoc = MyJMP.OpenDocumen...
Bala

Discussions |
Jan 12, 2017 5:26 PM

12180 views | 3 replies
Displaying a Graph when Running a Script

Hi. I created a script for my table which I am hoping that when I right-click "Run Script" it would execute my script and display some graphs. However, when I run my main code, the graphs are automatically displayed and when I right-click "Run Script" afterwards it does nothing. I would need your help pointing out the error on my code. Thanks. Below is a section of the long code. aGraph = Graph Bu...
csoon1

Discussions |
Jan 12, 2017 12:52 PM

9422 views | 3 replies
Table Data

I have been searching the boards to see how to bring in all rows of a data set through a query. But when I run the query it only returns the first three rows of data. I know it is probably a simpe solution to this but havent been able to find. Any help with this would be greatly appreciated. mallen810
mallen810

Discussions |
Jan 12, 2017 9:38 AM

6898 views | 5 replies

Previous
Next

Latest Discussions

Table Data

I have been searching the boards to see how to bring in all rows of a data set through a query. But when I run the query it only returns the first three rows of data. I know it is probably a simpe solution to this but havent been able to find. Any help with this would be greatly appreciated. mallen810
mallen810

Discussions |
Jan 12, 2017 9:38 AM

6898 views | 5 replies
Linear regression help

Hello,

I am working on a research project and am trying to perform a pretty basic comparison between a few variables in my data. I have a list of categorical variables (age, initially had pain at onset of symptoms, initially had bladder symptoms at symptom onset, etc) and I am trying to correlate the presence of these variables with a categorical variable at early or late follow up (pain at follow...
cli

Discussions |
Jan 9, 2017 6:24 PM

10194 views | 8 replies
Pass/Fail

What is the best tool to use in order to display pass/fail data?
pchaplin

Discussions |
Jan 6, 2017 8:13 AM

5151 views | 2 replies
legend script problem - cant apply legend

HI all , i write script that should give me a Bivar Plot with 2 rule of legendunfortunately its just show me in the side bar that he recognize the legends but dosent apply them i atteched photo of the problem Thanks in advenced
Dolev1988

Discussions |
Jan 5, 2017 3:24 AM

4354 views | 1 replies
Gauge variation, linearity and bias

When you perform a gauge linearity study and the "mean" bias increases as you inrease along the range of measurements you are said to have a "linearity" problem with the gauge as indicated by the positive slope in the bias-scale graph. If the bias graph slope is zero, random bias, then you are said not to have a linearity problem with the gauge. But what do you can a graph with no linearity prob...
jjhartwi

Discussions |
Jan 4, 2017 11:04 AM

8802 views | 3 replies

Previous
Next

Latest Discussions

How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...
MIKE

Discussions |
Dec 14, 2016 8:48 AM

4791 views | 0 replies
Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4931 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3976 views | 0 replies
Is there an easy way to get the FWHM (full width half max) of a curve using JMP?

Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
mcjorge

Discussions |
Jul 22, 2016 8:13 AM

5271 views | 0 replies
Co-Kriging with JMP and Matlab

Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
samuelbbaco0

Discussions |
Dec 4, 2015 12:32 PM

3668 views | 0 replies