Welcome to the JMP User Community!

Latest Discussions

• How to select a subset of columns and rows from a data table

  I have done a Google search and come across the top hits, things like https://www.jmp.com/china/support/help/13-2/JSG_DataTables_21.shtml and How to select rows based on multiple criteria? but nothing specifically states how to select both columns and rows in the same line of code. I tried it and doing one seems to interfere with the other. Or is there a way to store the output of the first step (...

  mostarr

  Discussions |

  May 1, 2021 11:37 AM

  2887 views | 1 replies

• How to Save Queried Data Table to a Specified Folder through script?

  Hi! Does anyone here knows how to save a queried data table to a specified folder through jmp script? Can't seem to find the right way in doing it... Thanks in advance!Here's my sample script:Data Table( "name of data table" ); //save raw data table to a folder dt = current data table (); filepath = "C:\Users\folder path"; dt<< save(filepath || "name of data table.jmp");

  ramisola

  Discussions |

  May 1, 2021 5:30 AM

  2404 views | 2 replies

• extracting month

  Hello, I have a column containing a timestamp in the following format:Jan-01Feb-01 How can I use formula to parse the month so that it would return:JanFeb I tried month(:Name("My-Column")) but it is giving me a red squiggly line.  Thank you so much for your help!

  aprilmayjune

  Discussions |

  Apr 30, 2021 1:10 PM

  2335 views | 3 replies

• How to Identify Unique Values in a Column from a Data Table (to a Scripting Newbie)

  Assuming I am familiar with programming languages in general, but not the syntax of JMP/JSL specifically, please understand that when I looked up JSL: get unique values of a data table column and Get a list of the unique values in a column, matrix, or list none of the solutions worked for me when I try to find a summary of the unique values in a column scriptorially (not via Recode). The reason fo...

  mostarr

  Discussions |

  Apr 30, 2021 10:58 AM

  4621 views | 4 replies

• How to use JSL to classify and summarize the data in the middle of the matrix branch, and get the summary results in the form of matrix?

  For "Big Class.jmp", the "height" and "weight" columns are written into the matrix.
  Then the data in rows 6 to 35 of the matrix are classified and summarized: the average weight of each height is summarized.This result only needs to be stored in the in-memory matrix. Thanks Experts!I wonder if this is possible?dt=Open("$SAMPLE_DATA/Big Class.jmp"); ar=dt<<GetAsMatrix({4,5}); Summarize(ar[6::35,0],e...

  lwx228

  Discussions |

  Apr 30, 2021 10:21 AM

  2940 views | 4 replies