Welcome to the JMP User Community!

Latest Discussions

• 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

  15212 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

  8781 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

  13294 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

  12272 views | 2 replies

• Can you remove all menu items from New Window() ?

  Hello,I'd like to remove all the default menu items from the Window I create when using the New Window() function.I didn't find any documentation on this in the "JMP 10  Scripting Guide" that I'm using to learn JSL.The default menu items have no meaning within my application, and I like to be able to present the users with an uncluttered dialog box.Thanks for your help.Robert 
  

  restonian

  Discussions |

  Jun 11, 2012 6:41 AM

  8822 views | 2 replies