Welcome to the JMP User Community!

Latest Discussions

• Scripting For loop to multiply values across row

  Hi, I am fairly new to scripting in JMP and have looked through many jmp forums for solutions but haven't been successful in modifying the solutions for my particular problem. I have a script that produces a table of unknown number of columns and want to multiply each value in the row (there is only one row in the table generated) across the columns produced (column 1 * column 2 * column 3* etc). ...

  Cdougz

  Discussions |

  Mar 17, 2021 1:48 PM

  3201 views | 5 replies

• Remove "where(...)" text in report

  When you do something like a bivariate, and you use the Where() command, the JMP output usually has a bit of text "where(:column 1 == 'F') or something
  
  I am doing some scripting and I don't want that text showing up. Is there a way to keep that from happening or to remove it after the fact. Typically i just use the BY() command, but in this instance I want to basically iterate through the BY() leve...

  nathan-clark

  Discussions |

  Mar 17, 2021 1:17 PM

  1701 views | 3 replies

• How to save report as a text file via script?

  Hi all, I have a script to run a logistics regression. I then want to save it as a text file, akin to doing a Ctrl+s with that report open, selecting "txt file" in "Save as type", then saving it. Is there a way to script this last saving part? I've tried Save(), SaveAs(), Save Text File() and none of them seem to work. I'm intending to then use a separate bash script to parse through that text fil...

  jcashida

  Discussions |

  Mar 17, 2021 10:21 AM

  4800 views | 9 replies

• Move data from a row to a column for duplicates, then remove duplicates

  New JMP user here. I know how to do this in Excel, but am not sure how to in JMP. Here 's my dataset:Column1Column 2Column 3Column 4AAA123456ABCPAAA123456ABC210.72AAA234567ABCPAAA234567ABC28.9BBB345678ABCNBBB345678ABC20.01BBB456789ABCPBBB456789ABC221.2 Here's what I want my data to look like:Column1Column 2Column 3Column 4Column 5AAA123456ABCP10.72AAA234567ABCP8.9BBB345678ABCN0.01BBB456789ABCP21.2...

  CMG

  Discussions |

  Mar 17, 2021 6:42 AM

  1688 views | 2 replies

• Weighted Least Squares and Residuals

  Attached is a sample of real estate sales and house sizes.  If you build a model predicting price as a function of size, there is clear evidence of nonconstant variance.  So, I created a weight column to do a weighted least squares regression.  However, the residual pattern never changes - I tried weights = 1/size, then size squared, cubed, etc.  The residual pattern appears exactly the same until...

  dale_lehman

  Discussions |

  Mar 17, 2021 6:00 AM

  3559 views | 2 replies