Works perfect!  Thank you! ... View more

Hi Dan,   Thanks for your solution. I tried to create a variable with value='Median' then apply it to the Label option..However, the output looks a little ungly. Do do have any way to refine the font of the label? See the attached plot.    Thank you!   ... View more

This is Amazing!  Thank you so much!   One more last question, if I want to use calendar month instead of absolute 30/31 days interval, how should I modify the intnx function?   To make the question more clear, here is the case I am struglling with. If a patient's index date is 9/15/2009, and the treatment date is 3/10/2009. Although the treatment happened a little bit more than 6 month before the index date, 3/10/2009-9/15/2009=-6.2(month). But I still want it to be within pre 6 month and post 6 month (the second flag, not the first flag). In other words, all treatments happended between 3/1/2009-3/31/2009 should be flagged as -6~+6 month. While if another treatment happened on 2/28/2009, it should be assigned to -7 month, although the actual interval is only -6.5...Do you understand what I mean?  Thank you!   ... View more

If I want to calculate calendar month, how to apply this function?   Thanks! ... View more

Actually, I mean calendar month. Thanks.   ... View more

Hi Collinelliot,   Either one of the below data sets is what I desire to get. It can be listing the date or replacing the date by YES flag variables. The first table below is telling, for instance, the patientID=1 does not have any treatment history happenning 6 month before the index date, so the mindate_pre6month is missing or the flag is missing. The patientID=1 has treatment records happened between pre 6 month and post 6 month of index date, and among those records, the miniumen treatment date is 9/30/2008, so the second flag for patient=1 is YES. And I tried your code, it works. It gives me the second table. GREAT!! Thank you. By the way, if I want the first table below, how can I modifiy your code?  Thank you so much! patient ID mindate_pre6month mindate_pre6month_post6month mindate_post6month 1 . 9/30/2008 . 2 1/1/2010 9/30/2010 . 3 12/30/2009 8/1/2011 12/13/2011 4 . 6/8/2009 3/1/2010 … … … … patient ID flag1_pre6month flag2_pre6month_post6month flag3_post6month 1 . yes . 2 yes yes . 3 yes yes yes 4 . yes yes … … … … ... View more

Hi, thanks for your solution.   But I think that's not what I am looking for.   Sorry that I might not describe clearly. Actually, for each patient, I need three flag variables, one is whether or not having treatment date 6 month prior to the index date, the seconde one is whether or not having treatment date within pre 6  month and post 6 month of index date, the third flag is whether or not having treatment date 6 month after the index date. Do you understand what I mean now?  Thank you very much!     ... View more