Welcome to the JMP User Community!

Latest Discussions

• Linux and Containerization Support

  Hello, I am looking to set up JMP and integrate with SAS 9.4. All our cloud infrastructure is based on Linux and Kubernetes. I am wondering if it is possible to install JMP on Linux or if there are containerized JMP images are available. 

  pizzaguy

  Discussions |

  Dec 18, 2023 4:52 PM

  4028 views | 6 replies

• Can Substitute implement the function of regular substitution?

  For example, replace the column name [20231216] to show that this 20231216 is a variable 8-digit number:  Col1[20231216]、Col2[20231219]For( i = 2, i <= N Col( dt ), i++, ca = Column( i ) << Get Name; cc = Substitute( ca, "[(.{8,})]", "" );//？？ Column( dt, i ) << set name( cc ); );Thanks!

  lala

  Discussions |

  Dec 17, 2023 5:09 AM

  1871 views | 3 replies

• How to import tab-separated text directly into tabular data with the "Import Multiple Files" function?

  I have set this up, but the imported data still cannot be directly tabular.Thanks!Multiple File Import( <<Set Folder( "C:\7\" ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Set Name Filter( "*.*;" ), <<Set Name Enable( 0 ), <<Set Size Filter( {1491, 2610} ), <<Set Size Enable( 0 ), <<Set Date Filter( {3785240875.633, 3785241343.586} ), <<Set Date Enable( 0 ), <<Set Add File Name Col...

  lala

  Discussions |

  Dec 17, 2023 4:53 AM

  2119 views | 4 replies

• JSL to create formula column with variable column names

  Hi,I need to create a new formula column via script using variables for column names and constant.Tried various combinations of Expr, Eval, Parse, Eval Insert for no avail.See sample.Thanksrow = 11; col = "foo"; for (i = 1, i <= ncols(dt), i++, dt << New Column( "ratio " || char(i), numeric, formula(( column(col) - column(col)[row] ) / (Col Max(col) - Col Min(col)))); );

  RonB

  Discussions |

  Dec 17, 2023 12:18 AM

  2136 views | 2 replies

• Loop to find max value for each unique values

  Hi, I am trying to iterate over each values of X and Y and save the max rn value in the MaxValue column.  Here is what I tried but something doesn't seem correct. Any advice?Names Default To Here( 1 ); dt = Current Data Table(); dt << begin data table(); // Loop through rows For( i = 1, i <= N Rows( dt ), i++, currentBarcode = dt:Barcode[i]; // Find the location of the maximum rn value for ...

  Jackie_

  Discussions |

  Dec 14, 2023 10:59 AM

  3110 views | 5 replies