Welcome to the JMP User Community!
Ask questions, get answers, meet other JMP usersLearning Resources
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesLatest Discussions
-
Scripting average of last five points for each row type
Hi,I am having issues trying to figure out the best way to average only the last five data points for each row identifier using jsl. I tried to set a sequence and then delete the first x points of the sequence, but the issue is that not each row identifier has the same number of rows. The number of identifiers is also subject to change based on the data pull.
Ex, for the following table I want to o...megball
7814 views | 4 replies -
How to add columns with empty data
I have a table similar to this: xyz xyzxyzaa12 .3bb ..cc2 3 .5The columns have rows containing both numeric and empty data.I want to create a new column (xyz) where I add the data in column x, y and z.In other words, I want the result to look like the green xyz-column. The problem is, when I run my script, I get the result in the red xyz-column..How do I add columns with empty data? I use the ...
sirihofstadtrap
6230 views | 2 replies -
Efficient row state coding
Hi, I'm trying to figure out the fastest way to change row states in JSL. I normally try to avoid selecting rows because it is slower than get rows where(), but I don't see how to use a matrix or list of rows to change row states. Do rows need to be selected to change the state? Mildly related question: Is the color pallette scriptable? I see the "colorbox()" dislplay box but the scripting index s...
mikedriscoll
6723 views | 4 replies -
Contains function help
Hello, I am a JMP/JSL rookie. I was just experimenting if I can get th char number of first "a" in the 'name' column of Big Class.jmp. I am writing this in formula: Contains(:name, "a", 1), and the output is 0 in all the rows. Could someone please point out the problem?:) Thanks!
Ahmadaumair
16968 views | 2 replies -
Data Table Column With Matrix Values
I have a table with a column that contains a matrix in every row. I am writing a script to search within the matrix of a specific row. However, the problem I am running into is that when I try to retrieve a value from that column it returns as " { [1, 2, 3, 4] } " instead of as a matrix. This means I cannot use the Loc() function that I need. I figured out that if I subscript the list with a 1 (as...
aallman
5921 views | 1 replies
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
9985 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
5427 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
4133 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
6215 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
4995 views | 3 replies
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
4042 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
3146 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
3156 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
4202 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
4515 views | 0 replies
JMP Events
-
ChinaShanghai May 29
-
1:00PM - 2:30PM EDTApr 16Jump into DOE: Hands-on Workshop
Jump into DOE Wednesday, April 16 | Live Web Workshop1:00 p.m. – 2:30 p.m. ET Hosted via Zoom...
-
12:00PM - 1:00PM EDTApr 17JMP for Teaching Statistics in Semiconductor Engineering Education
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-for-teaching-stat-semicon...
-
1:00PM - 2:00PM EDTApr 25Getting Started with JMP
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
-
3:00PM - 4:00PM CESTApr 30Scripters Club: Is Your SPC Doing Well?
Is Your SPC Doing Well? Presenter: Georg Raming (Siltronic) Would you like to keep an eye on many SP...