JMP User Community

Latest Discussions

JSL: How to copy a formula from one data table to another?

I need to copy a formula from one data table to another.The only suggestion I found and managed to get to work is this:Copy Columns With Formulas
The easiest way is to get the script for the original data table.

data table("Original") << get script;

Now the script appears in the log. Just copy and paste into a new script, keeping only the bits related to adding the the formula columns.
which seems,...
jumper

Discussions |
Sep 25, 2017 2:23 PM

15525 views | 4 replies
Analyze trend

Hi I am comparing Google search data between 3 cancers as part of a small project, and have the attached file generated from Google trends data. How do I see if the searches for a particular cancer are going up with time?, and if so is the difference in trend significant? Next, can I compare trends between cancers C, P and L (from the attached file)?
sajanjiv

Discussions |
Sep 25, 2017 8:39 AM

7905 views | 3 replies
What is the official citation for JMP PRO 12?
gutloja

Discussions |
Sep 22, 2017 12:23 PM

8772 views | 1 replies
JSL: Differences in Column Reference Behavior

Goal: count how many rows of a column have empty values. Method 1 (works):dt = CurrentDataTable(); Print(NRows(dt<<GetRowsWhere(IsMissing(dt:ColName)))); Method 2 (works):Print(NRows(dt<<GetRowsWhere(IsMissing(dt:Name("ColName"))))); Method 3 (doesn't work):Print(NRows(dt<<GetRowsWhere(IsMissing(Column(dt, "ColName")))));The error returned by debugger for Method 3 is "argument should be numeric{...
ABI

Discussions |
Sep 22, 2017 12:08 PM

7177 views | 3 replies
Auto-generated stacked histogram

HiI am looking for a function to generate a histogram with color information on data groups like this:However, in this case I needed to bin the data myself. Also the bars don't touch like normally in histograms. I know the function in graph builder generating the type of histogram shown below, but here the istograms are not stacked but superimposed on each other, and almost impossible to read for ...
JesperJohansen

Discussions |
Sep 21, 2017 11:09 PM

9770 views | 2 replies

Previous
Next

Latest Discussions

Analyze trend

Hi I am comparing Google search data between 3 cancers as part of a small project, and have the attached file generated from Google trends data. How do I see if the searches for a particular cancer are going up with time?, and if so is the difference in trend significant? Next, can I compare trends between cancers C, P and L (from the attached file)?
sajanjiv

Discussions |
Sep 25, 2017 8:39 AM

7905 views | 3 replies
JSL: Differences in Column Reference Behavior

Goal: count how many rows of a column have empty values. Method 1 (works):dt = CurrentDataTable(); Print(NRows(dt<<GetRowsWhere(IsMissing(dt:ColName)))); Method 2 (works):Print(NRows(dt<<GetRowsWhere(IsMissing(dt:Name("ColName"))))); Method 3 (doesn't work):Print(NRows(dt<<GetRowsWhere(IsMissing(Column(dt, "ColName")))));The error returned by debugger for Method 3 is "argument should be numeric{...
ABI

Discussions |
Sep 22, 2017 12:08 PM

7177 views | 3 replies
Auto-generated stacked histogram

HiI am looking for a function to generate a histogram with color information on data groups like this:However, in this case I needed to bin the data myself. Also the bars don't touch like normally in histograms. I know the function in graph builder generating the type of histogram shown below, but here the istograms are not stacked but superimposed on each other, and almost impossible to read for ...
JesperJohansen

Discussions |
Sep 21, 2017 11:09 PM

9770 views | 2 replies
How to disable jmp alert messages?

Please remember that I am scriptless. I am using the Explore Outliers button. When outliers are changed to missing values a JMP alert pops up "Your data in memory has changed. When you are prompted to save later, consider saving to a new file to preserve your original data on disk." The second JMP alert states "n extreme values were replaced by missing". How do you stop these annoying alerts?
kwalter1

Discussions |
Sep 19, 2017 8:56 PM

3431 views | 1 replies
DOE analysis with centerpoint runs

Hi... I am analysing a DOE with centerpoint runs, since we want to know if there are significant quadratic effect. known info: 4 factors are involved with 4 replications in the center pointthe factorial portion of the design is a full-factorial that includes 2^4=16 runsso, the total number of runs of your design is 20each run produced 20 values (readings) a total of 20 x 20 = 400 readings In the...
mai-st

Discussions |
Sep 19, 2017 11:30 AM

6003 views | 2 replies

Previous
Next

Latest Discussions

Cox Proportional Hazard - adjusting risk ratio with std dev

I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP. When I questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...
Maureen

Discussions |
Aug 22, 2017 1:18 PM

3513 views | 0 replies
JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4565 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2279 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4522 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3426 views | 0 replies