Welcome to the JMP User Community!

Latest Discussions

• Replace missing values with 0

  Hello,I'm trying to replace all missing values in a data table with 0.   The below script doesn't work.  I use JMP 13.  Is there any other way to do this? dt = Current Data Table(); nc = dt << get column names( Numeric ); For( i = 1, i <= N Items( nc ), i++, nc[i][dt << get rows where( Is Missing( nc[i][] ) )] = 0 ); Thanks! 

  nshivan

  Discussions |

  Jan 11, 2023 6:09 AM

  22034 views | 13 replies

• CROSS VALIDATION - VALIDATION COLUMN METHOD

  When using the validation column method for cross validation , we split the data set into training , validation and test sets. This split ratio is specified by the user. Is there any guideline /reference to decide on the split ratio (such as 60:20:20 / 70:15:15 / 50:25:25 / 80 :10:10). Is it chosen also based on the total number of observations -N ?

  sreekumarp

  Discussions |

  Jan 11, 2023 5:31 AM

  6416 views | 10 replies

• Replacing a blank row with another row data with an if statement

  Hi,   I have an original set of data (table1), and I am trying to script it to the result in table 2.  If any number that is below 300, will print "type1" string into "result1" column.  If any number is above 300, will print "type2" string into "result2" column. Numbertype1type2result1result2100a1a2  200b1b2  150c1c2  275d1d2  555e1e2  424f1f2  572g1g2  783h1h2  125i1i2   Table1: Original data   N...

  kuanaunwei

  Discussions |

  Jan 11, 2023 4:58 AM

  1674 views | 3 replies

• Multiple comparisons error

  Hello,   I was wondering if someone who has encountered the same error could help me. I ran a repeated measures ANOVA with unstructured correlation structure and now I want to test for multiple comparisons for those interactions that gave a significant value. However, I am unable to do so because an error message keeps popping up. I'm unsure if I'm doing the analyses wrong. Please help!  

  HotellingWombat

  Discussions |

  Jan 11, 2023 3:24 AM

  1053 views | 2 replies

• Graph builder background map boundary lines disappear

  I am working on a geographic map of South Dakota where I want points of individual fields to show up within each South Dakota County. I turn on the background boundary map for US Counties and they all show up for SD and all other states. I then go to customize and click on Shape: US counties and clip US States shape for South Dakota. However, when I do this the lines around the SD state boundary h...

  Jasclark4

  Discussions |

  Jan 10, 2023 6:05 PM

  1781 views | 2 replies