JMP User Community

Latest Discussions

Save template of data table as JSL script

Dears, I'm doing some data preparation actions (e.g. standardize colums format, change header name, add formula...) based on one jmp data table, want to save those actions into script (similar like macro in excel) then later can used it for other set of data table doing the same things kindly asking is there a way to do it ? if possible, can anyone show steps how to make it into JSL? thanks ...
hupin

Discussions |
Feb 13, 2018 1:06 PM

22796 views | 8 replies
Cluster correlations analysis in JMP?

Hi Everyone,I just whatched one of @julian you tube videos, displaying how to make different heatmap correlation plots using jmp.I am trying to analyze one of my data sets by taking different correlation values, spearman p, pearson, and kendall's t, then clustering the data using different techniques, ward, average, complete linkage etc. The end result is to produce something similar to the photo ...
Kyle

Discussions |
Feb 13, 2018 10:35 AM

10408 views | 5 replies
tablet dissolution profile

Hi,I have a set of tablets in which one component determines how slowly the active is released (measured at 1, 2, 3, 4, 5 and 6hours).If I have the results for tablets containing 10, 15, 20 and 25% of this component how can I create a model that will tell me how much of that component is needed to obtain a target profile (target release values at target timepoints)?Thanks
bambi

Discussions |
Feb 13, 2018 6:29 AM

7741 views | 7 replies
Coloring only some data in the graph builder

I am trying to color only part of the data in a plot by a certain color. To be more specific, I start with such a graph builder: Now I would like to color the black data for example by the column "band". So I drag the band column over 'Color'. However, then also the red line gets colored as in: Is there any way of coloring only the black points without affecting the red lin...
areimers

Discussions |
Feb 13, 2018 5:54 AM

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

4877 views | 2 replies

Previous
Next

Latest Discussions

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

4877 views | 2 replies
Create a formula for temporary variable

Hi all, im still new to JMP scripting. I need help to create a formula to make the value as a variable but with its own name. What i mean is as below. So, i want to create a formula that can make column 4 below as a variable for distribution graph. it is like Plastic = 0.424542 the problem right now is the formula name will be in the same which is t4 = :TYPE;:MIN;. So if i want to plot the min v...
mhalwi

Discussions |
Feb 11, 2018 3:04 AM

20753 views | 15 replies
Hive SQL Query builder - Performance issues

Hi Guys,I'm running JMP 13 and have used the cloudera hive ODBC driver to sucesfully connect the JMP query builder to our hadoop hive server. I am able to view the tables ok, but once i click on one of the tables it automatically sends a "select * from table" query to the hadoop cluster which completely hangs up my JMP due to the enormous size of the table its trying to pull without my consent. Is...
scott_87

Discussions |
Feb 7, 2018 10:11 PM

3998 views | 2 replies
JMP 13 JSL that passes variables to oracle SQL statement

I am working with a collegue that has a JMP 13 script to is defining variables using Modal windows. User selection then sets variables that we want to pass into a open database section of our script in the SQL statement. Data table is updated for which oven is selected in the Modal window. We then select the oven column to pass this value into our SQL statement. Example. OvenList={18,22}; n...
steve_reinhart

Discussions |
Feb 6, 2018 12:36 PM

6071 views | 3 replies
Tabbox

I am trying to create a tab box display with a bivariate plot. I have the script that already generates the bivariate fit.what is the jsl code for creating tabbox?
jaysiri

Discussions |
Feb 5, 2018 8:06 PM

2625 views | 1 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

2276 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

3771 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

2650 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

2756 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

3362 views | 0 replies