JMP User Community

Latest Discussions

Help with Data Filter Context Box()

I am having trouble inserting a Data Filter Context Box into my script. My script is used to pull in data via SQL, perform some table functions and then spitting out graphs inside of tabbed windows. This makes it visually nicer than what i was doing as every singe output had a new window associated with it and the Test Engineers would have to click on multiple buttons. I have read these boards as ...
Yngeinstn

Discussions |
Jan 9, 2019 4:23 AM

10144 views | 14 replies
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

4982 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

7504 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

11079 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

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

4172 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

5714 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

6193 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

19067 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

28293 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

2412 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

3111 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

3437 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

2327 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

3280 views | 0 replies