LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2009, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page