JMP User Community

Latest Discussions

How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

I have a large dataset on hand and want to delete all columns whose name contain "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the whole column only contains "." but not empty except the column name. (images are shown below) I did not know how to do this after searching Google and read the JMP manual. Thanks for help on this.
mengzy1974

Discussions |
Mar 12, 2021 12:56 AM

1633 views | 1 replies
How do I create a counting variable based on another column & transpose a table?

Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...
acm

Discussions |
Mar 11, 2021 4:13 PM

1885 views | 1 replies
check if data exist in another table

Hi, I have 2 tables A and B, each has a column "email" and "id". I want to add a new column in table A, if that row has "the same email OR same id" showing up in table B, then "YES", if no then empty. Could someone help me how to write this script? Thank you.
joann

Discussions |
Mar 11, 2021 10:35 AM

4477 views | 7 replies
Variable confounds with residual

Hi, l am attempting to analyse data for an interlab study with a mixed model, its a nested design with 5 variables, the dependant variable is titers, the structure of my analysis is as followsFixed EffectSample (30 of)Random EffectsSample*Lab (3 levels)
Sample*Day (3 Levels)
Sample*Run (2 Levels)
Replicate[Sample,Lab,Day,Run] (replicate has 2 levels)
Sample*Lab*Day l get the error message that Replica...
Mickyboy

Discussions |
Mar 11, 2021 4:02 AM

6419 views | 10 replies
GraphBuilder > FrameBox << Add Graphics Script (V Line (x,y1,y2)): dynamically assign x, y1, and y2?

Hi JMP Community, It's my turn to be stumped by an apparently trivial project. I'm trying to dynamically add V Lines to a Graph Builder plot and I'm getting rather unexpected results with the test script below: Names Default to Here (1); dt = New Table ("TEST", New Column ("X", Set Values ([1,2,3,4,5])), New Column ("Y", Set Values ([3,2,5,8,6])) ); gb = dt << Graph Builder( Fit to Wind...
Thierry_S

Discussions |
Mar 11, 2021 2:16 AM

2685 views | 2 replies

Previous
Next

Latest Discussions

How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

I have a large dataset on hand and want to delete all columns whose name contain "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the whole column only contains "." but not empty except the column name. (images are shown below) I did not know how to do this after searching Google and read the JMP manual. Thanks for help on this.
mengzy1974

Discussions |
Mar 12, 2021 12:56 AM

1633 views | 1 replies
How do I create a counting variable based on another column & transpose a table?

Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...
acm

Discussions |
Mar 11, 2021 4:13 PM

1885 views | 1 replies
BMI percentile calculations

For patients < 18 years of age, their obesity is determined by age, gender specific BMI percentiles . CDC had codes to do this in SAS https://www.cdc.gov/nccdphp/dnpao/growthcharts/resources/sas.htm I am wondering if this is possible to do this in JMP. I currently have to depend on a SAS user to do this for me..
Sandeep123

Discussions |
Mar 10, 2021 3:13 PM

1391 views | 1 replies
Predicting Rainy Days

Hi all! I'm wondering if JMP can help with spot a pattern in the days leading up to rain. If I have years of historical daily (even hourly) environmental data which includes temperature, humidity, pollution, etc, would JMP be able to help spot a pattern leading up to rainy days? If so, what type of analysis would be best suited for a study like this? The "sequential" element is tricky to me, as I'...
gudetama

Discussions |
Mar 8, 2021 12:55 PM

3435 views | 7 replies
JMP script for a user select Y, response columns for Fit Y by X

Hi, I'm trying to write a script that user can select columns for 'Y, response', 'X, Factor', and 'By' for Fit Y by X or Bivariate. I figured out that I can use 'Column Dialog' function to select Y, X, and By using below script. But, I could not write a script to plot Fit Y by X with selected columns. It would be really appreciated if anyone can help to make a full script. Thanks in advance. Reg...
hwchoi0109

Discussions |
Mar 8, 2021 10:41 AM

1107 views | 1 replies

Previous
Next

Latest Discussions

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

1292 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

3941 views | 0 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1158 views | 0 replies

Previous

Welcome to the JMP User Community!

Learning Resources

Latest Discussions

How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

How do I create a counting variable based on another column & transpose a table?

check if data exist in another table

Variable confounds with residual

GraphBuilder > FrameBox << Add Graphics Script (V Line (x,y1,y2)): dynamically assign x, y1, and y2?

Latest Discussions

How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

How do I create a counting variable based on another column & transpose a table?

BMI percentile calculations

Predicting Rainy Days

JMP script for a user select Y, response columns for Fit Y by X

Latest Discussions

Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

Problem specifying model for a partly nested ANOVA design

JMP Events

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration