Welcome to the JMP User Community!

Latest Discussions

• Principal component regression

  Hello - I have been working with and using PCA in JMP for about four years now. Nothing fancy, but I feel very comfortable with a lot of the functionality. I've been using the PCs as factors for DoE, thinking I was some kinda smartie and came up with a new use case for PCA. Low and behold, I stumble across a Wikipedia page last week on principal component regression. Ha.
  
  Anyway, I have looked and l...

  ehchandlerjr

  Discussions |

  Feb 16, 2024 8:25 AM

  3926 views | 9 replies

• Combine Date Column and Time Column to "DateTime"

  Hi, I imported data from the .xls file. There is a "Date" column and "Time" column. I have to create a new column with Date Time Combine.I used below formula Date MDY( Month( :Date ), Day( :Date ), Year( :Date ) ) + (Hour( :Time ) * 3600 + Minute( :Time ) * 60 + Second( :Time )) Some rows the output is off by roughly 1 minute but some rows are correct.  How Can I fixed this?

  yanee

  Discussions |

  Feb 15, 2024 9:42 PM

  2016 views | 3 replies

• Visualizing 2-way clustering

  Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...

  ehchandlerjr

  Discussions |

  Feb 15, 2024 2:53 PM

  583 views | 0 replies

• Script for multiple data tables/ Workflow

  Hi everyone,  I am relatively new to JMP and especially to scripting in JSL. I am looking for a way to apply a existing script to all currently open data tables (imported via multiple files import). Even though I researched through the abundance of community threads about this topic, I was not able to piece together a working solution. Okay, so I have the following working JSL code (note: embedded...

  Gab_K

  Discussions |

  Feb 15, 2024 7:30 AM

  1033 views | 1 replies

• Save data as Excel file and immediately open it on the computer

  HelloI would like to save data in an Excel file and open itI have written the command at the end of the scriptI see JMP saved the data as well, but don't open the file in Excelwhat I have missed in JSL? dt_excel = dt_p << Save( "C:\Users\dburmist\Downloads\Bucket.xlsx" );
  dt_excel = dt_p << open( "C:\Users\dburmist\Downloads\Bucket.xlsx" );

  Dennisbur

  Discussions |

  Feb 15, 2024 7:23 AM

  1035 views | 2 replies