Date: Fri, 24 Dec 2010 03:30:30 -0500 Reply-To: Muthia Kachirayan Sender: "SAS(r) Discussion" From: Muthia Kachirayan Subject: Re: how to solve this senario? In-Reply-To: <201012240711.oBNKSZsl001301@wasabi.cc.uga.edu> Content-Type: text/plain; charset=ISO-8859-1 Try page = int(patient / 4) + 1 ; It assumes that there are 3 observations per patient. On Fri, Dec 24, 2010 at 2:11 AM, Nway wrote: > Hi All, > > I have data like > > patient n > 1 1 > 1 2 > 1 3 > 2 1 > 2 2 > 2 3 > 3 1 > 3 2 > 3 3 > 4 1 > 4 2 > 4 3 > 5 1 > 5 2 > 5 3 > 6 1 > 6 2 > 6 3 > ......so on patient value up to 72 > > i need to create one more variable i.e. page > > if patient in ( 1 2 3) then page=1 > multiple of 3- then we can increase one number in page > > for example > if patient le 3 then page=1 > else if patient le 6 then page=2 so on > > I want output like ...... > > patient n page > 1 1 1 > 1 2 1 > 1 3 1 > 2 1 1 > 2 2 1 > 2 3 1 > 3 1 1 > 3 2 1 > 3 3 1 > 4 1 2 > 4 2 2 > 4 3 2 > 5 1 2 > 5 2 2 > 5 3 2 > 6 1 2 > 6 2 2 > 6 3 2 > > please help me out this... > > Thanks, > NWAY >

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