JMP User Community

Latest Discussions

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

3218 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

5324 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

5912 views | 7 replies
Is it possible to format Date/Time or Duration to include milliseconds in a JMP Data Table?

Please excuse my naive question.I have a large dataset from a temperature logger which is sampling several times per second. I would like to format the time column to be able use the milliseconds data. Further, in other data, Durations and Times may include milliseconds, nanoseconds, microseconds etc, but I can see no way to format the column appropriately in JMP so that these values may be used...
matthew_gill

Discussions |
Nov 12, 2018 5:38 PM

13554 views | 3 replies
For loop variable graph reference line

I am generating a series of graphs (10 or more graphs in total) with a for loop; however, after the sixth graph the reference lines do not appear in the graph. After about the 10th or 11th graph, the reference lines appear again in the graphs. I have tried adding wait(0); in multiple locations but that hasn't helped. I have tried using different types of graph, standard bivariate vs graph builder,...
tsolomon

Discussions |
Nov 12, 2018 7:46 AM

71350 views | 5 replies

Previous
Next

Latest Discussions

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

3218 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

5324 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

5912 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

7380 views | 4 replies
Help with graphing ELISA data

Hey guys, I just started using the JMP pro 14 software on a mac and an still trying to figure out how to use the software. I'm trying to get my ELISA data to resemble the attached graph. I cant seem to figure how out to group my data in such a way and am wondering if its even possible.
DBeta

Discussions |
Nov 7, 2018 4:57 PM

3153 views | 1 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

2561 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

3235 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

3644 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

2467 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

3443 views | 0 replies