Flagging records that have two flags

[BTAinRVA]

I have a table with patient info that has two flag variables, app_flag which indicates the patient had a diagnosis for appendicitis within 30 days of an appendectomy procedure, and chronic_flag which flags those patients that had a diagnosis of a chronic disease within 180 days of an appendectomy procedure. This table will have multiple records for a patient and the two flags may occur in different records. What I want is a table with one row per patient with the two flag variables indicating if they have ever had the flag in any of their records. It is now coming to mind as I write this that maybe a Proc SQL select distinct patid and summing the flag variables (as they are coded 0 and 1).

Any thoughts?

[GreggB]

This article has an example of creating a data set with one observation per subject from a data set that has multiple obs per subject.

http://www2.sas.com/proceedings/sugi24/Advtutor/p48-24.pdf

[BTAinRVA]

Thanks! That is great stuff.