I am trying to create a column titled >2 Exac from the following example data set.
| Patient | Exac/yr | >2 Exac |
|---|
| 234 | 1 | 1 |
| 234 | 2 | 1 |
| 234 | 5 | 1 |
| 234 | 1 | 1 |
| 235 | 1 | 0 |
| 235 | 1 | 0 |
| 235 | 1 | 0 |
| 236 | 3 | 1 |
| 236 | 1 | 1 |
| 236 | 1 | 1 |
| 236 | 1 | 1 |
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?
