> On Tue, 16 Jun 2009 13:27:41 -0700, Al <ali6058@GMAIL.COM> wrote: > > >Hi All: > > > >I have an ae dataset in the following way > > > >patno aeterm aesev stdt dsdt TEAE(Dervied) > >1 Headache 1 12JUN08 15JUN08 YES > >1 fatigue 2 11JUN08 15JUN08 NO > >1 Headache 3 17JUN08 15JUN08 YES > > > >I am supposed to create an derived variable TEAE > >where stdt >= dsdt or if the ae event's severity has increased > >after the dose was given .. example:First obs in the above > >example has ae occured prior to date of dose..but the same > >ae (Third obs) severity has increased from 1 to 3 in number. > >so i want 'YES' in column (TEAE --Derived Variable) for both > >first and third obs .. > >How can it be accomplished > > Just as an aside, are you sure? How can the first observation record a treatment emergent AE when the treatment has not yet been administered? Also, it seems to me you may not be giving us the full story - AE datasets usually have both a start date and a stop date (sometimes on the same observation, sometimes on different observations). In the above example, you seem to be telling us that subject 1 had a headache that lasted six days, got worse on the seventh day, and for all we can tell, continues to this day.