JMP User Community

Latest Discussions

Transpose column, make transposed rows headers in JMP12

Does anyone know how to transform a column (just one column) and make the rows become the table header using JSL? I am using JMP12.Basically, I want the first row to be the column headers and not the output below. My dataset is attached. Thanks,Simondt = Data Table( "sports" ) << Transpose( columns( :Items ), Output Table( "transposed" ) );
simon_2

Discussions |
Mar 19, 2021 8:33 PM

2927 views | 4 replies
Plotting UCL/LCL defined in columns in the row

Hi,Can someone share how to script adding LCL/UCL to any type of plot when these limits are defined in a column in that specific row. The table has several parameters being plotted (identified by column Label), so each chart has a different set of limits defined for each of the chart types in that row. For example(attached), if we had two columns of UCL/LCL in the big class example with stacked da...
deveshchugh

Discussions |
Mar 19, 2021 4:41 PM

18075 views | 9 replies
How to calculate probability of being uninsured

Dear all, Fairly new to JMP, so my knowledge is pretty limited. I have a study to find the probability of being uninsured by education background. I have data set with consists of the insurance status (yes/none) and education profile (no high school degree, high school degree, college degree, advanced degree). I need help to perform in JMP or SAS with no high school degree as the reference. I wi...
henggar313

Discussions |
Mar 19, 2021 1:44 PM

2607 views | 5 replies
Tutorial for building 1-click dashboards

Does anyone know of good tutorials for how to build interactive 1-click dashboard using JSL? For example, I would like to build a user interface which allows the user to select an item from a dropdown list and display some sort of visualization charts based on the user selection. Thanks,Simon
simon_2

Discussions |
Mar 19, 2021 1:03 PM

2525 views | 2 replies
Transposing from WIDE to LONG and a formula question

Hi--two somewhat related questionsI have used SPLIT to transform a long file to a wide file, but I have a slightly more complicated situation where I want to STACK/transpose a wide file to a long file. I have a dataset with a unique subject ID, and then several hundred columns/variables. The variable names are the exact same with the exception that Year 1 ends '2', Year 2 ends in '3', etc. Is ther...
plfazeli

Discussions |
Mar 19, 2021 8:16 AM

2169 views | 3 replies

Previous
Next

Latest Discussions

How to calculate probability of being uninsured

Dear all, Fairly new to JMP, so my knowledge is pretty limited. I have a study to find the probability of being uninsured by education background. I have data set with consists of the insurance status (yes/none) and education profile (no high school degree, high school degree, college degree, advanced degree). I need help to perform in JMP or SAS with no high school degree as the reference. I wi...
henggar313

Discussions |
Mar 19, 2021 1:44 PM

2607 views | 5 replies
Transposing from WIDE to LONG and a formula question

Hi--two somewhat related questionsI have used SPLIT to transform a long file to a wide file, but I have a slightly more complicated situation where I want to STACK/transpose a wide file to a long file. I have a dataset with a unique subject ID, and then several hundred columns/variables. The variable names are the exact same with the exception that Year 1 ends '2', Year 2 ends in '3', etc. Is ther...
plfazeli

Discussions |
Mar 19, 2021 8:16 AM

2169 views | 3 replies
CMD window for logging never shows up while using RunProgram

I got an issue while using "RunProgram" to call my exe, a CMD window for logging is supposed to appear, but it never shows up. The CMD window can normally pop up when I manually run it. Is there anyone who can help me solve the issue? Thanks in advance : ) JSL code: RP = Run Program( Executable( exefilepathRoot || "CommonalityEngine\PyScript\get_data_from_cache.exe" ), Opti...
baiyun

Discussions |
Mar 19, 2021 6:54 AM

2201 views | 4 replies
why is last menu hierarchy appears on the left not the right?

How can I get screening design appearing to the right in the above?
0465

Discussions |
Mar 19, 2021 5:00 AM

1260 views | 1 replies
about the project

hi, is it possible to modify a part of the screen in the project: see the image.I would like to put some colors and titles. best regards
Françoise

Discussions |
Mar 19, 2021 4:16 AM

1374 views | 3 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

1445 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

1291 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

1093 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

1401 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

3934 views | 0 replies