Re: st: Function MONTHS

[Nick Cox <njcoxstata@gmail.com>]

Note that the format of a variable does not define its character.
Indeed I could go

sysuse auto
format mpg %td

and Stata would not complain, but nothing would change except a
display format and no spell can change something like -mpg- that is
not a date into something really a date.

That said, we understand that you have two daily date variables in which case

mofd(date1) - mofd(date2)

returns an integer value for the number of months between two dates.
Note that small details disappear and (for example) the number of
months can be a coarse measure of the difference between daily dates

. di mofd(mdy(5,30,2013)) - mofd(mdy(5,1,2013))
0

. di mofd(mdy(5,1,2013)) - mofd(mdy(5,30,2013))
0

If you want something else more precise you would need to start with
the difference in days and then proceed from there.

I don't know what the function you name in Epi Info does exactly.


Nick
njcoxstata@gmail.com


On 30 May 2013 14:09, carmen gamarra <carmengamarra@hotmail.com> wrote:
> hi people  help me
>
> I would like to generate a newvar in my
> stata database to using two oldvar in format
> date (DDMMYYYY), I
> would like the newvar returns the number
> of months (time) between
> <date1> and <date2>.
>
> How can I achieve this function in stata? In epi-info I get that with
> this function:
>
> DEFINE newvar
> ASSIGN newvar =MONTHS(date1, date2)
>
> thank you
> Carmen Gamarra
> *
> *   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/