JMP User Community

Latest Discussions

Basic Questions using oracle SQL and JSL

I'm currently doing some testing to see how well JMP 13 and Oracle (12c) can work together. My end-game is to import oracle data using SQL queries into JMP, run analysis on the data, and then return the data back to the Oracle database while dropping the original table. I've been able to sucessfully bring data into JMP, but I'm having issues with saving the data table back to oracle. Here's what...
beastwood

Discussions |
Dec 16, 2016 12:31 PM

19754 views | 11 replies
calculate odds ratios for several predictors

My data consists of two predictors, one with 3 responses (time at exposure) and 1 with two responses(gender.I can do a log reg just fine and I cross my two variables, but I'm not sure how to interpret my OR's, .I want to know: OR for early exposed females. How do I get that? Is that already in the table, or do I need multiply the OR for females with the OR for early exposed?And if it's already in ...
Thaelina

Discussions |
Dec 15, 2016 2:05 PM

15259 views | 4 replies
Calculating Concordance (C-index) for cox models

I'm trying to calculate concordance index in JMP 10 of a cox model. I found this paper for SAS: http://support.sas.com/resources/papers/proceedings09/236-2009.pdf but am not quite understanding what it is that it's doing. Any help is appreciated. proc sql; create table allset as select idn_j, y_j, x_j, idn as idn_i, surv as y_i, combdays as x_i from evtset, obs where idn_j<>idn; quit; d...
vince_faller

Discussions |
Dec 15, 2016 7:37 AM

9901 views | 1 replies
JMP can not be closed properly after running SQL and doing analysis

after running SQL and doing analysis, JMP can not be closed properly and data tables could not be closed without saving it. I am using JMP 12.2.0.I could not share the script as it is connecting to the SQL server where I work. Any hints and helps will be appreciated!
robust1972

Discussions |
Dec 15, 2016 6:03 AM

4481 views | 1 replies
Errors Using the Close Function

I get this error in the log when I try to close and save the data table: invalid argument in access or evaluation of 'Close' , Close/*###*/(dt, filePath || waferId || " Multivariate Correlations.txt") My code works fine up until the last line (close function). It is outputting the data from the matrix box into a data table, so I don't understand why this function isn't working. Any ideas? Thank...
natalie_

Discussions |
Dec 14, 2016 9:56 AM

10244 views | 3 replies

Previous
Next

Latest Discussions

JMP can not be closed properly after running SQL and doing analysis

after running SQL and doing analysis, JMP can not be closed properly and data tables could not be closed without saving it. I am using JMP 12.2.0.I could not share the script as it is connecting to the SQL server where I work. Any hints and helps will be appreciated!
robust1972

Discussions |
Dec 15, 2016 6:03 AM

4481 views | 1 replies
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

4731 views | 0 replies
Paste transpose in JMP Pro 12?

Dear all, Is it possible to paste transpose data to JMP tables? That is, if I copy data that spans accross multiple columns in the source and paste it to JMP to a single column? I searched online and went through through the manual, but couldn't find an answer. Thanks!
ovir

Discussions |
Dec 13, 2016 7:45 AM

3927 views | 1 replies
editing jsl outside of JMP

I do 99% of of my JSL scrpiting inside JMP, but I maintain a repository of several file types and do much of that editing in Sublime. Has anyone every put together a sytax file for .JSL that can be used in sublime or any other editor? I don't do it enough to make it really annoying, but it would be nice to have a similar color scheme in both locations :) If no one has put together such a file, per...
nathan-clark

Discussions |
Dec 13, 2016 6:59 AM

11230 views | 6 replies
Help: What kind of analysis should I use?

Hey JMP community, I currently have a resaerch project, where I am looking at two groups of pts: Lupus pts, and Lupus pt who have asthma. Jmp has a large selection of tests that can be done on any type of data, but I have more of a medical background than a stat background, so figuring out which tests are the right tests have been a little frustarting. So far, I have been doing pretty simple com...
acunar

Discussions |
Dec 12, 2016 5:35 AM

11284 views | 6 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

4731 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

4890 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

3912 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

5194 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

3620 views | 0 replies