JMP User Community

Latest Discussions

Script code for join between

Hi I know you can join tables with JMP. How would I do a join between. In SQL server its something like SELECT * FROM [L].[dbo].[P] P
INNER JOIN [L].[dbo].[FPD] FPD ON
P.[Join Date] BETWEEN FPD.[BeginDate] and FPD.[EndDate] The script builder gives me code like the below with what EQ probably stands for equals. THe between part I added and am trying to figure out the correct way if possible to do i...
bjbreitling

Discussions |
Oct 9, 2018 12:52 AM

4954 views | 1 replies
Combining two Data files

Hello Everyone, I have two separate data files (one for eye movements and one for performance on a task). I want to combine these two data files into one file so that I can analyze them with one another, but am running into troubles on how to get started. The two data files have nothing but the participant file name in common and have varying amounts of responses per participants (ie. The eye mo...
tlsimons

Discussions |
Oct 8, 2018 7:34 AM

18791 views | 34 replies
How can I import reference lines from a column to the X-axis

Hi, I have a large data set with a common time axis. I want to add a column with events that occurred, to display these events as a vertical reference line (on the X-axis). How can I do this? If I now make one graph, I need to manually copy all X-axis reference lines to another graph, I want an automated option to do this.The events will add extra information regarding the trends observed and will...
BART_VDB

Discussions |
Oct 8, 2018 6:20 AM

3315 views | 1 replies
How to compute a match with JSL?

Hello, everyone!
In excel, "=offset(,match(,,)-1,match(,,)-1,,)" functions can be used to calculate, but the speed is slow when the data is large. How to do this with JSL?Thank you!
lwx228

Discussions |
Oct 8, 2018 2:13 AM

10896 views | 9 replies
How do I get the default "minimum Size Split" in a decision tree using JSL?

Hello, everyone!
I want to use JSL get the default "minimum Size Split" in a decision tree .
Thanks you!
lwx228

Discussions |
Oct 7, 2018 1:25 AM

4834 views | 2 replies

Previous
Next

Latest Discussions

Combining two Data files

Hello Everyone, I have two separate data files (one for eye movements and one for performance on a task). I want to combine these two data files into one file so that I can analyze them with one another, but am running into troubles on how to get started. The two data files have nothing but the participant file name in common and have varying amounts of responses per participants (ie. The eye mo...
tlsimons

Discussions |
Oct 8, 2018 7:34 AM

18791 views | 34 replies
How can I import reference lines from a column to the X-axis

Hi, I have a large data set with a common time axis. I want to add a column with events that occurred, to display these events as a vertical reference line (on the X-axis). How can I do this? If I now make one graph, I need to manually copy all X-axis reference lines to another graph, I want an automated option to do this.The events will add extra information regarding the trends observed and will...
BART_VDB

Discussions |
Oct 8, 2018 6:20 AM

3315 views | 1 replies
jmp tabulate to excel

Is there an add-in that can export tabulate to excel?I only found add-in that can export data table to excel. Thanks in advance!
joann

Discussions |
Oct 6, 2018 3:29 AM

19326 views | 17 replies
JMP 14.1 is available! Update your JMP 14 and JMP Pro 14 software

JMP 14 and JMP Pro 14 have received enhancements and fixes in this first maintenance release, JMP 14.1. Please go to jmp.com/update today to update your software—at no charge. You can keep your software updated by setting the preferences to check for updates automatically. In JMP, go to File>Preferences>JMP Updates, and then select the “Check for Updates” box.
LandraRobertson

Discussions |
Oct 4, 2018 2:51 PM

20274 views | 10 replies
Hyperlinks in Text Box or Text Edit Box?

Is there a way to insert a hyperlink into a text box or text edit box? I know that you can do this in a JMP table with the expression column type, and that you can create a button box in a window that acts like a hyperlink. I'm also aware of the << markup syntax for text boxes, but that only lets you do bold, underline and italic.
pmroz

Discussions |
Oct 4, 2018 6:05 AM

12764 views | 12 replies

Previous
Next

Latest Discussions

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

3631 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

2455 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

3433 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2467 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

3023 views | 0 replies