Date:         Fri, 18 Nov 2011 22:23:16 +0000
Reply-To:     abu zafar muyeen <muyeen70@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         abu zafar muyeen <muyeen70@HOTMAIL.COM>
Subject:      ***Please Help*** New description have been added
Content-Type: text/plain; charset="iso-8859-1"

Hi,

I was not able to
describe my requirement in the first e-mail. Here it is.

- Dataset 1
contain records of different drugs doses and rate by study, PT, Course.

- I want to show 1
record per study, patient course. So, if in the same pt, same course there is
an Agent (IL-2 - With Dose and rate) and  another Agent TLC, then both
have to show in the same row. Means one record per patient. Please see below
the output.

Dataset 1:

STUDY PT  COURSE          AGENT        DOSES      RATE            X10e9

x1      6      2
      IL-2       20
 720


x1      6      2
      TLC

25.27              x1      7
     1           IL-4
   3           720

   x1      7      1
       TIL

 94.600



OutPut should be Like This:

STUDY  PT  COURSE        Cytokine        Doses   Rate     Cells
x10e9

x1      6    2
     IL-2           20
  720      TLC
25.270

x1      7    2
     IL-4           3
   720      TIL
 94.600 **Please forgive me if there any issue with the formatting. I use Please text as editor.