In JMP Pro 16.0 I have a table with three columns and multiple rows. The columns are named: ID, Amount and Results. The ID values are Characters whereas the Amounts and Results values are numbers. In some cases the ID is one unique id-code for example 3333. In some cases the same ID for example 3334 is duplicated in several rows and each row has their unique values of Amount and Results.
I would like to create a new table where I would like to include the unique id-codes including the values for Amount and Results. However, if there are duplicate ID-codes I would like to include only ID, Amount and Results with the ID with the lowest value of Amount as well as the Results value.
Would appreciate very much for how I should do that. I am at advanced amateur level and know how to write JSL scripts.
Sincerely yours
Lars Enochsson
Professor of Surgery
Karolinska Institutet
Stockholm,
Sweden
