Welcome to the JMP User Community!

Latest Discussions

• Keeping JMP model predictions positive?

  Is there a way to force JMP to keep a model prediction (for instance, a "reaction time") positive (i.e., above zero)?   I'm wondering if that constraint would help build a more realistic model for my data set.

  imperialpint

  Discussions |

  Jun 18, 2012 4:36 AM

  3953 views | 4 replies

• How to deal with missing data

  Hello,I need to run a descriptive analysis on a huge number of columns. To do so I made the following script :dt = Current Data Table();column_names = dt << Get Column Names(numeric,String);for(i=3,i<=NItems(column_names),i++,  colName = column_names;  cmd = Expr(  ow = dt << Distribution(  Continuous Distribution( Column( cName ) ),  Where( :SEX == "F" )   );  owr = ow<<report; ); Substitute Int...

  hrkg

  Discussions |

  Jun 16, 2012 10:21 PM

  14001 views | 8 replies

• Validate column name exists before graphing

  Hi,  I am trying to validate that a data table contains a certain column name prior to creating graphs:hasname1 = 0;
       for (colval == 1, colval <= Ncols(dt), colval++,
             colName = Column Name(colval);
             if ( colName == "name1",
                   hasname1 = 1;           );
  if (hasname1 == 1,
        //create graph
  );However, the comparison never returns true because "name1" is a string ...

  senatorx

  Discussions |

  Jun 16, 2012 9:26 PM

  8371 views | 2 replies

• Populate new column based on values of another column

  I'd like to do something like an Excel VLOOKUP  ----   where I'd like to populate an empty new column (New_Status) with values from the original column (STATUS) ---  but some of the values need to be translated....   many of the original status entries do not state explicitly that the item is 'Open' but for my purposes they are open.... so I'd like a column that consolidates all the text that mean...

  twaintwist

  Discussions |

  Jun 15, 2012 1:12 PM

  12519 views | 3 replies

• Integer to String data type conversion in JSL

  Hi, This is my first post in the forums.I am attempting to concatenate a number to a string for the purpose of saving a timestamp to an image name like so:ChartName <<  save picture ("file_name" || "date" || ".png", png);However, JSL will not allow the date information to be concatenated because it is an integer and not a string.I gather datetime information  usingyyyy = year(today());hh = hour(to...

  senatorx

  Discussions |

  Jun 13, 2012 5:42 AM

  11790 views | 2 replies