JMP User Community

Latest Discussions

Delete rows of an empty column

I like to delete the rows of a table when a colum is empty. Here is the script:dt = Current Data Table();dt << select where (:A == ""));dt << delete rows; No rows gets deleted. Please help. Thanks
AT

Discussions |
Jan 3, 2018 3:26 PM

6510 views | 2 replies
Need Help With Tabulate Summary Statistics

I am transferring my companies quality metrics to JMP, and I am having a hard time with something that seems simple enough. My JMP newbness shows... I have a "tabulate" table that looks something like this: January February March ...Promise qty 10 12 ...
Aaron72

Discussions |
Jan 3, 2018 10:00 AM

10100 views | 4 replies
How to save standardized columns in a script?

I like to save the standardized columns using JSL. Here are is what I had in mine and I get an error when I run the script. dt = Current Data Table(); cc = dt << Get Column Names( Continuous ); ' ncols = N Items( cc ); For( i = 1, i <= ncols, i++, cc << Set Selected( 0 ), col = Column(dt,cc), Distribution( Continuous Distribution(col,Save(Standardized))) ); I appreciate your help. Thanks
AT

Discussions |
Jan 2, 2018 7:18 PM

5700 views | 4 replies
How to change range of Group Y data in Graph Buildfer

Group Y in a Graph Builder chart has grouped the data as ... 8-16, 16-24.... etc (Picture attached) whereas I want 20 to be a cut-off so that the effect can be shown of values <20 and >20. Is there a way to force JMP 13.2.1 to change the range, please? I have tried changing the 'Number of Levels..' but couldn't get 20 as the end of a range on Group Y. Thanks
abdul_saqib

Discussions |
Jan 2, 2018 6:47 AM

17521 views | 5 replies
Reference line from axis to specific value

I am trying to script a graph that shows the predicted value on the y-axis from some specified value on the x-axis on a soft curve. I have managed to pull out the prediction formula and obtain the relevant values to define reference lines. However to communicate this effectively i would like the reference lines to stop at the curve and preferable to be dashed. The above image is as far as I have b...
JPKO

Discussions |
Jan 2, 2018 4:31 AM

16799 views | 5 replies

Previous
Next

Latest Discussions

How to change range of Group Y data in Graph Buildfer

Group Y in a Graph Builder chart has grouped the data as ... 8-16, 16-24.... etc (Picture attached) whereas I want 20 to be a cut-off so that the effect can be shown of values <20 and >20. Is there a way to force JMP 13.2.1 to change the range, please? I have tried changing the 'Number of Levels..' but couldn't get 20 as the end of a range on Group Y. Thanks
abdul_saqib

Discussions |
Jan 2, 2018 6:47 AM

17521 views | 5 replies
Singularity details information from DOE data analysis

Dear JMPers, I encountered an issue, I got data from DOE, when I analyze these data in Fit Mode, then pump up an information of singularity details, I don't understand what happened to my DOE or data? why and how to solve this problem ? in order to present my problem, here I attached DOE data and my analysis here.Thank a lot in advance.
mujahida

Discussions |
Jan 2, 2018 1:51 AM

7297 views | 2 replies
How to stop JMP open file which was opened in a previous session

Hi, in JMP 13.2.1, I mistakenly said 'yes' to a message which has allowed JMP to open a file which I had opened in a previous session. Is there a way to stop JMP open the file on its own every time I start the software, please. Thanks
abdul_saqib

Discussions |
Dec 22, 2017 2:00 AM

4559 views | 2 replies
Merging two tables using several columns

Hello Commmunity, I have two JMP tables where each row represents a person, including age, sex and area, but no unique ID. Table 1 has columns: Age Sex Area and columns with info A B C Table 1 has columns: Age Sex Area and columns with info X Y Z I need a table where rows with A B C are added to those with X Y Z. Is it possible to merge the two based on rows with identical combos of Age Sex and A...
MaximilianN

Discussions |
Dec 20, 2017 7:35 AM

4812 views | 2 replies
assign marker style(line style) by "string" or specific "value" in column

Is it possible to assign the marker style by group name??Taking this script for example,I want to let column "mean" line-style always be dashed and column "Range" line-style be solid in the all page(page by process step) of graph.Some of my page(process step) don't have the "Mean"data.If I script like this,the line style will not fixed at all my plot.Graph Builder( Size( 562, 477 ), Variables(...
Leo_Huang

Discussions |
Dec 19, 2017 8:15 AM

3752 views | 1 replies

Previous
Next

Latest Discussions

Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3765 views | 0 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2649 views | 0 replies
Confirmation of Repeated Measures Analysis, when sphericity if voilated

Hi Everyone, I would like confirmation on the appropriate analysis to run on a repeated measures design.Experimental design:Independent variable: Nutrient treatment (Control, Low, Med, High),Dependent variable: basal diameter, 5 replicates (plants)Repeated measurements were taken at Weeks 0, 1, 4, 7, 10, & 12Split data-> Fit Model-> Y: basal 0, basal 1, 4, 7, 10, 12, Add: Nutrient treatmentPers...
uamiller

Discussions |
Oct 23, 2017 8:07 AM

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

3358 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

4375 views | 0 replies