JMP User Community

Latest Discussions

Creating a Cumulative Summary Column for different rows

Hi,As you will understand from the question I am a newbie to JSL scripting/formulating/automating...I have a revenue data set which contains a column called as "year" of 2013 2014 2015... I need a Cumulative Sum for each year but when I create a column of Cumulative Sum (by the help of Graph Builder) it adds all the days and year one to another and ends up with grand 3 year total Cum Sum, where I ...
saitcopuroglu

Discussions |
Feb 4, 2015 8:09 AM

13890 views | 14 replies
How to Join and get common matching columns

One of the things that I'm struggling with in JMP is the fact that, when I want to do a many-for-many table join using the "Join" function on matching columns, then the match columns in the resulting table always get/stay segregated between each of the two source tables. JMP doesn't seem to provide an automatic or convenient way to get the common match column(s) with the values filled in for all ...
a01

Discussions |
Feb 4, 2015 5:52 AM

15554 views | 3 replies
Script for Error Bar Line Color in Graph Builder

Hello,I have a fairly simple problem, but cannot find the answer in the scripting guide. I created a temperature graph in graph builder using hourly temperature data. I used a line graph to show the daily mean and added error bars to show the range of daily temperatures. The error bars are the same color as the line graph which makes the mean line hard to see. To get around this, I right-click on ...
joshuas

Discussions |
Feb 2, 2015 11:45 AM

4934 views | 1 replies
Non-numeric Pass/Fail Rate Analysis

I'm a long time JMP user, but a first time poster. I’ve searched and searched and cannot find a means to analyze data the way I’d really like.Attached is an Example data table that I’m using.For my specific example, each “ID” has ~700 unique X/Y coordinate locations. And each one of those X/Y coordinate locations is tested for Pass/Fail. (Pass = “.”; Fail = “F”).Ideally, I’d like:A Contour Plot...
nldavis

Discussions |
Feb 2, 2015 9:31 AM

6174 views | 3 replies
Dynamic Charts and Graphs in JMP

@Hi Dear Friends,I have question regarding the development of dynamic charts and graphs in SAS JMP. Is it possible by SAS JMP scripting? Here I need to include some list boxes, drop down menus,radio buttons and check boxes ect.. agin i need to link all these things to charts and graphs. Please help me or guide me, in achieving this task.Thanks,
Swamy.
swamypamu

Discussions |
Feb 2, 2015 7:29 AM

7961 views | 5 replies

Previous
Next

Latest Discussions

Script for Error Bar Line Color in Graph Builder

Hello,I have a fairly simple problem, but cannot find the answer in the scripting guide. I created a temperature graph in graph builder using hourly temperature data. I used a line graph to show the daily mean and added error bars to show the range of daily temperatures. The error bars are the same color as the line graph which makes the mean line hard to see. To get around this, I right-click on ...
joshuas

Discussions |
Feb 2, 2015 11:45 AM

4934 views | 1 replies
Non-numeric Pass/Fail Rate Analysis

I'm a long time JMP user, but a first time poster. I’ve searched and searched and cannot find a means to analyze data the way I’d really like.Attached is an Example data table that I’m using.For my specific example, each “ID” has ~700 unique X/Y coordinate locations. And each one of those X/Y coordinate locations is tested for Pass/Fail. (Pass = “.”; Fail = “F”).Ideally, I’d like:A Contour Plot...
nldavis

Discussions |
Feb 2, 2015 9:31 AM

6174 views | 3 replies
Dynamic Charts and Graphs in JMP

@Hi Dear Friends,I have question regarding the development of dynamic charts and graphs in SAS JMP. Is it possible by SAS JMP scripting? Here I need to include some list boxes, drop down menus,radio buttons and check boxes ect.. agin i need to link all these things to charts and graphs. Please help me or guide me, in achieving this task.Thanks,
Swamy.
swamypamu

Discussions |
Feb 2, 2015 7:29 AM

7961 views | 5 replies
Image processing

I want to compare multiple images with the reference image and add indication marks on the image if it is different from the reference. Could you please help me making this as a JSL code?
hj

Discussions |
Jan 27, 2015 11:01 AM

7408 views | 5 replies
How to get “Quantile Profiler” and “Distribution Profiler” for a Survival Model in Nonlinear fit?

Hi,I am using the Nonlinear fit in JMP to fit a Nonlinear Parametric (log-normal) Survival Model. After fitting the model, I want to plot the "Quantile Profiler" and "Distribution Profiler" with confidence interval as Survial Analysis Platform does. Is there an convenient way to do that?Any suggestion would be appreciated.

isaac_liu

Discussions |
Jan 26, 2015 8:41 AM

3907 views | 1 replies

Previous
Next

Latest Discussions

test statistics on odds ratios in logistic regression

I've been using logistic regression with multiple categorical predictors. I'm particularly interested in the odds ratios, and I understand how the odds ratios themselves are calculated, but I'm having trouble understanding how the test statistics associated with each odds ratio are calculated. JMP gives the disclaimer "Tests and confidence intervals on odds ratios are likelihood ratio based." M...
mjahnke

Discussions |
Dec 5, 2014 11:03 PM

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

4883 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

4174 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

5112 views | 0 replies