Statalist


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

Re: st: dates and Stata


From   "Olexandr O. Vasetsky" <ovasetsk@ucalgary.ca>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: dates and Stata
Date   Sat, 30 May 2009 00:37:15 -0600 (MDT)

Keith,

it is a brilliant idea - it never occurred to me to use a loop cycle to
shuffle through the days one by one! thank you!

Olex




> Maybe like this?
>
> cap prog drop datecount
> prog datecount
>     args month day start end
>     loc month=upper(substr("`month'",1,3))
>     scalar datecount=0
>     forval d=`=d(`start')'/`=d(`end')' {
>         loc thismonth=upper(ltrim("`:di %dm `d''"))
>         if "`month'"=="`thismonth'" & `day'==day(`d') scalar
> datecount=datecount+1
>     }
>     di as result datecount
> end
>
>
> datecount sept 15 28jan1997 17sep2002
> 6
> datecount Feb 2  28jan1997 17sep2002
> 6
> datecount february 29 28jan1997 17sep2002
> 1
>
>
> Regards,
> kd
>
>
>
> Olexandr O. Vasetsky wrote:
>> Hi guys,
>>
>> I am trying to calculate the number of certain day and month
>> occurrences
>> between the two dates: e.g. calculating the number of September 15th's
>> and
>> February 2nd's from 28-Jan-1997 to 17-Sept-2002.
>>
>> any ideas will be appreciated
>>
>>
>
> --
> Dr Keith Dear
> Senior Fellow
> National Centre for Epidemiology and Population Health
> ANU College of Medicine, Biology and Environment
> Building 62, cnr Mills and Eggleston Roads
> Australian National University
> Canberra ACT 0200 Australia
>
> T: 02 6125 4865
> F: 02 6125 0740
> M: 0424 450 396
> W: nceph.anu.edu.au/Staff_Students/staff_pages/dear.php
>
> CRICOS provider #00120C
> http://canberragliding.org/
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>
>


-- 
Sincerely,

Olexandr Vasetsky
Graduate student
Department of Economics
University of Calgary

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



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