JMP User Community

Latest Discussions

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

5022 views | 2 replies
How to label multiple columns to every points in Graph builder

Hi buddies, I have created a chart with multiples lines (multiples columns) in graph builder. When I labled values for columns (:sbl_rate; :Test module rate; :fab/sort rate; :assembly rate), instead of each point would be labled corresponding to its value, it showed all row values to each point. Please give me advices.
Hanyuri

Discussions |
Dec 20, 2017 1:23 AM

7932 views | 3 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

3921 views | 1 replies
Save script for Fit Model with by group

Hi JMPers, I'm having a problem when saving a script to create multiple models that have been generated by Fit Model using a by-group. What I do is basically the following: Use Fit Model: In the second step I will refine the different models for each group: Now I have two models. I would then like to save a script that reproduces this report. Sadly when saving the script using the typical way (Ho...
shoffmeister

Discussions |
Dec 19, 2017 4:15 AM

8490 views | 5 replies
Interactive date selection and filtering by SQL

I like to use JMP interative to get input start and end time and then use SQL to filter the data table. The parameter dateb and datee if defined as for instance '2017-10-10', '2017-11-11' works fine but when use assigned varaible dateb and datee, I don't get the correct filtering (empty tables).I appreciate any help you can provide. Thanks.------------------------------------ defuplim = Today();d...
AT

Discussions |
Dec 18, 2017 4:34 PM

7011 views | 3 replies

Previous
Next

Latest Discussions

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

5022 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

3921 views | 1 replies
Save script for Fit Model with by group

Hi JMPers, I'm having a problem when saving a script to create multiple models that have been generated by Fit Model using a by-group. What I do is basically the following: Use Fit Model: In the second step I will refine the different models for each group: Now I have two models. I would then like to save a script that reproduces this report. Sadly when saving the script using the typical way (Ho...
shoffmeister

Discussions |
Dec 19, 2017 4:15 AM

8490 views | 5 replies
sample data

Dear all, I'd like to know where I can get sample data which has been excluded from JMP software, because I noted that some teacher applied some sample data which I cannot find in JMP Help>sample data? where I am allowed to download these data base?thanks
mujahida

Discussions |
Dec 17, 2017 4:59 AM

3960 views | 1 replies
Fishers Exact Test in JMP Pro

JMP Pro is reported to have the ability to perform the Fishers Exact test on tables larger then 2x2. In the case of a 2x2 table if the numbers are small the exact test is generated automatically (both in the regular and pro version). How do I access the Fishers Exact test in Pro when the table is larger than 2x2 (3x2 or larger)
shapirodjs0

Discussions |
Dec 13, 2017 1:46 PM

9371 views | 4 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

3913 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

2802 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

2902 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

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