JMP User Community

Latest Discussions

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

4740 views | 1 replies
jsl :group and stack columns with variable suffixes

Hi,I am new to scripting and would greatly appreciate any help with the following:I am trying to write a script that will allow me to group and stack columns with variable name suffixes. My table consists of a few columns with names that dont change (i.e. source, frame) and many others (up to hundreds) that begin with x, y, area, perimeter, AR and have the suffix 1, 2, 3, etc . so normally it woul...
andres

Discussions |
Mar 7, 2017 1:29 PM

8904 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

7472 views | 2 replies
Sample Size and Power for Testing standard deviations

I am wondering why the Sample Size and Power Calculator does not have an option to estimate sample size for test of standard deviations for two populations. I can find graphical methods in appendices of some statistics textbooks, but they must have come from some computation. How do I estimate a sample size to distinguish standard deviations with a certain ratio with a certain power? I realize tha...
JesperJohansen

Discussions |
Mar 7, 2017 4:09 AM

11232 views | 8 replies
Distorted Images when pasting in PowerPoint

Hi, I have a sporatic problem when pasting images into PowerPoint using the paste special command and selecting picture. Attached is one image I copied from JMP V12.2.2.0 on a Mac. The normal looking image I pasted in Preview using the new from clipboard command, the skewed one I did in PowerPoint using the paste special. Is anyone else seeing this? I have sent this to support but they had no i...
Hegedus

Discussions |
Mar 6, 2017 7:46 AM

24846 views | 3 replies

Previous
Next

Latest Discussions

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

4740 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

7472 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

3690 views | 1 replies
Where is the binomial reliability calculation hiding?

I'm doing a binary test (pass/fail) and the number of acceptable failures depends on the sample size and acceptance/confidence limits. It's a binomial reliability calculation. I can find reliability lifetimes but no basic sample size calculator that takes failures into account. MiniTab has it clearly available, and I found very simple online calculators, but I need to document the calculations in ...
Lisa

Discussions |
Feb 28, 2017 4:05 PM

5105 views | 4 replies
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

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

3333 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

4389 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

4713 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

4868 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

3882 views | 0 replies