JMP User Community

Latest Discussions

How to make formula columns stand out

I am trying to update and understand a very large old data set, some of the data comes from other workbooks and some of it is calculated from multiple columns. I would like a way to highlight or otherwise identify columns that are derivatives of other columns vs ones where the data is entered. Is there anyway to do this in JMP? Would also be nice to make some columns into a block. In excel I would...
MostlyHarmless

Discussions |
Jun 24, 2022 12:09 AM

870 views | 2 replies
Enter the file name and save

Hi, I am trying to create a jsl script where the user can type the file name and save as csv. Here's what I tried. Save() doesn't work when I enter the variable exE. Any suggestions?dt = Current Data Table(); current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) ); Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) ); exC = ".cvs"; Nw = ne...
Jackie_

Discussions |
Jun 23, 2022 8:45 PM

981 views | 1 replies
How to Concatenate String over Multiple Rows by Group?

Hello, I have a list of product (> 100) with different product codes of each product. I would like to create new column "Product Code Range" that it concatenates the product code for each product as shown below example. How to write JSL code that can do this task?
Lino

Discussions |
Jun 23, 2022 4:24 PM

2875 views | 6 replies
Questions on RSM

Hello everyone, I have some questions on RSM: I finished my experiments and I want to generate the Response Surfaces now. For example, one looks like this: Q1: I would like to add this graph to a word document, how can I do that? Everytime I do this, the resolution of the axis are very bad and even increasing the font size does not help. Is the only valid method to use the snipped tool? Q2: Whe...
Artaxerxes90

Discussions |
Jun 23, 2022 1:48 PM

1269 views | 3 replies
JMP 16.2 Life Distribution Weibull Distribution Alpha/Beta Generation

I am trying to generate the Weibull Distribution alpha and beta (shape & scale) values of a large data set containing tens of thousands of rows and have those values in a data table. Other than the Analyze > Reliability and Survival > Life Distribution portal is there another way to generate those values?
WoHNY

Discussions |
Jun 23, 2022 12:32 PM

4235 views | 7 replies

Previous
Next

Latest Discussions

How to make formula columns stand out

I am trying to update and understand a very large old data set, some of the data comes from other workbooks and some of it is calculated from multiple columns. I would like a way to highlight or otherwise identify columns that are derivatives of other columns vs ones where the data is entered. Is there anyway to do this in JMP? Would also be nice to make some columns into a block. In excel I would...
MostlyHarmless

Discussions |
Jun 24, 2022 12:09 AM

870 views | 2 replies
Enter the file name and save

Hi, I am trying to create a jsl script where the user can type the file name and save as csv. Here's what I tried. Save() doesn't work when I enter the variable exE. Any suggestions?dt = Current Data Table(); current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) ); Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) ); exC = ".cvs"; Nw = ne...
Jackie_

Discussions |
Jun 23, 2022 8:45 PM

981 views | 1 replies
Questions on RSM

Hello everyone, I have some questions on RSM: I finished my experiments and I want to generate the Response Surfaces now. For example, one looks like this: Q1: I would like to add this graph to a word document, how can I do that? Everytime I do this, the resolution of the axis are very bad and even increasing the font size does not help. Is the only valid method to use the snipped tool? Q2: Whe...
Artaxerxes90

Discussions |
Jun 23, 2022 1:48 PM

1269 views | 3 replies
Exclude data in formula

I found that when a row is Hide and Excluded, the data is still being used by a formula in another column.Here is an example, Column2 formula is Col Maxium (:Coumn 1), row 4 is excluded and hidden, but the data is still being used by the formula in Column 2. How to exclude data from row 4 so that it is not used by the formula in Column 2?
GroupSquareWolf

Discussions |
Jun 23, 2022 12:08 PM

2409 views | 4 replies
Creating statistical custom (formula) function which has byVar

Related to this wish list item I created: Add normalization and robust statistical functions (and matrix functions) . I thought I could just try to write these as custom functions for now (even though I know it will be impossible to share them and have them updated for everyone), but I faced my first problem almost immediately: how to reference columns... When using Custom Formulas am I stuck usin...
jthi

Discussions |
Jun 23, 2022 9:31 AM

1643 views | 5 replies

Previous
Next

Latest Discussions

Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

618 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

484 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

625 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

781 views | 0 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

554 views | 0 replies