Re: st: Need help programming for dates in Stata

[annebroe@gmail.com]

replace startdate = mdy(01,01,1900) if startdate == . 
Gen used_2009 = 0
Replace  used_2009 = 1 if startdate>=mdy(01,01,2009) & stopdate<= mdy(12,31,2009)

Do the same for each Newvar

Anne 

Den 05/03/2013 kl. 18.43 skrev Michael Stewart <michaelstewartresearch@gmail.com>:

> Hi
> 
> I have a list of start and stop dates for medications
> I am trying to find if there is way to classify  them to specifically
> say if they are used in particular years
> 
> Med  Start date    Stopdate
> xxx    11/12/2009    11/12/2012
> yyy      .               1/2/2010
> zzz    1/1/2009      .
> 
> 
> I want to create four  variables Used_2009   used_2010    used_2011
> used_2012
> 
> The criteria is
> 1)If medication is  used even for a day in a year, it is considered to
> be used for that year
> 2)If the start date is blank, then it is deemed to be used from a much
> prior day
> 3)If ending date is blank/missing then  that medication is currently active
> 
> -- 
> Thank you ,
> Yours Sincerely,
> Mike.
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/