JMP User Community

Latest Discussions

JMP and Dynamic SQL queries

Does anyone know if JMP supports some form of Dynamic SQL queries? I want to do some special querying that is easier to dynamically generate the sql query than directly writing it.
cookiedough

Discussions |
Feb 6, 2019 4:50 AM

4394 views | 2 replies
How to modify control chart x-axis in Process Screening

Using process screening I quickly get the process performance graph giving the 2x2 matrix of stable/unstable and conforming/non-conforming to gauge where to focus my attention for improvement efforts. This is really useful.An example is attached.Since the 12 characteristics in attached have different numbers of data I see the default created control charts always have x-axes that run to the length...
scottahindle

Discussions |
Feb 5, 2019 1:43 PM

8742 views | 3 replies
how to add a new formula with JSL？

all i use the samlpe which named thickness.JMP to produce a new file by summary。 but i don not know to how to add one formula with JSL in summary table。
TONYMA

Discussions |
Feb 5, 2019 12:26 PM

13641 views | 8 replies
Changing data type and modeling type for multiple columns?

I have 8 columns that I need to change data type, modeling type, and format on, is there any way that I can do it as a grouping? Or do I need to write my script for each individual column?
PNash

Discussions |
Feb 5, 2019 10:35 AM

14915 views | 4 replies
Move Selected Columns() with list parameter

If I have a table with five columns: Column 5Column 3Column 2Column 1Column 4datadatadatadatadata and I execute this:dt = Current Data Table(); dt << Move Selected Columns({"Column 1", "Column 2", "Column 3", "Column 4", "Column 5"}, To first)then I get this:Column 1Column 2Column 3Column 4Column 5datadatadatadatadata But if I execute this:dt= Current Data Table(); list = {"Column 1", "Column 2",...
john_madden

Discussions |
Feb 5, 2019 10:35 AM

9402 views | 4 replies

Previous
Next

Latest Discussions

JMP and Dynamic SQL queries

Does anyone know if JMP supports some form of Dynamic SQL queries? I want to do some special querying that is easier to dynamically generate the sql query than directly writing it.
cookiedough

Discussions |
Feb 6, 2019 4:50 AM

4394 views | 2 replies
How to re-size a report table in JSL?

For example, I have made a report from a table as shown below:op1 = tbl1 << Get As Report; But the default display for the report table is too small (yes, I can use the scroll bars to move around). Is there any way in JSL so that I can re-size or maximize the display window for the report? I tried the followings, but none works :-(. <<Set Window Size
<<Maximize Window<<Maximize Display<<Get Max Si...
zxu11

Discussions |
Feb 3, 2019 6:49 PM

5571 views | 3 replies
Huge DF denominators for repeated measures ANOVAs with JMP 14

I used to run repeated measures ANOVAs with JMP 13 with no proglems. But now I got JMP 14 and ran an ANOVA with the same data and somehow got "4326" as a DF Den under "Test Denominator Synthesis". This used to be "42" with JMP 13, and ovbiously the new F ratio got so much larger. I do not think there is anything different I did (data, how to set up), other than I am now using JMP 14 instead of ...
mu

Discussions |
Feb 1, 2019 8:45 AM

18350 views | 15 replies
How to change mosaic plot graph order?

Hey Folks, I was just wondering how to change the order of the data displayed in the mosaic charts. In the picture below, say I would like to change the order of the data to be displayed as blue at the top, or orange goes to the bottom. Thanks in Advance, Thomas
ThomasLovesRedV

Discussions |
Jan 31, 2019 9:28 PM

6282 views | 1 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3517 views | 0 replies

Previous
Next

Latest Discussions

Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3517 views | 0 replies
I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2652 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3293 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3725 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2545 views | 0 replies