JMP User Community

Latest Discussions

Get date and time out of a text in a cell

Hi,I have a data set that reports the day and time within one cell in this format: "12.08.2022 15:46:43 GMT-0700" (the date format is dd.mm.yyyy). I would like to create a column for the dates and a column for the time (I am going to assume that the time is the local time and the GMT-0700 is just indicating that is where the local time. So for each cell, I would like two columns: Column 1: In dat...
rlangsner

Discussions |
Sep 15, 2022 10:17 AM

1589 views | 3 replies
In a script, return the selected table scripts as a list

Hi, I am aware of using the code below to return all the table scriptsscriptNames = dt << Get Table Script Names;Is there a way to only return the scripts that I have selected (if any are selected, otherwise return all).So return [Bivariate,Logistic] in the case below
mvanderaa1

Discussions |
Sep 15, 2022 4:10 AM

2760 views | 8 replies
Distribution Nonconformance Statistics vs. Distribution Profiler

Hello JMP Community, I have a set of data that is best fit with a lognormal distribution. I cannot seem to find what is going on behind the scenes for the Nonconformance statistics vs. the 95% confidence intervals of the distribution profiler. When I run the capability analysis, I get a nonconformance table. Observed % is obvious in that my actual data population did not have any values below the ...
gregpearce

Discussions |
Sep 15, 2022 1:04 AM

1532 views | 1 replies
Collapsing Table Variables/Scripts from Data Box

Is there a way to collapse Table Variables/Scripts from Data Box / change height of Columns list to hide it? Or is there any other way of getting column listing from data table with same functionalities? What I have: What I would like to have: Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp", invisible); New Window("Big Class", H List Box( lb = List Box(dt << Get Column Na...
jthi

Discussions |
Sep 14, 2022 6:44 AM

1130 views | 2 replies
JSL how to launch JMP platforms with pre-defined selections/options?

Is there any "good" options for running JMP platforms with prefilled options, such as column selections. Below are two options that came to my mind. First option is "building" the platform window and then selecting columns from table and pressing button to add those columns. Second option is first running the platform with JSL script and then << Relaunch Analysis to open the window "prefilled". N...
jthi

Discussions |
Sep 14, 2022 6:39 AM

1422 views | 2 replies

Previous
Next

Latest Discussions

Collapsing Table Variables/Scripts from Data Box

Is there a way to collapse Table Variables/Scripts from Data Box / change height of Columns list to hide it? Or is there any other way of getting column listing from data table with same functionalities? What I have: What I would like to have: Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp", invisible); New Window("Big Class", H List Box( lb = List Box(dt << Get Column Na...
jthi

Discussions |
Sep 14, 2022 6:44 AM

1130 views | 2 replies
Is Missing command- Scrippting

In this example, ;"Sum of A+B+C" calculates sum of :A + :B + :C in each row with this formula: If( Is Missing( :A ), 0, :A ) + If( Is Missing( :B ), 0, :B ) + If( Is Missing( :C ), 0, :C )If I change the specific column names to with column number, the script is not working anymore and generates an error If( Is Missing( Column( 1 ) ), 0, Column( 1 ) ) + If( Is Missing( Column( 2 ) ), 0, Column( 2 ...
GroupSquareWolf

Discussions |
Sep 13, 2022 7:54 PM

1624 views | 4 replies
Delete columns with for loop

Hi, I create a for loop script to delete empty column (column contains only N/A).It works ok except on one file, one column get deleted when it's not suppose to.Not sure what's wrong for (i= ncols (dt[d]),i>=1,i--, summarize(data table(dt[d]),temp = by(column(i))); if(nitems(temp) ==1 & temp[1]=="N/A", data table(dt[d])<< delete columns(column(i)); ); );

yanee

Discussions |
Sep 13, 2022 11:59 AM

1360 views | 1 replies
dynamic Y variable for oneway analysis

Hi everybody, I am trying to script a dynamic Y variable for oneway analysis, then output the mean into a combined table. Is this a correct way to do so ?dt = Data Table ("Analysis"); ColNamesList = d1 << get column names (string ); For( i = N Items( ColNamesList ), i >= 1, i--, OW = (dt << Oneway( Y( Column(ColNamesList) ), X(:SITE), Mean ( 1 ), Automatic Recalc( 0 ) )) << Report; )...
XiangCD_MP_User

Discussions |
Sep 13, 2022 11:23 AM

1920 views | 4 replies
Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

625 views | 0 replies

Previous
Next

Latest Discussions

Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

625 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

652 views | 0 replies
How to transform least square means from Turkey table after box cox transformation

Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
Viniaze

Discussions |
Aug 27, 2022 9:14 AM

699 views | 0 replies
XGBoost Add-In for JMP Pro no test set result in model screening

I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
TasapornV

Discussions |
Aug 25, 2022 12:45 AM

762 views | 0 replies
JMP Pro, Dantzig selector: how do I improve computational time

Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Not_A_Student

Discussions |
Aug 12, 2022 7:49 AM

768 views | 0 replies