JMP User Community

Latest Discussions

JMP Query Builder - define the string to append?

Hi, Is there a way to specify a user defined suffix when adding columns to the "included Columns" in JMP Query builder? The background:I want to join several tables via JMP query builder.All tables have the same content, but the values are from different measurements. When I add the values of the second table, jmp detects that values with this name already exist in the list of "included columns"...
hogi

Discussions |
Sep 1, 2022 11:59 AM

1179 views | 2 replies
JSL scripting query regarding jmp table call

I want to call a table which I am using in the current JSL script into another script, is there any way in which I can do that? I have attached snippet of the code, I want to use the dt1_Name (or dt) in another jsl script which I have linked to this script:dt1_Name= Pick File( "Select the JMP MasterFile", "", {"JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, "" ); Show( dt1_Name ); dt = Ope...
shasha_2

Discussions |
Sep 1, 2022 6:40 AM

2268 views | 6 replies
Changing column format only for numeric ones via JSL

Hi, I can't figure out how to change the format for all numeric columns in my table to be with just 2 dec. via JSL. The following code is sending errors because it tries to do it for non numeric columns too. For( i = 2, i <= N Col( dt ), i++, Column( dt, i ) << Format( "Fixed Dec", 12, 2 ) ); Thanks in advance for any help.
LogitTurtle576

Discussions |
Sep 1, 2022 5:22 AM

1450 views | 2 replies
Select latest timestamp (String)

Hi all,How can I select the rows with the same ID and code values but with the latest timestamp?Sample Data:
Expected Output:
UserID16644

Discussions |
Sep 1, 2022 12:30 AM

994 views | 1 replies
What is a correct way to deal with missing fonts?

Let's say I wrote a beautiful script, that uses some fonts - standard fonts you'd find on almost any computer, but not the JMP default fonts.I distributed this script to my users, and I started getting feedback on errors messages about missing fonts.It appears that there are computers in the organization that have a very minimal number of fonts installed.So I wrapped each Font message in Try() sta...
miguello

Discussions |
Sep 1, 2022 12:04 AM

3031 views | 7 replies

Previous
Next

Latest Discussions

Select latest timestamp (String)

Hi all,How can I select the rows with the same ID and code values but with the latest timestamp?Sample Data:
Expected Output:
UserID16644

Discussions |
Sep 1, 2022 12:30 AM

994 views | 1 replies
How to make recursive function with associative array as parameter

I'm trying to parse a nested associative array in JMP 16 (extracted from a JSON). The basic structure of the JSON is as follows:{
"groupOp": "&", "rules": [ {"column": "col1", "op": "==", "value": 1}, {
"groupOp": "|",
"rules": [
{"column": "col2", "op": "==", "value": 2}
{"column": "col3", "op": "==", "value": 3}
]
}
}This would allow structured storage o...
jconte

Discussions |
Aug 31, 2022 6:03 PM

1487 views | 3 replies
set default line widths on map shapes in graph builder

Is it possible to set a different default line width on a map shape in graph builder? Currently, every time I make a map with a referenced "map role" column in graph builder it defaults to a width of 1. To change it to the appropriate scale, I have to go to: customize graph>Shape:>line width and change it manually every time. Thanks
fever

Discussions |
Aug 31, 2022 6:31 AM

3062 views | 5 replies
Should I be using the logistic regression or the categorical response module?

I'm in JMP Pro 15.2.1.I have 60 thousand observations, where the response is true/false and two categorical predictors: job, and group (assume they're not correlated). Many thousands of observations. I was about to do a logistic regression under the assumption that every observation was independent. But then I realized that each person had three consecutive response opportunities (one each quarter...
gchesterton

Discussions |
Aug 30, 2022 8:39 PM

1031 views | 1 replies
Count number of occurrences of a character in a string

Hi,I am trying to count the number of occurrences of a character in a string. How do I achieve that using JSL?For eg:Number of occurrences of letter 'A' in the below stringsAPPLE -> 1PEARS -> 1BANANA -> 2
psundar6

Discussions |
Aug 30, 2022 1:44 PM

1854 views | 1 replies

Previous
Next

Latest Discussions

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

654 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

719 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

721 views | 0 replies
JSL Script Creates New Taskbar Icon When Run

Hi All, I have what seems to be an odd problem. I've created a JSL script that launches a window through which a user can select some options and then run scripts to pull data from various sources. The odd thing that is happening is that when one of these scripts is run it causes all subsequent JMP windows to open under a new taskbar icon. An example for clarity: 1) User opens jmp. There is 1 icon...
jbakri

Discussions |
Aug 1, 2022 12:32 PM

1092 views | 0 replies
Choice model platform and marginal effects?

Hi everyone,I have used the choice model platform to design and analyse choice experiments. However, at the analysis step, there are some parts of JMP platform output that are not clear, and I wonder if you can provide an answer:It is not clear how marginal effects are calculated in JMP.More specifically, how do we obtain marginal probabilities from marginal utilities since neither the utility fun...
gav2013

Discussions |
Jul 18, 2022 7:14 AM

1009 views | 0 replies