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
-
Assign unique ID for each unique text
Hi all, I would like to get your help in the following case. I have a data that dealing with drugs and their specific problems within different firms. The two columns (i.e. drug name and problem specifications) are text data. I would like to create a third column (continous one) that add unique ID to each drug name when it appears. For instance, Piperacillin Sodium and Tazobactam Sodium is drug na...
qais_hatim_fda_
8829 views | 5 replies -
Get count for grouping (panels) in graph builder to check the visualisation is sensible
So I have written a bit of JSL which is able to take a data table and make suggestions of graphs. It checks the number of unique values, column data type and column name to assess which graph would be most appropriate. One issue I am having is when it uses Page, Group X, Group Y and/or Wrap and there aren't many data points in the resulting panels. Below is a silly example using Big Class. Clearly...
stephen_pearson
5251 views | 4 replies -
Force Legend with marker and color of row state
Hello, I am trying to make a legend with markers and colors, but I'd like to choose them. I thought it will be easy thanks to row state (color state, marker state,combine states). But once color and marker are assigned to each row, I am not able to find a way to force them in the legend.I would like to do it by script (I was thinking to add a box with the legend), but I am not able to find a way t...
ptijerome
14190 views | 9 replies -
Copy rows and change one column value
I'm finding the row documentation very frustrating. Is it possible to copy an entire row and add it to the current data table? My rows have many columns so I do not want to go through every column name doing this. Alternatively, if it's possible to make a single one-way graph from two different data tables, then this will also solve my problem. Does JMP have that capability?
rossjason
10001 views | 5 replies -
How to set defaults in Fit Model reports (VIF, cp, etc..)
I am doing a lot of model building (using fit model - stepwise/best subsets regression) right now and am tired of having to manually choose certain output display items such as to show the VIF in my paremeter estimates. How to I set the VIF to default appear each time I run a new model. Also, I am largely using mallows cp to begin my model selection. each time I open up a new fit model and run ...
RVhydrA
8500 views | 4 replies
Latest Discussions
-
Get count for grouping (panels) in graph builder to check the visualisation is sensible
So I have written a bit of JSL which is able to take a data table and make suggestions of graphs. It checks the number of unique values, column data type and column name to assess which graph would be most appropriate. One issue I am having is when it uses Page, Group X, Group Y and/or Wrap and there aren't many data points in the resulting panels. Below is a silly example using Big Class. Clearly...
stephen_pearson
5251 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
4694 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
7935 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
4506 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
7129 views | 2 replies
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
3152 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
4200 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
4511 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
4678 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
3612 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...
