Welcome to the JMP User Community!

Latest Discussions

• Help with this simple script of fit y by x

  Hello. I try to study the relationship of a quantitative variable with multiple quantitative variables. I wrote this script but it doesn't work. I show you the script and the error message. Thank you in advance. Script Names Default To Here(1); dt = Current Data Table(); numericColNames = dt << get column names(string, numeric); For(i = 38, i <= N Items(numericColNames), i++, Bivariate(Y(:Name("E...

  gallardet

  Discussions |

  Oct 8, 2023 9:38 AM

  2476 views | 6 replies

• How to get non-duplicate column names from the "leaf label formula" of decision tree model?

  For example, use the following JSL to get the Leaf Label Formula.Extract the column names from the formula in the first 10 rows.Thanks!d0 = Open( "$SAMPLE_DATA/Equity.jmp" ); p=Partition( Y( :BAD ), X( :LOAN, :MORTDUE, :VALUE, :REASON, :JOB, :YOJ, :DEROG, :DELINQ, :CLAGE, :NINQ, :CLNO, :DEBTINC ), Validation Portion( 0.3 ) ); p<<go;Wait(2); p << save leaf label formula;

  lala

  Discussions |

  Oct 7, 2023 8:02 AM

  1262 views | 3 replies

• for each group find out which value is missing in a specific column, then create a new row with the missing value for that group with 0 in the count column as a corresponding value for that row

  I have 4 columns in the mock data set (File attached below). The column "Companys" is grouped by column "Month-Year" and "State". Each "Companys" column value is associated to a value in column "Sectcor". I want find what values are missing in each group of Month-Year and State Column for example Sector "DK" has Companys "C" and "D" Associated to it but for group Jan-2021, CA we have 2 rows associ...

  j0rg

  Discussions |

  Oct 6, 2023 1:54 PM

  1357 views | 1 replies

• Change Single Bar Color

  Hi All, I have a seemingly simple question that I cannot find the answer to. I have made a bar graph and would like to custimze the each bar graph fill color individually. The graph is cost on y axis and car make on x axis, with each car make having two years. The reason is I have a general fill color depending on the year (2017&2018), but would like to highlight certain car make a different color...

  GERblob

  Discussions |

  Oct 6, 2023 1:20 PM

  11163 views | 3 replies

• Name Unresolved: Column name will not resolved when I specify it as a value in a list

  I am trying to calculate the AUC for each column in a data table. I am collecting all of the column names into a list "colNamesList", and retrieving each column name in Fit Model inside a For loop by incrementing the list subscript. However, the call to the array is not resolving inside the Fit Model call.  If I include show(colNamesList[i]) on a separate line, it resolves fine, just not inside th...

  ond_stats

  Discussions |

  Oct 6, 2023 11:54 AM

  2837 views | 3 replies