Date: Fri, 30 Oct 2009 05:39:20 -0400
Reply-To: Shaik Hymad <hymadsk@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Shaik Hymad <hymadsk@GMAIL.COM>
Subject: how can solve this senario?
Hi To All,
I have a data like, each subject having 8 visits i.e 2 to 9
*****************************
PATID VISIT returned dispensed
01S1003 2 . 90
01S1003 3 50 50
01S1003 5 9 90
01S1003 6 6 90
01S1003 7 4 90
01S1003 8 0 90
01S1003 9 6 90
01S1006 2 . 90
01S1006 3 56 .
01S1006 4 . .
01S1006 5 . .
01S1006 6 . .
01S1006 7 . .
01S1006 8 . .
01S1006 9 . .
01S1007 2 . 90
01S1007 3 56 56
01S1007 4 11 90
01S1007 5 20 90
01S1007 6 22 90
01S1007 7 4 90
01S1007 8 19 90
01S1007 9 11 90
the number of dispensed and returned capsules
each subject how much taken capsules
Taken=dispensed-return
i want output like each subjects taken total of returned and dispensed and
taken
PATID retuned dispensed taken
01S1003 75 600 525
