JMP User Community

Latest Discussions

Check if table is read-only?

Hey,

I have a large jsl script in which at one stage it opens a couple of data tables, puts data in them, saves them and closes them.

Now, normally it runs fine without any issues. But the data tables it opens are on the company server and it happens occasionally that someone else has the file open, meaning that the script opens a read-only version, and can't save to it.

Is there any way I can add to...
Edde

Discussions |
Jan 28, 2019 5:49 AM

9502 views | 9 replies
Graph Builder Overlay and Color Legend

I have a script that creates a graph builder window that allows the user to click through options in a local data filter to view different sets of data. I have overlay and color variables set, color shows which bucket the data fall into and overlay shows pass/fail using marker shapes. What I want to change is the legend. If the users selection has one bucket that only has data as "pass", then the ...
aallman

Discussions |
Jan 25, 2019 4:49 PM

4650 views | 2 replies
Rolling Cumulative Sum

I am trying to find an efficient way to calculate Rolling 3-day CUMULATIVE SUM. I have some for loops that work, but the data sets I am working with are ~500k rows with many more GROUPS, SUBGROUPS and VALUE columns so it takes ~30 minutes to calculate. The example data set is very stripped down and basic. I moved the values into a matrix and that speeds it up a little, but not enough. There is a G...
ts2

Discussions |
Jan 25, 2019 3:24 PM

8542 views | 3 replies
Change Values in a Column

I found a script that works well however the time it takes to parse at minimum of 80,000 rows is quite long. This is only 1 wafers worth of data and there is an option to add an entire lot ( 7 more wafers). Which the time it takes to change the values will increase by a lot. Any suggestions?Thank your = dt << Get Rows Where( :testname == "test1" ); Column( dt, "channel" )[r] = "N/A (test1)";...
Yngeinstn

Discussions |
Jan 25, 2019 11:17 AM

8968 views | 4 replies
Does JMP still have a function called Exact Wilcoxon Rank Sum test?

Dear Experts, In the older version of JMP, there is a function called "Exact wilcoxon Rank Sum test" specifically used for nonparametric comparison for small sample size (e.g., n<5). However, in the current version (14.0) I did not see this function any more. Can anyone suggest a new function in the new version with similar or the same power as the "Exact wilcoxon Rank Sum test"? Oneway( Y( :C10...
Windermere

Discussions |
Jan 25, 2019 7:13 AM

9780 views | 6 replies

Previous
Next

Latest Discussions

Graph Builder Overlay and Color Legend

I have a script that creates a graph builder window that allows the user to click through options in a local data filter to view different sets of data. I have overlay and color variables set, color shows which bucket the data fall into and overlay shows pass/fail using marker shapes. What I want to change is the legend. If the users selection has one bucket that only has data as "pass", then the ...
aallman

Discussions |
Jan 25, 2019 4:49 PM

4650 views | 2 replies
Automating JMP through Visual Basic (VBA code to import excel data table to JMP)

Hi All, I just want to load data from "combine" sheet to JMP by using VBA code.From JMP menu bar below, actually I can directly click to each option and it also works.But I prefer to do it by VBA coding instead of click directly, may I know how can I touch it by VBA code?Thanks for help.
AlexDong

Discussions |
Jan 24, 2019 9:50 PM

5022 views | 3 replies
Lock Size of Graph Builder with Page and Wrap Variables

Is there a way that I can force the graphs in graph builder to stay the same size? I have an analysis that opens an interactive graph that includes both wrap and page variables. There is a local data filter that allows the user to go look at the data by instrument. However, not every instrument contains data in all of the categories of the page variable. I can't figure out how to keep the graphs f...
aallman

Discussions |
Jan 24, 2019 2:26 PM

3758 views | 2 replies
Extracting substring and converting to column

Hi, Need some help with proceesing a long string.I have a table with several columns;one column has a long string as follows-EntitySubstringARWYT|ZZRZQ_pp29_Nxy13_7|54.58|ZZRZQ_pp29_Nxy13_3|51.72|ZZRZQ_pp29_Nxy13_5|54.31I need to remove first four characters "RWYT" and expected output is as follows: EntitySubstringZZRZQ_pp29_Nxy13_7ZZRZQ_pp29_Nxy13_3ZZRZQ_pp29_Nxy13_5ARWYT|ZZRZQ_pp29_Nxy13_7|54.58...
ENTHU

Discussions |
Jan 24, 2019 1:21 PM

3740 views | 1 replies
JMP PCA Data Help!

I'm new to doing PCAs in JMP. Playing around with it though seems fairly simple. However, when I'm uploading my own data, that's where the problems begin. I am doing 3D GM, so each landmark (36 in total) has an X, Y, & Z coordinate. In a simple txt or Excel table, the data for each specimen is converted into 3 columns (an X, Y, & Z column) with 36 rows (a row for each landmark). It would seem that...
dinosaur4

Discussions |
Jan 24, 2019 7:39 AM

5576 views | 5 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

2411 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

3110 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

3433 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

2326 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

3276 views | 0 replies