JMP User Community

Latest Discussions

Adding x number of days to a Character Date column (dd-Mon-YYYY)

I have a JSL script that periodically pulls data from an Access database. The access database contains a date column "Available Date" with a dd-Mon-YYYY (E.g., 12-APR-2018) format. What I am trying to do, is create a new column "Target Date" in JMP that adds x number of days to the date in "Available Date" for each row. For example: In the image below, the Target date is equal to Available date +...
DanAlexander

Discussions |
Mar 18, 2021 12:25 PM

4924 views | 3 replies
How do I extract only the text that is between quotation marks

I have a column containing 1000's of Machine Error Codes which are typed in by an operator at the machine.Most of the errors do not have quotation marks but for those that do I would like to be able to extract what is between the quotation marks.For other special characters I can use the escape character but I'm having problems using this with the quotation marks.Thanks in advanceFiona Example 1: ...
fionaweston

Discussions |
Mar 18, 2021 10:11 AM

2986 views | 2 replies
Create a log-space vector

All-I am new to JSL and I want to know if there is an easy way to create a log-space vector--similarly to the function in MATLAB or Numpy.Thanks. -Alvaro
a_betancourt

Discussions |
Mar 18, 2021 9:18 AM

1456 views | 1 replies
Concat data in multiple text files with no headers

I have about 500 text files that I need to combine. All of them have no headers. The values are separated by comma as below. (the format is the same for all files) 122,3410732003,,ABC2,P
122,3410732003,,ABC2I,13.6
122,3410732020,,ABC2,P
122,3410732020,,ABC2I,4.13 So when I try to use the import multiple files option in JMP with csv settings, it warns me that there will be 500 data tables generated.An...
CMG

Discussions |
Mar 18, 2021 6:31 AM

2271 views | 3 replies
How to rename columns from a list all at once

If I have a data table set up as below

Col1Col2Col3Col41ae202bf213cg22
and a list of strings for new column names
NewCols = { "Data1", "Data2", "Data3", "Data4"}

How can I write a script to rename the columns of the data table all once using the list New Cols such that it results in the following data table?Data1Data2Data3Data41ae202bf213cg22

user8421

Discussions |
Mar 18, 2021 5:50 AM

7155 views | 3 replies

Previous
Next

Latest Discussions

How to explore the baseline level effect on response size (i.e. CFB)? Is fit model the right tool in JMP?

Hi All, We have a test that compared the benefit (data reading, numerical data) of two different treatments over a couple of time points (baseline, T1, T2, etc). There are also some other effects: test sites, gender, etc.For primary objective, I used the "Fit model" and put the data reading as Y, treatment, baseline level, time point, gender, subject ID(random factor), some 2-factor interactions i...
Diana

Discussions |
Mar 17, 2021 8:07 PM

2072 views | 2 replies
Incorporating measurement error into Dunnetts analysis

I want to start incorporating my measurement error into my dunnetts analysis. I have attached a file below which has two variables which I am trying to determine if they are different. Both variables were tested 3 times and each test was measured 3 times. Since I am trying to determine if the variables are different in the past I've always just averaged all 3 measurements and used as the value ...
wyler0

Discussions |
Mar 17, 2021 3:23 PM

2534 views | 4 replies
How to save report as a text file via script?

Hi all, I have a script to run a logistics regression. I then want to save it as a text file, akin to doing a Ctrl+s with that report open, selecting "txt file" in "Save as type", then saving it. Is there a way to script this last saving part? I've tried Save(), SaveAs(), Save Text File() and none of them seem to work. I'm intending to then use a separate bash script to parse through that text fil...
jcashida

Discussions |
Mar 17, 2021 10:21 AM

5298 views | 9 replies
Prüfung von Residuen auf Normalverteilung (Diagramm Normalquantile)

Hallo, ich habe über DoE einen Versuchsplan erstellt und möchte diesen jetzt auswerten. Bei der Modellanpassung möchte ich natürlich prüfen, ob die Residuen normalverteilt sind. Dazu habe ich mir im Modell-Fenster das "Diagramm der Residuen-Normalquantile" anzeigen lassen. Zusätzlich habe ich die Residuen als Spalte gespeichert und mir diese über "Verteilungen" als Histogramm anzeigen lassen. Hier...
Al24

Discussions |
Mar 16, 2021 8:31 AM

2622 views | 3 replies
Selecting a test to determine when to end an experiment?

We have an experiment testing a population's response to a chemical with three sampling points in time. The measurements at these time points are the dosage with a significant effect on the test population. I want to know if the measurements at the first and last time points (middle time point too) are normally equal or different. It would save money to end the experiment at sampling point 1 if t...
joemama985

Discussions |
Mar 16, 2021 6:32 AM

5605 views | 10 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

1403 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