Welcome to the JMP User Community!

Latest Discussions

• Using current date (TODAY() as macro variable entry for naming a dataset (scripting)

  I would like to use TODAY() to derive the current date and use it as a timestamp in naming a  JMP dataset, and as a TIME_STAMP column as well. In SAS, it may look like this (I admit I neglected the formatting a bit).   %let TODAYDATE=today(); data WORK.CLASS_&TODAYDATE. ; set SASHELP.CLASS; TIME_STAMP = &TODAYDATE.  ; run ; After resolving, the result should look like this : "WORK.CLASS_20190628"...

  Newbie2Jumpie

  Discussions |

  Jun 28, 2019 1:15 AM

  2962 views | 2 replies

• JSL - Replacing Column Values with Vector

  I'm attempting to script a function that replaces a range of column values with a vector of equal dimension. My code below either rejects the argument entirely or just changes the entire cell value to the vector, rather than spanning the range. I can imagine creating a "for loop" that would iterate through each row and and index the vector accordingly, but writing one value at a time seems ineffic...

  EDW

  Discussions |

  Jun 27, 2019 12:08 PM

  2609 views | 1 replies

• JSL - Adding a Table to a Journal

  Another JSL question, I'm trying to put a table in Journal using JSL.  Here is what I am trying to do: current_data_table << New Data View; // Creating the Journal nw = New Window("Journal Right Here", <<Journal, ob = Outline Box("Section 1", Text Box("Some description that we need here.", << Markup), Current Journal()[TableBox(current_data_table)] ) );Everything seems to be...

  drblove

  Discussions |

  Jun 27, 2019 7:10 AM

  23095 views | 14 replies

• How to look up data and create new column based on nearest match?

  I have sample data in table sample1 and the look up table efficiency( please find attached both the tables). I want to find the closest match of data column in table sample1 with resplect to IOUT column in look up table efficiency. Based on the nearest match I want to populate efficiency column in table sample1 in accordance with look up table:Below is the code I am trying
  /* Open a sample data tab...

  jojmp

  Discussions |

  Jun 27, 2019 6:05 AM

  2395 views | 2 replies

• Appending element to a list value inside an associative array

  Hi, I am trying to add an element into an associative array where the value is a list and the element needs to be added into the list inside associative array.Eg:cary = ["high schools" => {"Cary", "Green Hope", "Panther Creek"}, "population" => 116244, "state" => "NC", "weather" => "sunny"]; In this,1. How can I add a new entry to "high schools" list?2. How do I convert the "weather" value to list...

  dileepkr

  Discussions |

  Jun 27, 2019 2:27 AM

  7326 views | 2 replies