Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI need to merge two different data sets. The first, A, has data collected every 2 minutes. The second, B, has data collected only when a measurement crossed a threshhold. A-sample2017-01-21:00:02:00, 1, 2, 3, 42017-01-21:00:04:00, 2, 3, 4, 52017-01-21:00:06:00, 3, 4, 5, 6...B-sample2017-01-21:00:02:05, 45002017-01-21:00:05:14, 5700...It will be sufficient to put B data into the nearest A row. For...
michaelclarage
Hi JMP community, After 2 days of learning, I have finally produced a JSL script that performs the column name change operation I was looking for. However, considering the rather laborious process to get to this result, I suspect that I may have used sub-optimal approaches. Therefore, I'm looking for ways to clean up this script. Names Default To Here( 1 );
dt = Current Data Table();
src=.;
trg =...
Thierry_S
Hi, I have a list of a huge number of columns to stack that have column format name of TEST_BOUROUGH_GENDER, as shown below. Now the BOUROUGH can be missing from the column name and that imples the value from the column is from all the BOUROUGHs (ie NYC). I stacking all of the TEST_BOUROUGH_GENDER column names and then creating new columns called test, location and gender (see below). When I run i...
tarkan_bih
I have a string in a cell that has the format AB1234(Name). I would like to remove everthing past the 4. The result would be each cell under the column LOT_NUMBER would be AB1234. I have tried the word function ; for each row(word(1,:LOT_NUMBER,"(")); This did not work. Can you please give me a recommendation. Regards, Wayne
wjalford
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
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
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
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
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
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
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
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
// 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
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
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...
tom_abramov