JMP User Community

Latest Discussions

How to write a script for Wilcoxon rank-sum test for thousands features

Hi all experts, I am an user of JMP. I am writing to learn how to write a script to caculate Wilcoxon rank-sum test results for thousands of features. The tables of grouping and features(from feature_1 to feature_n) are attached as the figure above. Here is what I am going to do:1) Wilcoson rank-sum test for "Treatment A vs. No treatment" for feature_1 to feature_2000. I understand I need to use ...
Windermere

Discussions |
Nov 14, 2018 10:06 AM

12493 views | 16 replies
Create a subset by ID based on column maximum value

Hi group, Using JMP 14, I have a dataset where I have measurements of an analyte on several individuals over different visits. I would like to subset the dataset keeping only the row for the last visit for each individual. How can I interactively do this (no scripting if possible)? I attach a simplified version of the dataset with only 4 individuals. The resulting dataset should have only 4 rows w...
david_arteta

Discussions |
Nov 14, 2018 6:39 AM

5870 views | 2 replies
Bar charts with two Y-axis

Hello everybody, I am trying to make a bar chart with two Y-axis. This post https://community.jmp.com/t5/Discussions/Graph-Builder-how-to-do-2-Y-Axis-s-left-and-right/m-p/38327#M22435 helped me to make a secondary axis, however now the struggle is to make bars for both the sets of values. Hope someone know how to do this, as this is tricky in Exel too. Thanks!
therese

Discussions |
Nov 14, 2018 6:23 AM

5266 views | 2 replies
How to replace "." or "-" character to "/"

Hello,I started a script that imports multiple excel files into one table. The date field has a mix of formats; mm/dd/yyyy , mm.dd.yy and mm-dd-yy.I tried using recode, and looking at the script it looks like static values:Current Data Table() << Begin Data Update; dc1 = New Column( :Date ); dc1 << Set Name( "Date 3" ); Current Data Table() << Go to( dc1 ); Current Data Table() << Move Selected Column...
Herrera5238

Discussions |
Nov 13, 2018 2:37 PM

3258 views | 1 replies
Concatenate table values into a string variable

I have a table of characters and want to produce a string variable of the concatenated values of each column to use as the argument of a function. Let's say this is my table of data:Column1 Column2Item1 Value1Item2 Value2Item3 Value3Item4 Value4Item5 Value5 . . . . . . The table will have 2 columns but any number of rows. The output I'm looking for is thi...
RonSwanson

Discussions |
Nov 13, 2018 11:20 AM

5402 views | 4 replies

Previous
Next

Latest Discussions

Bar charts with two Y-axis

Hello everybody, I am trying to make a bar chart with two Y-axis. This post https://community.jmp.com/t5/Discussions/Graph-Builder-how-to-do-2-Y-Axis-s-left-and-right/m-p/38327#M22435 helped me to make a secondary axis, however now the struggle is to make bars for both the sets of values. Hope someone know how to do this, as this is tricky in Exel too. Thanks!
therese

Discussions |
Nov 14, 2018 6:23 AM

5266 views | 2 replies
How to replace "." or "-" character to "/"

Hello,I started a script that imports multiple excel files into one table. The date field has a mix of formats; mm/dd/yyyy , mm.dd.yy and mm-dd-yy.I tried using recode, and looking at the script it looks like static values:Current Data Table() << Begin Data Update; dc1 = New Column( :Date ); dc1 << Set Name( "Date 3" ); Current Data Table() << Go to( dc1 ); Current Data Table() << Move Selected Column...
Herrera5238

Discussions |
Nov 13, 2018 2:37 PM

3258 views | 1 replies
Concatenate table values into a string variable

I have a table of characters and want to produce a string variable of the concatenated values of each column to use as the argument of a function. Let's say this is my table of data:Column1 Column2Item1 Value1Item2 Value2Item3 Value3Item4 Value4Item5 Value5 . . . . . . The table will have 2 columns but any number of rows. The output I'm looking for is thi...
RonSwanson

Discussions |
Nov 13, 2018 11:20 AM

5402 views | 4 replies
Local data filter

Control Chart( Sample Label( :C_LOT_NAME ), Group Size( 1 ), KSigma( 3 ), Chart Col( :Average Pigment Strength, Individual Measurement( Show Zones( 1 ), Shade Zones( 1 ) ), Capability( Distribution( Automatic Recalc( 1 ), Continuous Distribution( Column( :Average Pigment Strength ), Quantiles( 0 ), Summary Statistics( 0 ), Outlier Box Plot( 0 ), Normal...
ChrisNally

Discussions |
Nov 13, 2018 7:26 AM

6071 views | 7 replies
Exporting data from jmp to excel without excluded rows

Hi, Is there any add-in for jmp that helps exporting data to excl without exclueded rows? Thanks,Ne
NeF

Discussions |
Nov 9, 2018 1:52 AM

7501 views | 4 replies

Previous
Next

Latest Discussions

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

2596 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

3253 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

3680 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

2512 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3511 views | 0 replies