JMP User Community

Latest Discussions

Creating column subset based on list which may contain non-existent columns

Hi Users, I read through a prior discussion related to this topic but did not find all the answers.I would like to know how to create a column subset based on a given list of columns. I know that you can easily do this when the columns in the given list exist in the datatable you would like to subset.What I want to know is how do you make the script robust so that it does not give the error that "...
simon_2

Discussions |
Mar 20, 2021 6:41 PM

2198 views | 3 replies
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

2306 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

2451 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

10265 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

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

2451 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

10265 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

2279 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

1922 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

1901 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

1332 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

1185 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

1009 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

1275 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

3675 views | 0 replies