JMP User Community

Latest Discussions

Importing SQL using a temp table

I am having a difficult time using Stored Procedures and Temp tables in JMP 11.2.1. I simply get no returndb = Create database Connection("DRIVER=SQL Server; SERVER=localserver\SQLEXPRESS; DATABASE=Test");Execute SQL(db, " CREATE TABLE #Test ( ID int) Insert INTO #Test (ID) VALUES (1), (2), (3), (4), (5) SELECT * FROM #Test DROP TABLE #Test ", ":-(");close database connection(db);This...
vince_faller

Discussions |
Jul 6, 2016 2:52 PM

16740 views | 14 replies
customize the formatting of the target excel file when save a data table as a excel file.

I would like to ask JMP community to help me out on a custom way to export JMP table to excel.Part of my script need to export a JMP table to excel file.Ideally, I would like to customize the formatting of the target excel file when exporting. (with desired column width, row height, color, etc.)But so far, I find that JMP will only carry the cell color to the target excel file. And I’ve been looki...
zlsas

Discussions |
Jul 6, 2016 11:26 AM

9587 views | 3 replies
Date does not replicated into JMP from Excel

Hi All,Need help !Not very familiar with JMP & still learningAfter copy the data from excel & pasted into JMP, the date cannot get it correctly.Anyone can help to guide me ? Thank you
tohalan

Discussions |
Jul 6, 2016 10:21 AM

6874 views | 2 replies
How to extract characters in occurrences of a certain character

for instance, I have a string of "JN-36M-GRNNC", I would like to extract "JN", "36M and "GRNNC" by using formula. The length between "-" is not fixed, can vary. I found an example on how to do it in Excel, https://www.ablebits.com/office-addins-blog/2015/10/07/excel-find-search-functions/. I wonder how to do it in JMP.
Thank you!

jyw

Discussions |
Jul 5, 2016 9:15 AM

10657 views | 2 replies
Name Unresolved question

Dlg = Dialog ("Select Grill", vlist(Selection = listbox(GrillList),button("OK")));eval ( dlg [1]);GrillSel = dlg ["Selection"];Show( GrillSel );An error popup message...Name Unresolved: Grillsel when GrillSel is used in a column formula.Help is appreciated
vincent_kane

Discussions |
Jun 30, 2016 11:17 AM

12383 views | 3 replies

Previous
Next

Latest Discussions

Date does not replicated into JMP from Excel

Hi All,Need help !Not very familiar with JMP & still learningAfter copy the data from excel & pasted into JMP, the date cannot get it correctly.Anyone can help to guide me ? Thank you
tohalan

Discussions |
Jul 6, 2016 10:21 AM

6874 views | 2 replies
Find slope for a row of data, not a column

Data are by subject over time, across a row. See the following example:columns _1 _2 _3 _4 _5 _8 subject(001) data -0.069965723 0.492749371 0.955245597 1.346963522 1.701118239 2.523141195 I have thousands of such rows where the slope is needed.All I really need is the slope for each series of numbers in the row. A new additional column following each series should contain the slope value for that...
nkormanik

Discussions |
Jun 30, 2016 7:35 AM

7515 views | 3 replies
ANOVA result output file: 1. How to get rid of unwanted data I mean I just want to see the summary table with letters showing significance. 2. How to edit this file this table or any output figure? How to perform ANOVA for Split Plot Design?

ANOVA result output file: 1. How to get rid of unwanted data I mean I just want to see the summary table with letters showing significance. 2. How to edit this file this table or any output figure? How to perform ANOVA for Split Plot Design?
manphoolfageria

Discussions |
Jun 30, 2016 4:16 AM

4702 views | 1 replies
What is JMP? What does JMP do for you?

Hi,I was wondering what your understanding of JMP is, or what JMP does for you or your company.We recently tweeted, "What is #JMP, you ask?"As JMP users, you probably get asked that question.I found a couple of cool links describing what JMP is.Dave@Pega-Analytics created this cool animated gif describing JMP.And this one from the web. And this paper titled, "I'm a SAS Programmer. Why should I...
stan_koprowski

Discussions |
Jun 29, 2016 3:18 PM

11379 views | 3 replies
How to get/read chart's y-axis max value?

For a given JMP chart (e.g. Variability chart, Box chart, etc) how to have JSL read in the chart's current y-axis maximum value?Usually this is contained within SendToReport within a Dispatch (so I know how to change it in JSL). But I'd like to read in the latest value in the event the user manually changes it by dragging the y-axis up/down with their mouse.thanks, DJ
djhanson

Discussions |
Jun 24, 2016 10:45 AM

5274 views | 1 replies

Previous
Next

Latest Discussions

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
Interpreting canonical structure and scores in discriminant analysis

I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
amzipkin

Discussions |
Oct 20, 2015 3:25 PM

3592 views | 0 replies
Generalized Segmented Distributions

A former classmate of mine from Graduate School has recently published a paper on Generalized Segmented Distributions. Utilizing this method, the distribution can approach any continuous density function of arbitrary form. The method is particularly effective in fitting data with sufficient observations that are skewed and/or multimodal. The paper can be found here:The General Segmented Distrib...
Steven_Moore

Discussions |
Sep 17, 2015 11:54 AM

2403 views | 0 replies
Running JSL Script After Creation of a File

sophiaw

Discussions |
Sep 1, 2015 9:56 AM

2639 views | 0 replies
Clash?

saitcopuroglu

Discussions |
Aug 18, 2015 6:43 AM

2416 views | 0 replies