Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Need help programming for dates in Stata


From   annebroe@gmail.com
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Need help programming for dates in Stata
Date   Tue, 5 Mar 2013 19:38:36 +0000

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index