JMP User Community

Latest Discussions

Pivot Table

Hi,I like to transform the following attached JMP table (sample) into sample_out. I appreciate your help. Thanks
AT

Discussions |
Jan 30, 2019 2:08 PM

12066 views | 2 replies
Need help with select where date.

I am creating a subset where I am using Select Where :Login Date == 01/18/2019; I cannot get it to work. I also tried opening the subset and running the query builder. I can add all of the fields and then filter by login date. The login dates show in the filter. If I choose one of the dates and hit update, no records show. Below is my code and I have attached the screen shot of the query bui...
wjalford

Discussions |
Jan 30, 2019 10:10 AM

15481 views | 18 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

3491 views | 0 replies
Editing Color Gradient Scale Using JSL

Hi All, I have this data table for example test = Graph Builder( Variables( X( :X ), Y( :Y ), Color( :Value ) ), Elements( Points( X, Y, Legend( 23 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 23, Properties( 0, {gradient( {Scale Values( [-2 2] ), Label Format( "Fixed Dec", 15, 3 )} )}, Item ID( "Value", 1 ) ) )} )...
bittnere

Discussions |
Jan 30, 2019 8:02 AM

7788 views | 4 replies
How to eliminate the first duplicate row?

Dear community I have a question and that is how to eliminate rows with the first duplicate. Example NrDateCount45672017-01-21155552017-02-03155552017-02-10287452015-03-10183452016-05-01195632016-01-02195632016-01-102 Is there a script how to, in this example, find the duplicates that I have marked here with bold text and either eliminate these rows directly or create an additional column where it...
LarsBirger

Discussions |
Jan 30, 2019 8:01 AM

11477 views | 7 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

3491 views | 0 replies
Editing Color Gradient Scale Using JSL

Hi All, I have this data table for example test = Graph Builder( Variables( X( :X ), Y( :Y ), Color( :Value ) ), Elements( Points( X, Y, Legend( 23 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 23, Properties( 0, {gradient( {Scale Values( [-2 2] ), Label Format( "Fixed Dec", 15, 3 )} )}, Item ID( "Value", 1 ) ) )} )...
bittnere

Discussions |
Jan 30, 2019 8:02 AM

7788 views | 4 replies
verifying 95% exact binomial confidence in JMP - Lower CI OK but Upper not?

Hi,I would like to ask if somebody has encounter the issue I got. I would like to verify the 95% CI for a case as below in the table. 95% Confidence Intervals for the True Rate at all Possible Observed Rates within a Subgroup (n=15)Observed Rate Lower Bound 95% CIUpper Bound 95% CI5/150.1520.723 I used JMP Analyze/Distribution and got the correct Lower CI (0.151763 which verifies 0.152 in the tabl...
konradkk

Discussions |
Jan 29, 2019 7:18 AM

5637 views | 4 replies
JMP has performed an access violation and will shut down while starting JMP

I am getting error "JMP has performed access violation and will shut down while starting JMP" . It also says start up error information is recorded in some folder. I am running JMP 13.0.0 on Windows 7. Any help would be appreciated
Saurabh

Discussions |
Jan 29, 2019 6:05 AM

6941 views | 2 replies
Fitting model to ordinal factors and response

Hello, I have such a diagram and want to figure out the equation which produces it: One can imagine it as a 3-dimentional space with color responces for every S/U/D combination.I filled S/U/D into a JMP table to fit (some kind of) model but realized immediately, that the response in color code (e.g. 1 for green, 2 for yelow and 3=red) doesn't make much sense.To my understanding, the equation...
Roman-V

Discussions |
Jan 29, 2019 4:12 AM

4545 views | 2 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

3491 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

2625 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

3263 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

3696 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

2523 views | 0 replies