JMP User Community

Latest Discussions

Multi-User Access

I'm working on a solution which will live on a network drive, to be accessed by multiple users asynchronously. Specifically, I have several "database" tables that users will add rows to, where the rows then contain links to their full submitted datatable. Is there any built-in way to manage file access permissions in a situation like this? I want to avoid a situation where a user opens the "datab...
DavidLeber

Discussions |
Feb 8, 2019 9:30 AM

5413 views | 1 replies
Interpolate Missing?

I deal with a lot of time-based data, where each row corresponds to an hourly average and each column corresponds to an instrument reading. Sometimes, these instruments fail for an hour or two at a time and the column has a blank value. However, these processes respond fairly slowly, and so I know that the instrument values are probably somewhere between the last good value before the outage and t...
DavidLeber

Discussions |
Feb 7, 2019 3:41 PM

7904 views | 2 replies
Tracking a 96-well over time

Hello, I have a kinetic assay that records OD over time on a 96 well plate.The output is OD and I have data columns with time and location (A1, A2 etc) for each OD value.By applying the map shape I can visualize the 96-well plate in Graph Builder on a certain time (e.g. at 0 or 1 hour). Would it be possible for Graph Builder or another SAS JMP feature to show the development of OD over time on the...
FantaBola

Discussions |
Feb 7, 2019 10:31 AM

15062 views | 13 replies
If statement Formula not working

For the past couple years when I copy and paste the formula below it has not worked consistently. I've tried typing it in the formula box and have at times been succesful but it's not consistent. I was finally upgraded to JMP 14 last week and an option that is awesome is that I can preview a data sample to see what the formula result will look like. However, I can't figure out why this formula w...
Datamom1

Discussions |
Feb 7, 2019 6:52 AM

10756 views | 5 replies
Stack column using table variable list

I would like to stack a list of columns based on a table variable, but I'm having trouble figuring out how to format the variable and the script //this is my table variable -- I've called it myList {"colName1", "colName2"}//this is my script dt = Current Data Table(); dt << Stack( columns(myList), Output Table( "New Table" ) );I have a table with column names colName1, colName2, colName3...And I...
snapnpop

Discussions |
Feb 6, 2019 1:27 PM

5812 views | 5 replies

Previous
Next

Latest Discussions

DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

3876 views | 0 replies
JMP and Dynamic SQL queries

Does anyone know if JMP supports some form of Dynamic SQL queries? I want to do some special querying that is easier to dynamically generate the sql query than directly writing it.
cookiedough

Discussions |
Feb 6, 2019 4:50 AM

3988 views | 2 replies
How to re-size a report table in JSL?

For example, I have made a report from a table as shown below:op1 = tbl1 << Get As Report; But the default display for the report table is too small (yes, I can use the scroll bars to move around). Is there any way in JSL so that I can re-size or maximize the display window for the report? I tried the followings, but none works :-(. <<Set Window Size
<<Maximize Window<<Maximize Display<<Get Max Si...
zxu11

Discussions |
Feb 3, 2019 6:49 PM

4991 views | 3 replies
Huge DF denominators for repeated measures ANOVAs with JMP 14

I used to run repeated measures ANOVAs with JMP 13 with no proglems. But now I got JMP 14 and ran an ANOVA with the same data and somehow got "4326" as a DF Den under "Test Denominator Synthesis". This used to be "42" with JMP 13, and ovbiously the new F ratio got so much larger. I do not think there is anything different I did (data, how to set up), other than I am now using JMP 14 instead of ...
mu

Discussions |
Feb 1, 2019 8:45 AM

15022 views | 15 replies
How to change mosaic plot graph order?

Hey Folks, I was just wondering how to change the order of the data displayed in the mosaic charts. In the picture below, say I would like to change the order of the data to be displayed as blue at the top, or orange goes to the bottom. Thanks in Advance, Thomas
ThomasLovesRedV

Discussions |
Jan 31, 2019 9:28 PM

5770 views | 1 replies

Previous
Next

Latest Discussions

DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

3876 views | 0 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3245 views | 0 replies
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