JMP User Community

Latest Discussions

Having custom date range in SQL based on user input variable

Hi, I am having issues while trying to have a custom user input based variable into my SQL code. The problem with the database I am connecting is that the date column is character. So here is the actual code that works well with hard coded dates inside the SQL query. Open Database("Generic database connection string",
" SELECT
p.productname,
p.model,
p.family,
TO_DATE (SUBSTR (txntime, 1, 15), 'yy...
bharathu

Discussions |
Sep 5, 2017 11:23 AM

22707 views | 12 replies
List as data table variable

Hello, I need to save the list as data table variable. My List = {1,"2"}; DT << Set Table Variable( "The List", My List ); //doesn't work - the value of the variable is string "List" And then, how do I assign the list to some new variable MyNewListVariable = DT<< Get Table Variable( "The List" ); // Would it work? Thank you.
tom_abramov

Discussions |
Sep 4, 2017 11:32 PM

8076 views | 2 replies
JSL recursion prevented

From the switch to JMP 13 from JMP 12 I keep running across errors due to "JSL recursion prevented". Mostly this is a good thing as I've had to fix bad practices in my code base, however often it just limits functionality. Where I'm seeing it currently is in one of my reports I have a "filter" button, that reruns the display filtering out user specified data. If that button is pushed too many t...
msharp

Discussions |
Sep 1, 2017 2:45 PM

6264 views | 3 replies
How to get equation from fit model

When fitting a model in JMP, it must create an equation to predict the behavior of the response variable from the parameters. Where can that equation be found? Thanks,
Matt
m100psi

Discussions |
Sep 1, 2017 6:57 AM

46947 views | 10 replies
Concatenate values in a column

Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in it. Example below. ROW COL CELL 5 1 5_1 3 2 3_2 12 -1 12_-1 best shot at code so far: column("ROW") << Data type(Character); column("COL") ...
tdiehl

Discussions |
Aug 31, 2017 12:04 PM

10096 views | 1 replies

Previous
Next

Latest Discussions

JSL recursion prevented

From the switch to JMP 13 from JMP 12 I keep running across errors due to "JSL recursion prevented". Mostly this is a good thing as I've had to fix bad practices in my code base, however often it just limits functionality. Where I'm seeing it currently is in one of my reports I have a "filter" button, that reruns the display filtering out user specified data. If that button is pushed too many t...
msharp

Discussions |
Sep 1, 2017 2:45 PM

6264 views | 3 replies
How to generate a Learning Curve Plot for a machine learning method?

Dear JMP users, Is it possible to generate a plot of learning curve such as shown below? Both scripting answer or interactive answer would be greatly appreciated. For example, for a machine learning method (e.g. linear regression), I would like to plot error rate in the Y-axis and training set size in the X-axis.(figure source: http://blog.revolutionanalytics.com/2015/09/why-big-data-learning-curv...
UserLightNew

Discussions |
Aug 28, 2017 10:11 AM

7942 views | 5 replies
list box and iteration

Hello,I have a reporting showing data and structured as below:H1 = H list box( V1 = V list box() / V2 = V list box() / V3 = V list box() / V4 = V list box());Is there a wait to script this type of structure using iteration as all the V list box are identical.I tried to use H1 << append (vi) method but it is not working. best regardsLionel
KinKame

Discussions |
Aug 28, 2017 5:26 AM

9440 views | 5 replies
Is it possible to add a horizontal scroll bar to listboxbox?

Hi, Is it possible to add a horizontal scroll bar to listboxbox? To be clear, it is a listbox(), not a col list box(). Ex:names default to here(1); myList ={}; for(i = 1, i <= 10, i++, myList[i] = char(i) || "abcdefghijklmnopqrstuvwxyz_abcdefghijklmnopqrstuvwxyz_abcdefghijklmnopqrstuvwxyz"; ); myWin = new window("test", lb = listbox(myList,nlines(7), width(250))); Thanks,Mike
mikedriscoll

Discussions |
Aug 23, 2017 1:03 PM

6707 views | 6 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

3570 views | 0 replies

Previous
Next

Latest Discussions

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

3570 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

4641 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2332 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4585 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3469 views | 0 replies