Re: st: getting Stata to understand the format of the dates

[Jeph Herrin <stata@spandrel.net>]

This will produce a date variable:

 gen edate1=date(dates,"MDY")
 format edate1 %td

and if you want the month

 gen emonth1=mofd(edate1)
 format emonth1 %tm

Then, you would declare your data time series data:

 tsset emonth1


hth,
Jeph


On 2/5/2013 1:10 PM, Tzaloupas Dimitrov wrote:
> Dear all,
>
> I have a column with this date format
>
>
>   dates
> 01/07/2009
> 01/08/2009
> 01/09/2009
> 01/10/2009
> 01/11/2009
> 01/12/2009
> 01/01/2010
> 01/02/2010
> 01/03/2010
> 01/04/2010
> 01/05/2010
> 01/06/2010
> 01/07/2010
>
>
> HOw can i get stata understand that this is a time series data set of monthly observations?
>
> I tried something like
>
> gen edate1 = monthly(dates, "DMY")
>
> but it seems that it does not work
>
> Any suggestions?
>
> I use 64 bit Stata 11
>
> thanks
>
> *
> *   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/