JMP User Community

Latest Discussions

Update Issues in jsl script

Hello,I am trying to add 2 columns in table (dt_delta) to table (dt) using update command by comparing 2 columns. dt has 40 rows with unique rows identified by "Age" column and dt_delta has 50 unique rows identified by Age.Hence i am trying to add data from two columns, Var1 and Var2 in dt_delta to dt table by matching Age columns.Var1 and Var2 columns have formula in them. I copied the executed s...
CG

Discussions |
Sep 7, 2018 3:31 PM

6090 views | 8 replies
Col (Sum) function by selecting specific rows

Hello,I would like to create a column which calculates another columns mean or sum but I would like to specify the function by :Let’s say if we select the year the calculation to be occured by "Year" or, Let’s say col (sum) of NetRevenueWithoutVat by Year or "NetRevenueWithoutVat" by "Month (Stay Date)" orCol (Sum) functions of specific row numbers...Would anyone please share his/her knowledge how...
saitcopuroglu

Discussions |
Sep 7, 2018 3:10 PM

34203 views | 16 replies
Test if data table is locked

I know that I can lock and unlock a data table through the Lock Data Table() command, but how do I test if a data table is locked? A table locked through Lock Data Table() returns Empty() when using the Get Edit Lock() function. //:*/dt<<Lock Data Table(1);
/*:Scriptable[]
//:*/
dt << Get Edit Lock();
/*:Empty()
MarkDayton

Discussions |
Sep 7, 2018 12:38 PM

4330 views | 3 replies
Reduced Major Axis regression in JMP

Can you do a reduced major axis (RMA) regression in JMP Pro 14? I've been trying to figure it out. Is it one of the orthogonal regression models? Thanks!
DAS_Owen

Discussions |
Sep 7, 2018 11:17 AM

8703 views | 3 replies
Formulation DOE

I have to define DOE for 2 continuous factors and 1 qualitative factor with 2 levels (A and B) tested at different concentrations. My constraints are the following:- if the A concentration is >0 then B=0- if the B concentration is >0 then A=0The objective is to optimize the formulation.I try to do a custom design but I didn't find the way to define my constraint.The optimum should select the bes...
hytou31

Discussions |
Sep 7, 2018 8:43 AM

7943 views | 7 replies

Previous
Next

Latest Discussions

Update Issues in jsl script

Hello,I am trying to add 2 columns in table (dt_delta) to table (dt) using update command by comparing 2 columns. dt has 40 rows with unique rows identified by "Age" column and dt_delta has 50 unique rows identified by Age.Hence i am trying to add data from two columns, Var1 and Var2 in dt_delta to dt table by matching Age columns.Var1 and Var2 columns have formula in them. I copied the executed s...
CG

Discussions |
Sep 7, 2018 3:31 PM

6090 views | 8 replies
Test if data table is locked

I know that I can lock and unlock a data table through the Lock Data Table() command, but how do I test if a data table is locked? A table locked through Lock Data Table() returns Empty() when using the Get Edit Lock() function. //:*/dt<<Lock Data Table(1);
/*:Scriptable[]
//:*/
dt << Get Edit Lock();
/*:Empty()
MarkDayton

Discussions |
Sep 7, 2018 12:38 PM

4330 views | 3 replies
QQ-Plot double x-axis

Dear Community, Please help, how do I change the ugly default QQ-Plot in jmp so that it does not have two x-axis and a histgoram but only a normal x- and y-axis?
juliaaline

Discussions |
Sep 1, 2018 3:43 AM

10672 views | 13 replies
Query Builder for Oracle database slow unless use Custom SQL() argument in New SQL Query() function

Hi JMP users. When using the JMP Query Builder, we have fast response for SQL servers using "ODBC Driver 11 for SQL Server", but slow response on some Oracle servers using "Oracle in OraClient11g", on the order of 2 to 3 minutes. We discovered by accident that it works just fine using the Custom SQL() argument in the New SQL Query() function in the script, instead of using the generated script fro...
Vball247

Discussions |
Aug 31, 2018 1:22 PM

4217 views | 3 replies
Duplicate a column

Hello, I'm relatively new to scirpting..I'm interested in simply duplicate a column within the existing table. I would the duplicated column to be last and have a different name. After that, I would like to annonymize the original column. Thanks
moti617

Discussions |
Aug 31, 2018 12:02 PM

7347 views | 4 replies

Previous
Next

Latest Discussions

repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3276 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2314 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

2840 views | 0 replies
Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1710 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3807 views | 0 replies