JMP User Community

Latest Discussions

Syntax: How do I create an index column by ID

Hello JMP Community, I am trying to create a column that indexes rows by an ID column. In other scripting language, this is accomplished with the following lines. By ID: gen IDIndex = _n By ID: gen IDCount = _N I can do the following, but I index and count the whole table New Column( "IDIndex", formula( Row() ) ); New Column( "IDCount", formula( N Row() ) ); Advice on this would be great! Very...
mpg

Discussions |
Oct 7, 2014 8:59 AM

29574 views | 5 replies
how to make a subset of a table and append data from loop

Hi, I have a set of data, (see attached). i want to check every row on a column (against a certain criteria) and then isolate rows that do not meet that criteria and subset them into a new data table. i want to be able to repeat this for multiple columns (where each has its own criteria) and continue adding to this subset table that i originally created. i'm having some trouble with this and was...
bk

Discussions |
Oct 3, 2014 7:35 AM

6378 views | 2 replies
Fit Model: Square Transformation vs 2nd Order Polynomial

I am using the Fit Model platform in JMP to create a simple standard least squares fit with one model effect. I noticed that using the square transformation on the effect gives a different fit than using the 2nd order polynomial of that effect (after removing the first order term to leave only the 2nd order term). JMP gives a warning about leaving the 1st order term out of the model, but I conti...
kcros

Discussions |
Sep 27, 2014 11:49 AM

10526 views | 3 replies
How to check valid inputs in a Modal Dialog

I have written a jsl script which inputs three positive integers and creates a table. It works fine if the user gives valid inputs. My question is how can I verify the inputs to ensure that they are numeric and integers? Additionally, I would like to have the checking done within the modal dialog so that it will check for invalid input and give the user an opportunity to correct it. Lastly, my...
orthogonal

Discussions |
Sep 26, 2014 2:56 AM

10753 views | 2 replies
My script editor is very slow

it is lagging behind my typing and I am not a fast typer! Does anyone have/had the problem? Is there a solution? I am working on Windows 7 (64), and my resource monitor shows some 25% CPU usage when I scroll in my scripts, which also sounds too much to me...Ursula
ursula_garczare

Discussions |
Sep 24, 2014 6:39 AM

11148 views | 4 replies

Previous
Next

Latest Discussions

how to make a subset of a table and append data from loop

Hi, I have a set of data, (see attached). i want to check every row on a column (against a certain criteria) and then isolate rows that do not meet that criteria and subset them into a new data table. i want to be able to repeat this for multiple columns (where each has its own criteria) and continue adding to this subset table that i originally created. i'm having some trouble with this and was...
bk

Discussions |
Oct 3, 2014 7:35 AM

6378 views | 2 replies
Copying the legend box from one graph to the other

I wanted to overlay a line graph over a box plot so I used the 'copy frame contents' function to copy the frame contents of a line graph and place it over a box plot. Is there a way to also copy the legend box of the line graph to the new destination?Thank you in advance
vidushan_jeyane

Discussions |
Sep 20, 2014 12:10 AM

8281 views | 7 replies
Import from Excel yields random missing fields (dots) in JMP

Hi,

All my source data is in Excel and when importing into JMP, either by Opening the file directly or by doing a scripted Open Database(), I have some columns of numbers that show up with missing fields(dots). The data in Excel is a formula which provides a number. I can't find a pattern that would hint to why this is happening (some fields are ok).

Any suggestions or known errors?

I'm using JMP8 ...
alex

Discussions |
Sep 15, 2014 4:58 PM

6688 views | 3 replies
EMS vs REML - why do the standard errors differ?

Hi,I've just set up a series of mixed models using the Fit Model platform using one of the JMP demo data sets ("Blood Pressure", in which I've set Doses as a fixed effect and Subjects as a random effect). To analyse those models I have a choice of methodologies: EMS or REML (recommended), so I tried them both, added a pairwise comparison of the doses (the "LS Means Student's t" option on the "Eff...

Discussions |
Sep 12, 2014 12:20 PM

6436 views | 2 replies
JMP Interactive HTML Examples

Update: Now that JMP 14 is released, we've added more examples. You can read about updates to Interactive HTML in JMP 14 here and here. We updated our JMP Interactive HTML Examples and this post for the release of JMP 13 at JMP Discovery Summit. Interactive HTML is all about sharing, so we decided to share a few examples of interactive HTML reports with JMP Discovery Summit attendees next week...
John_Powell_JMP

Discussions |
Sep 12, 2014 7:38 AM

8435 views | 2 replies

Previous
Next

Latest Discussions

What robust methods are common for Process Capability Indices for Non-Nornal distributions?

In Europe, we found it common to use Cpkn as a non-normal Cpk metric, where mean was replaced with median, and stdev was replaced with IQR/1.35. For some "regulatory" or "customer" reports, this seems to be accepted rather than the usual "torture the data until it says its normal" approach with transformations. Does anyone have similar experience or better ideas? (Note: any use of capabilit...
mclayton200

Discussions |
Jun 19, 2014 2:05 PM

4882 views | 0 replies
Graph Builder Remove Variable

Hello,I am trying to use jsl to remove the x-axis variable and replace it with a different one. It looks like I should use the GraphBuilderBox <- Remove Variable() tool, but since I change the x-axis variable multiple times, I do not know its name and would like to use the Remove Variable(Role("X"), Position(1)) method, but this does not work. Any assistance would be appreciated.Thank you,Martin
Martin

Discussions |
Apr 15, 2014 6:44 AM

2747 views | 0 replies
How to calculate average (median) of a group of variables to get the eudlidean centre

How would I calculate the shape of the average (using the median) of a variable from a group within a data set? I need a certain function for calculating the centre of gravity (centroid) or Euclidian centre of this group of variable.
Many thanks!!
alexsheehy1992

Discussions |
Apr 2, 2014 12:17 PM

4171 views | 0 replies
LD50 and LT50 calculation

Hi everybody,I would want to calculate LD50 and LT50 from a dataset organized in 6 columns:- Name of the compound (I just got 1 compound named A)- Concentration of the compound (2 dilutions per compound)- Individual number (a fixed number of 10 individuals is used per assay)- State of the individual at the end of the experiment (1 = alive, 0 = dead)- Day death (experiment last 15 days)- Experiment...
cecilia

Discussions |
Mar 5, 2014 8:13 AM

5108 views | 0 replies
How to add "All pair Tukey-Kramer" & mean diamond in graph builder box plots?

We can do as above simply using "Fit Y by X" with quantiles and compare means , however I can't find the way if I compile box plots using graph builder (especially when I need to compare more complicated box plots).Can anyone show some hints please? Thank you very much.
Anonymous

Discussions |
Mar 2, 2014 9:15 PM

3421 views | 0 replies