JMP User Community

Latest Discussions

JMP and SQL queries

Hey guys, I have two related questions that would be great if I'll find a solution to:
1. is there a way that JMP can alter a field in SQL query? I mean that I wish to run JSL code that will ask from a user the date range (for example), it will update it into the relevant field in my SQL query and will run this query. 2. Is it possible to create JSL code that will ask from the user if to run X que...
Stas

Discussions |
Mar 22, 2021 12:16 AM

2804 views | 2 replies
JSON to data table: how to avoid NULL columns being automatically dropped?

Hi All, I'm using JMP 15 and have JSL that retrieves a JSON payload via Http Request(), runs it through Char to Blob(), and then open()s it in a data table. The JSON payload content is dynamic, but is always mappable to a tabular format (rows and columns). The issue: if any keys in the JSON have all NULL values, they are not included in the data table (i.e., no columns are created for these keys)....
andykpdf

Discussions |
Mar 21, 2021 2:19 PM

9166 views | 6 replies
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

2431 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

2648 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

2810 views | 3 replies

Previous
Next

Latest Discussions

JMP and SQL queries

Hey guys, I have two related questions that would be great if I'll find a solution to:
1. is there a way that JMP can alter a field in SQL query? I mean that I wish to run JSL code that will ask from a user the date range (for example), it will update it into the relevant field in my SQL query and will run this query. 2. Is it possible to create JSL code that will ask from the user if to run X que...
Stas

Discussions |
Mar 22, 2021 12:16 AM

2804 views | 2 replies
JSON to data table: how to avoid NULL columns being automatically dropped?

Hi All, I'm using JMP 15 and have JSL that retrieves a JSON payload via Http Request(), runs it through Char to Blob(), and then open()s it in a data table. The JSON payload content is dynamic, but is always mappable to a tabular format (rows and columns). The issue: if any keys in the JSON have all NULL values, they are not included in the data table (i.e., no columns are created for these keys)....
andykpdf

Discussions |
Mar 21, 2021 2:19 PM

9166 views | 6 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

2810 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

10898 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

2607 views | 5 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