JMP User Community

Latest Discussions

batching recoding of many columns

Hello, I've been trying to recode many columns which contain a specific string in their column name using the recode function. I think I'm pretty close but the script is getting stuck with the column evaluations. So I'm missing something crucial somewhere. Any guidance would be greatly appreciated. Best, Sebastien Names default to here(1); Clear log(); New Table( "Subject_Demographics", Add Rows...
Sburel

Discussions |
Mar 15, 2021 9:21 PM

1202 views | 2 replies
How to refer to the datatable from which script was done?

This might be a stupid question, but how do I refer to the datatable from which I ran the script if I dont know what the table name it is save as before hand? In most solutions in the forum the script starts with something as:dt = Open( "$SAMPLE_DATA/Big Class.jmp" );and then you can do things to dt like dt << NewColumn( - - - -But what if I want my script to just run asuming dt is whatever table ...
spoikayil

Discussions |
Mar 15, 2021 9:03 AM

1056 views | 1 replies
error when run python code(created through JMP formula depot )

JMP model would give me a formula and I want pass the formula and used it in python or R program.Through formula depot, it generated Python code, and I tried to copy the python code and run it through Jupiter Notebook, but always give me error :for example, I attached the test file and python code created from JMP and run. it didn't recognize as array... please help. thanks!!! I thought it is eas...
lucy_luo_conoco

Discussions |
Mar 15, 2021 2:59 AM

13472 views | 14 replies
interaction profiles

I did a fit model of each of the response and from the predicted formula from each response ran a profiler combing all the predicted formula and predicted SE. When I look at the interaction profiles from the profiler, it's slightly different than the interaction profile of the fit model of the response. Is there a clear explanation for this?Thanks.
jtlam

Discussions |
Mar 14, 2021 11:16 PM

1362 views | 1 replies
How to split table and keep all columns with correct information?

I'm trying to split a table by "Method", so each method becomes a new column, with the values associated. But I want to keep all the other columns, ID and Name.Initial table:Desired split: or Either of the formats pictured above would work for my purposes. However using the split function:Which gives me wrong results:For example, ID = 3, B = 222 was done by Jon, not Alice. So the values for ID and...
Agustin

Discussions |
Mar 14, 2021 8:02 AM

5471 views | 8 replies

Previous
Next

Latest Discussions

batching recoding of many columns

Hello, I've been trying to recode many columns which contain a specific string in their column name using the recode function. I think I'm pretty close but the script is getting stuck with the column evaluations. So I'm missing something crucial somewhere. Any guidance would be greatly appreciated. Best, Sebastien Names default to here(1); Clear log(); New Table( "Subject_Demographics", Add Rows...
Sburel

Discussions |
Mar 15, 2021 9:21 PM

1202 views | 2 replies
How to refer to the datatable from which script was done?

This might be a stupid question, but how do I refer to the datatable from which I ran the script if I dont know what the table name it is save as before hand? In most solutions in the forum the script starts with something as:dt = Open( "$SAMPLE_DATA/Big Class.jmp" );and then you can do things to dt like dt << NewColumn( - - - -But what if I want my script to just run asuming dt is whatever table ...
spoikayil

Discussions |
Mar 15, 2021 9:03 AM

1056 views | 1 replies
interaction profiles

I did a fit model of each of the response and from the predicted formula from each response ran a profiler combing all the predicted formula and predicted SE. When I look at the interaction profiles from the profiler, it's slightly different than the interaction profile of the fit model of the response. Is there a clear explanation for this?Thanks.
jtlam

Discussions |
Mar 14, 2021 11:16 PM

1362 views | 1 replies
Test for frequency data of related sample

Hello, I was wondering if someone can please help me know what type of test i should apply on my frequency data. Here is situation:I have frequency data of 45 consumers, obtained through five answer boxes for 7 samples. Consumers were asked to taste the sample and write their response about taste in the five boxes below. Their response were categorized into 4 categories, like Abstract taste for 1s...
sharmachetan

Discussions |
Mar 12, 2021 11:51 PM

1155 views | 1 replies
Convert Date/Time (down to the millseconds) into a Variable

Hello,I am trying to convert a date/time down to the milliseconds in order to insert into an SQL statement that I am using in my JSL script. The typical method I use to do so usually creates the variable (date) with single quotes around it. However, when attempting the same method to my date/time which includes milliseconds it adds two single quotes to each end of the variable. Could someone assis...
Sully

Discussions |
Mar 12, 2021 5:40 AM

1375 views | 1 replies

Previous
Next

Latest Discussions

What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1334 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1190 views | 0 replies
generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1012 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1277 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

3681 views | 0 replies