Welcome to the JMP User Community!

Latest Discussions

• How to center columns in Tabulate?

  Hello All! I am a fairly new user and would love to know if we can center the columns when we are using the "Tabulate" function.  I have tried:- highlighting/right clicking- adjusting the properties to "center"- looking at the format settings- input "center" into the "Set Format( Uniform Format ( 10, 1 ) )" and adding ",center"- looking at my overall JMP preferences-->Tables  Thank You!

  Maerawlings

  Discussions |

  Sep 27, 2022 2:30 PM

  1472 views | 2 replies

• update table using JSL without adding missing columns

  I'm trying to update the values of a specific column in a data table using values in another data table. The update function seems like the logical choice but it always seems to add extra unmatched columns to the updated table. From the update utility there is an option for this However there isn't any mention of this in either the scripting index or in the help search. I've tried     dt << upda...

  tom_e_dunn

  Discussions |

  Sep 27, 2022 2:04 PM

  15318 views | 3 replies

• use a value to find the correct column to use in a formula

  Hi,I have a summary table where I'd like to create a new column 'Rate' with a formula. The column MAXRESULT gives the name of the column I want to use in the formula. unfortunately, I'm getting 'missing arguments' error when I create the formula based on column name.Column 'Rate' formula: (100 * Column Name( Parse( "N(" || Char( :MAXRESULT ) || ")" ) )[]) / :N Rows  What's wrong ? 

  cyrilmichelland

  Discussions |

  Sep 27, 2022 7:16 AM

  1449 views | 5 replies

• stepwise regression on nonlinear data

  Hi,  I have a datasets with a research question: Is X contributing additional variance in Y in addition to Age? Based on the data, Age account for significant variance in both X and Y, but the relationship is nonlinear (When Age increase, Y decrease exponentially, and X increase exponentially). So when I fit Y by X (using 0 degree correlation), the relationship between X and Y looks linear. So to ...

  yuhanmc

  Discussions |

  Sep 27, 2022 6:17 AM

  861 views | 1 replies

• Datatable indexing Problem within a Formula

  I am trying to apply the log10 function to an entire column within a data table.  The result will be in a new column with a new name.  The new column and name are generated by I get an error in the formula portion.  Below are the results of the script and the error message.   This is the script:   Names Default To Here(1); dt = As Table(J(5, 5, Random Uniform()), <<column names({"X1", "X2", "X3"...

  RayOq

  Discussions |

  Sep 27, 2022 3:46 AM

  881 views | 2 replies