JMP User Community

Latest Discussions

Excel VBA to automate JMP

Hi Folks, i am trying to run JMP time series analysis from excel VBA. below is the codes Sub LData()
Dim myjmp As JMP.Application
Dim jmp_doc As JMP.Document
Dim jmp_BL As JMP.DataTable
Dim jmp_dt As JMP.DataTable
Dim jmp_dtFinal As JMP.DataTable
Dim jmpstr As String
Set myjmp = CreateObject("JMP.Application")
myjmp.Visible = TrueSet jmp_doc = myjmp.OpenDocument("C:\Data_Doc1.xlsx")
Set jmp_BL = jmp_doc.Ge...
KL

Discussions |
Mar 9, 2017 6:02 AM

9382 views | 4 replies
Non-Modal windows/user-interactive script

Hi, Details of my script:Part 1: open a new table so that user fills valuesPart 2: wait for the user to fill values and take the response to proceedPart 3: proceed with the remaining script I am struggling in part 2 because if I use Modal windows, I cannot fill the values in the table.I would like to generate a new window which will wait on user input OK" to proceed but should not interrupt the us...
shashivenky

Discussions |
Mar 9, 2017 4:16 AM

5230 views | 2 replies
Help choosing JMP Analysis for Multiple Factors

Hello! I am using JMP 13 (regular) and learning about predictive and specialized modeling. I have a dataset (attached) with over 100,000 observations of a process. 75% of the observations had a duration of 4 days or less. I'd like to know why some observations took over 4 days. I've identified some possible factors: 1 continuous and 16 categorical. Can you please suggest one or more JMP analy...
jb

Discussions |
Mar 8, 2017 12:10 PM

18232 views | 8 replies
Negative R2 in Mixed Models

How is R2 calculated in JMP (v12.2) when fixed and random effects are included in Fit Model? I can't find any documentation on this. The reason this came up is that I have been getting negative R2 values.
jwiltsie

Discussions |
Mar 8, 2017 7:52 AM

9205 views | 6 replies
Tricky Question about the Graph Builder

Hi JMPers, I'm trying to convince a large customer to use JMP. Now I'm having a hard time to reproduce one of their applications in JMP. The first problem I face, is that we would like to keep the colors from the row-states while using the Overlay-option.We need the above graph (including the blue and red colored points) with connection lines between the two points of each part (Y-axis).I can ge...
shoffmeister

Discussions |
Mar 8, 2017 7:33 AM

9096 views | 3 replies

Previous
Next

Latest Discussions

Non-Modal windows/user-interactive script

Hi, Details of my script:Part 1: open a new table so that user fills valuesPart 2: wait for the user to fill values and take the response to proceedPart 3: proceed with the remaining script I am struggling in part 2 because if I use Modal windows, I cannot fill the values in the table.I would like to generate a new window which will wait on user input OK" to proceed but should not interrupt the us...
shashivenky

Discussions |
Mar 9, 2017 4:16 AM

5230 views | 2 replies
Negative R2 in Mixed Models

How is R2 calculated in JMP (v12.2) when fixed and random effects are included in Fit Model? I can't find any documentation on this. The reason this came up is that I have been getting negative R2 values.
jwiltsie

Discussions |
Mar 8, 2017 7:52 AM

9205 views | 6 replies
Database stored procedure

Hi There, I have a database in which I wrote a stored procedure, which generates a table for DOE analysis. Basically selecting the parameters and their values dynamically, which is why a simple table query does not work.In JMP 13, there is the advance database open table window which lists all the stored procedure in the SQL. I'd like to run "Call StoredProc(x)" by using execute sql but nothing ha...
krisah

Discussions |
Mar 8, 2017 4:10 AM

5005 views | 1 replies
Disallowed Combinations Script with conditional statements

I am using the Space Filling Desing Platform to run a Fast Flexible Filling Design. I would like to add a disallowed combination script where if a level for one variable equals a certain value, then a separate column is limited to a specific value. I have the following script, but the script is not working. I have tried: F1 == 1 & F11 > 0 | F2 == 1 & F12 > 0, but then this removes all cases of...
jshaw04

Discussions |
Mar 7, 2017 6:27 AM

7741 views | 2 replies
Automatically save the file to folder

Hi, does anyone know if I select the any file from desktop,eg: CSV, after i open that file, it can automatically save into the working folder by using JSL? Thanks
blue1994

Discussions |
Mar 6, 2017 5:31 AM

3843 views | 1 replies

Previous
Next

Latest Discussions

Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3539 views | 0 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4530 views | 0 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

4858 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

4990 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

4067 views | 0 replies