Welcome to the JMP User Community!

Latest Discussions

• Trying to access data values from a column one-by-one

  Summarize(dt, IDs = by(:ID)); //this finds all the unique IDs in the data file, which we will need For (i=0, i<=N Items(IDs), i++, ID = donorIDs[i];
);the above doesn't work, and throws a Subscript problem in access or evaluation of 'IDs[i]' , IDs[/*###*/i]error. I guess this gets down to some of the fundamentals about how JMP is different from languages like Python and Java, where indexing is ...

  mostarr

  Discussions |

  May 1, 2021 1:19 PM

  990 views | 1 replies

• 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

  2891 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

  2406 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

  2336 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

  4625 views | 4 replies