JMP User Community

Latest Discussions

Add a new value to rows of an existing column

Hi, I am new to JSL . I am trying to write a code do achieve the following. I have 4 different JMP table. I am comparing each row of column 1 of Table 1 with column 1 of the remaining three table. If any entry/row of Coulmn 1 /table 1 matches with column 1 of Table 2 , It assigns Character say- Group1 to the row in table 1/ Column 4. Similarly if any row of column 1/tale1 matches with column1 of ...
joydeepb83

Discussions |
Feb 20, 2018 9:01 PM

5244 views | 2 replies
Overlay Plot customize color (row colors)

For plotting overlay plots, I have a JMP DataTable where I have programmatically color coded the rows for each device. (large table with 100,000s rows) The color show correctly when I plot at overlay plot X vs Y (points are row colors). There are a few thousand points for each device, and all of the data from each device is always the same row color. When I group my plot by the device, JMP assign...
ChrisM_X

Discussions |
Feb 20, 2018 11:48 AM

13812 views | 10 replies
How to SQL Query an external database and a saved JMP table?

Hi, Within a JMP script I really need to query both a saved JMP table and a seperate database table, but cannot work out how or find a solution online. There is a simplified example code below. The issue is once I have connected to the db I can no longer Query local tables. I know I could do a table join in JMP after the SQL Query on the external db, but the goal is to only pull customers specifie...
david707

Discussions |
Feb 20, 2018 11:18 AM

10889 views | 3 replies
join data table output culumns

hello, i need join with a script 2 data tables and select output columns for a new data table.Can you help me ? Best regards, Anthony
AnthonyS

Discussions |
Feb 20, 2018 7:57 AM

10102 views | 9 replies
Prediction formula null values

Hello, After saving my prediction formula from GenReg, I'm seeing about 80 percent of my dataset has null values (.) in the predicted values column. I suspect it has something to do with several "levels removed" in some of my significant predictors. Any advice on how to handle this or how to pivot from this in order to arrive at a higher yield (of predicted values) would be appreciated. Thank you...
samalar

Discussions |
Feb 20, 2018 6:15 AM

6115 views | 4 replies

Previous
Next

Latest Discussions

Add a new value to rows of an existing column

Hi, I am new to JSL . I am trying to write a code do achieve the following. I have 4 different JMP table. I am comparing each row of column 1 of Table 1 with column 1 of the remaining three table. If any entry/row of Coulmn 1 /table 1 matches with column 1 of Table 2 , It assigns Character say- Group1 to the row in table 1/ Column 4. Similarly if any row of column 1/tale1 matches with column1 of ...
joydeepb83

Discussions |
Feb 20, 2018 9:01 PM

5244 views | 2 replies
Prediction formula null values

Hello, After saving my prediction formula from GenReg, I'm seeing about 80 percent of my dataset has null values (.) in the predicted values column. I suspect it has something to do with several "levels removed" in some of my significant predictors. Any advice on how to handle this or how to pivot from this in order to arrive at a higher yield (of predicted values) would be appreciated. Thank you...
samalar

Discussions |
Feb 20, 2018 6:15 AM

6115 views | 4 replies
Overlay markers on multiple graphs

These are the graphs that I'm working in. I'm new to JMP and I've been trying to figure out how to make all three of these graphs have the same attributes that the bottom one has from the legend. I need all three graphs to use the same overlay markers and colors. Any help would be appreciated!
ebluhm

Discussions |
Feb 14, 2018 10:37 AM

2479 views | 1 replies
Axis in Loading plot of PCA in JMP

Hi, I am relatively new to PCA analysis as well as to JMP. How can I change the PCA loading values on the x and y axis of the plot that JMP rovides when you do a PCA analysis? Right now the default is PCA1 on x axis and PCA 2 on y axis. I would like to plot PCA3 on y axis and get a similar plot with the vectors showing in diff directions, labels etc.
helga55

Discussions |
Feb 13, 2018 1:39 PM

6945 views | 4 replies
using right y axis on graph builder and color coding

Hi, I am building a graph with graph builder. I have 4 variables that I am showing on the y-axis, two on the left axis and two on the right axis. I am using points, and would like the points to be color coded based on another variable (which happens to be color). The color coding is working only for the variables using the left axis. Is there a way I can color the right axis variables? Thanks!
tova

Discussions |
Feb 13, 2018 5:51 AM

5069 views | 2 replies

Previous
Next

Latest Discussions

.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

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