cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
jstewart
Level I

Creating new column

I am trying to create a column titled >2 Exac from the following example data set.

PatientExac/yr>2 Exac
23411
23421
23451
23411
23510
23510
23510
23631
23611
23611
23611

If any row for a particular patient is greater than or equal to 2 then I want to place a 1 in the new column (>2 Exac) for that patient (for each entry in the database).

If no row for a particular patient is greater than or equal to 2, then I want to place a 0 in the new column for that patient.

What is the easiest way to do this?

1 REPLY 1
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Creating new column

A column formula is easy and will stay updated when adding, editing or deleting rows.

Col Maximum(:Name("Exac/yr"), :Patient) >= 2