JMP User Community

Latest Discussions

Add double quotes to a string

Hi, How can I add double quotes using formula? "" || :Code || "" || ":" || "" || :Description || "" || "," I try doing "", but it does not work. Thank you,Rami
rshehadah

Discussions |
Jan 8, 2019 6:32 PM

5277 views | 1 replies
How to get a average for part of column data by using formula

For example, I have a column:234506070would like to get the average for every 3 rows, and put the average in a new column in first row in every set by using formua, like this: 2 33450 606070
jasongao

Discussions |
Jan 8, 2019 4:35 PM

7948 views | 3 replies
How to extract part of char string in a column by using formula

For example, I have a char column Column 1Cordinate1:N23; Cordinate2:S45Cordinate1:S78; Cordinate2:N85Cordinate1:N67; Cordinate2:N90Cordinate1:S33; Cordinate2:S74 Now I am only interested in the infonation for Cordinate2 North, so I would like to create a new column by using some formula to extract the Cordinate2 N data. The results should look like this: Column 1 ...
jasongao

Discussions |
Jan 8, 2019 2:11 PM

11795 views | 5 replies
LAG function

Hi All, I'm hoping this is an easy line of code someone can help me with. I have a LAG function script written, but it's not letting me grab the first Run. How can I get it to see that there's a Run 1, and not just skip it?Attached is the data. Thanks! Here's my script:Names Default To Here( 1 ); dt = Current Data Table(); dt << select where( :name( "Run" )[Row()] != Lag( :name( "Run" )[Row()]...
kwmcm

Discussions |
Jan 8, 2019 12:50 PM

6079 views | 2 replies
How to retain the cell color after saving the data table into journal or new window

/* After save dt into Journal, the cell color from data data table was changed into the font color in the journal */ Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Color by Column( :age); Wait( 0 ); dt << Color Rows by Row State; dt<<save(); dt<< Clear column selection(); dt << clear select; win = New Window( "New Window", dt<<Journal);
wu

Discussions |
Jan 8, 2019 11:00 AM

4620 views | 4 replies

Previous
Next

Latest Discussions

How to retain the cell color after saving the data table into journal or new window

/* After save dt into Journal, the cell color from data data table was changed into the font color in the journal */ Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Color by Column( :age); Wait( 0 ); dt << Color Rows by Row State; dt<<save(); dt<< Clear column selection(); dt << clear select; win = New Window( "New Window", dt<<Journal);
wu

Discussions |
Jan 8, 2019 11:00 AM

4620 views | 4 replies
Stationariy time series

I have a time series (Occ (%ocupation) vs. time stamp cfr. Time series model in annex) where the autocorrelation function shows a slow decay indicating non-stationarity, however the ADF test all are negative indicating a statationary Occ time series. Which criterion is right? I get extremely good resuts with ARMA as well as ARIMA (diffeferenced) models. Can I assess a non differenced (4,2) ARMA mo...
frankderuyck

Discussions |
Jan 8, 2019 6:41 AM

6238 views | 5 replies
How to plot different spec limit for different group

For example: I have a data table including 2 columns:Value Group12 165 213 167 2Group 1 and Group 2 has different spec limits. How can I set them up and plot the corret spec limit in Graphic builder?Thanks!
jasongao

Discussions |
Jan 8, 2019 5:29 AM

6545 views | 2 replies
Pairwise comparison on interaction term

I would Like to know if Is it possibile and how to perform pairwise comparisons on an interaction term when this one Is between a categorica and a continuous variable. In Jmp I found only multiple comparison for the mai effect. Thank you.
Sarettathepooh

Discussions |
Jan 7, 2019 6:51 PM

20372 views | 6 replies
Can JMP Support Excel Formatting through JSL

All,
Going through several different posts in the community on the topic, I believe I know the answer to my question. However, I will still go ahead and summarize the issue and see if anyone else has gone down this path.

Problem Statement: Generate an Excel Workbook in a previously accepted and recognized template Not for Debate : Why is Excel the chosen format of output

In going...
uday_guntupalli

Discussions |
Jan 5, 2019 4:29 AM

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

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

3527 views | 0 replies