JMP User Community

Latest Discussions

Report Automation on numerous variables based on certain requirements

Greetings,I am a newbee to JMP and used it mainly for exploring my data by drag and drop. Now I have QC report that I believe may require JSL codes. The report requirements and design are as follows:Data Source: SQL Tables, SAS, or CSV (data are available in these three formats)Data Sets: There are more than 100+ Tables or data setsData Sets relationships: There are two common fields in each Table...
helalmob

Discussions |
Mar 20, 2021 5:38 PM

2311 views | 2 replies
Seperating year by Quarters

I am trying to seperate the year by quarters using dates. I was looking at documentation and it gave the extract function.EXTRACT( datepart, datetime, )I am not sure how quiet to use it, my idea is if data is between Jan 1st and March 28th its Q1 etcI could use if (Jan1st <:Date< Jan1st + In Weeks( 13 ), "Q1", Jan1st + In Weeks( 13 )+ In Days(1) <:Date< (Jan1st + In Weeks( 13 ...
jearls11

Discussions |
Mar 20, 2021 11:06 AM

2460 views | 3 replies
Capturing degradation fit parameters to table?

How do I capture reliability degradation fit parameters to table? The four bolded lines are the crux of what I am trying to do. Fitting the degradation and then simply capturing the fit parameters in a column. Script below: Degradation( Y( :current ), Time( :time ), Label( :DUT ), Application( Repeated Measures Degradation ), Connect Data Markers( 1 ), Show Fitted Lin...
galactus3000

Discussions |
Mar 20, 2021 4:23 AM

10275 views | 11 replies
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

2618 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

17355 views | 9 replies

Previous
Next

Latest Discussions

Seperating year by Quarters

I am trying to seperate the year by quarters using dates. I was looking at documentation and it gave the extract function.EXTRACT( datepart, datetime, )I am not sure how quiet to use it, my idea is if data is between Jan 1st and March 28th its Q1 etcI could use if (Jan1st <:Date< Jan1st + In Weeks( 13 ), "Q1", Jan1st + In Weeks( 13 )+ In Days(1) <:Date< (Jan1st + In Weeks( 13 ...
jearls11

Discussions |
Mar 20, 2021 11:06 AM

2460 views | 3 replies
Capturing degradation fit parameters to table?

How do I capture reliability degradation fit parameters to table? The four bolded lines are the crux of what I am trying to do. Fitting the degradation and then simply capturing the fit parameters in a column. Script below: Degradation( Y( :current ), Time( :time ), Label( :DUT ), Application( Repeated Measures Degradation ), Connect Data Markers( 1 ), Show Fitted Lin...
galactus3000

Discussions |
Mar 20, 2021 4:23 AM

10275 views | 11 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

2295 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

1937 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

1913 views | 4 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

1337 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

1192 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

1014 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

1279 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

3682 views | 0 replies