Date: Tue, 27 Jan 2009 09:31:40 -0800
Reply-To: "Norris, Paul" <Paul.Norris@UCSF.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Norris, Paul" <Paul.Norris@UCSF.EDU>
Subject: Probably an embarrassingly simple question
Content-Type: text/plain; charset=us-ascii
I have a dataset that looks like the following:
PatNo Asthma DM DF
1 0 1 0
1 1 0 0
2 0 1 0
2 1 0 0
2 0 0 1
I want to get it down to one line per patient where each condition which
is present in any record has a 1.
PatNo Asthma DM DF
1 1 1 0
2 1 1 1
In other languages, I would do this with a WHILE statement on the PatNo.
Help would be greatly appreciated for how to do this in SAS.
Paul Norris
UCSF
|