JMP User Community

Latest Discussions

Pull SQLite data into JMP

Hi, I have my data stored in an sqlite database and would like to pull it into JMP and merge with my DOE design. My jmp file looks like this:keyVariable1variable2variable31---2--- My SQL database has the columns like this:keydata_typeresult1Variable112.61Variable215.41Variable317.82Variable18.22Variable27.12Variable37.2 I would like a query to bring in the data to jmp like this:jmptable:keyVar...
DNAFoundry

Discussions |
May 4, 2017 8:53 AM

6529 views | 2 replies
How to continue with no Analysis of Variance significance but Parameter Estimates significance

[interactive explanation] The analysis of responses with a DSD (Definitive Screening Design) resulted in no significance in the Analysis of Variance (p=0.0898) for the "Actual by Predicted Plot" report. But parameter estimates report showed significance (p=0.0321) for one factor. Similar findings are described in the example: http://www.jmp.com/support/help/Examples_of_Definitive_Screening_Designs...
den

Discussions |
May 4, 2017 4:41 AM

10832 views | 4 replies
JMP CDF Plots

When I used JMP to plot CDF plot, I can right-click, and then customize the line style (solid, dashed, etc.), change line thickness, change line color, etc. But those changes seems not included in the 'Script'. When I copy and paste the script, it just the standard CDF plot. How could I change the CDF lines' color/style/thickness using JMP script?Thanks,Qian
qt

Discussions |
May 4, 2017 12:47 AM

12260 views | 5 replies
Max value of each row across multiple columns and the corresponding name of the source column

Hi, is there an easy way to find the max value of each row and the column name (or parameter) corresponding to the max value? Below is a simple example to illustrate the request: T1T2T3T4T5T6T7T8T9T10Max_ValueCol_Name (Parameter)87.283.681.48383838382.383.384.687.2T185.984828483.383.3848386.587.287.2T1084.982.7868382.382.3838283.685.286T385.684.682.784.684.384.384.383.684.986.286.2T1085.283.68283....
ILoveJMP

Discussions |
May 2, 2017 10:46 AM

41800 views | 21 replies
Exponential Decay - Fit Curve

I want the Scale term (a) to =1.0; I'm using FitExponential 2P; can I specify the scale factor somewhere in Fit Curve or do I need to use a different platform?
hockswender

Discussions |
May 1, 2017 4:50 PM

5733 views | 2 replies

Previous
Next

Latest Discussions

How to continue with no Analysis of Variance significance but Parameter Estimates significance

[interactive explanation] The analysis of responses with a DSD (Definitive Screening Design) resulted in no significance in the Analysis of Variance (p=0.0898) for the "Actual by Predicted Plot" report. But parameter estimates report showed significance (p=0.0321) for one factor. Similar findings are described in the example: http://www.jmp.com/support/help/Examples_of_Definitive_Screening_Designs...
den

Discussions |
May 4, 2017 4:41 AM

10832 views | 4 replies
Exponential Decay - Fit Curve

I want the Scale term (a) to =1.0; I'm using FitExponential 2P; can I specify the scale factor somewhere in Fit Curve or do I need to use a different platform?
hockswender

Discussions |
May 1, 2017 4:50 PM

5733 views | 2 replies
Max value of each row across multiple columns JMP10

When I run below script in JMP 10, I get an error message that says - argument should be matrix{1} in access or evaluation of 'Loc Max' , Bad Argument ... Looks like data table indexing is a feature in JMP13. What would be the work around in JMP10?dt = New Table( "Untitled",
New Column( "a", Numeric, Set Values( [1, 33, 1] ) ),
New Column( "b", Numeric, Set Values( [2, 2, 2] ) ),
New Column( "c", Num...
ravi_sasjmp

Discussions |
Apr 29, 2017 3:56 AM

4307 views | 1 replies
List of Missing Values

I am writing a script that determines positional information using lists. It repeats several times for different groups of data, but some of the groups do not contain what I am looking for. This results in a list of missing values {., ., ., ., ., .}. When there are values in the list, I use List[Loc Nonmissing(List)] to get only the nonmissing values from my list and then N Items to count how man...
aallman

Discussions |
Apr 28, 2017 2:42 PM

6682 views | 3 replies
JMP12 Add-In Folder Moved (Local=>Roaming)

As I'm migrating some of my JSL scripts from JMP11 to JMP12, they are Add-In's, I've noticed they would not work. The root cause is that JMP12 is now using the \Roaming folder, where as JMP11 and before used the \Local folder. Does anyone know why JMP12 Add-In's are now using the Roaming folder? Same Windows 8 in each case, same PC: JMP11: C:\Users\<myname>\AppData\Local\SAS\JMP\AddInsJMP12: C:...
djhanson

Discussions |
Apr 27, 2017 2:17 PM

5395 views | 3 replies

Previous
Next

Latest Discussions

Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4260 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

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

3334 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

4392 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

4715 views | 0 replies