Welcome to the JMP User Community!

Latest Discussions

• JMP 18 new Update Table script overwrites table

  When importing Excel tables into JMP 18 I get two scripts 'Source' and 'Update Table' script, only difference seems to the an 'Update Table (1)' command. The second script performs an update from the Excel file, and overwrites any columns created after import. Is there a way to make it leave new columns alone when updating? Did not find anything in the Scripting Index.

  Ake

  Discussions |

  Nov 29, 2025 7:35 AM

  1444 views | 3 replies

• Add variable in Graph builder

  I have data table with multiple columns and rows I want to loop through each column and add it to graph builder on x -axis  This is my simple script    dt = Open( filepath ); all_cols = dt << Get Column Names( "String" ); cols_to_plot={}; For Each ({col}, all_cols,            If(col == "A" || col == "B",,                         Insert into (cols_to_plot, col);                ) ); graph = dt << ...

  ravij

  Discussions |

  Nov 28, 2025 11:28 AM

  492 views | 8 replies

• Choice Design for Mode Choice

  Hi everyone, I’m relatively new to SAS JMP, and I’m currently trying to design a discrete choice experiment (DCE) for my research. I need to create a set of choice scenarios where respondents choose between four transportation modes: car, motorcycle, bus, and train. Each mode has different attributes and levels, as shown below: 1. Car Travel time: 40, 60, 80 Travel cost: 45,000; 55,000; 75,000 ...

  Bravoadam18

  Discussions |

  Nov 28, 2025 6:23 AM

  253 views | 3 replies

• Issues with Update() on floating-point EFT values

  I am merging sample-level metadata with time-series raw measurements using Python’s merge_asof and then updating the time-series table in JMP using Update(). Both tables contain columns for time (EFT) and batch ID. The problem: After the Python merge, the resulting table (merged_samples) contains exact matches for some time points and “nearest” matches for others. Python merge handles “nearest” ...

  zetaVagabond1

  Discussions |

  Nov 28, 2025 4:28 AM

  436 views | 9 replies

• How to preserve numeric column types when concatenating tables with empty columns

  Hello,   I have two tables ((imported from csv files initially) that I want to concatenate, each containing only one column, “Column 1” (see screenshot below). In the first table, there is no data; it is empty and of the Nominal character type (defaut, when exporting the csv). In the second table, there is numerical data. When I concatenate the two tables, the final format is nominal character eve...

  SophieCuvillier

  Discussions |

  Nov 28, 2025 2:16 AM

  168 views | 2 replies