Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: string translation : date & time
From
Abhimanyu Arora <[email protected]>
To
[email protected]
Subject
Re: st: string translation : date & time
Date
Wed, 26 Oct 2011 15:34:09 +0200
Oh, I see. Thank you for clarifying, Nick.
(My bad...using manual for stata 10 [baseyear] and working with stata
11 [topyear].
On Wed, Oct 26, 2011 at 3:25 PM, Nick Cox <[email protected]> wrote:
> No bug here. (-monthly()- does seem to have problems with run-together dates lacking punctuation, not the issue here.)
>
> . l
>
> +--------+
> | var1 |
> |--------|
> 1. | jan-90 |
> 2. | jan-99 |
> 3. | jan-00 |
> 4. | jan-10 |
> +--------+
>
> . gen var2 = monthly(var1, "MY", 2050)
>
> . format var2 %tm
>
> . l
>
> +-----------------+
> | var1 var2 |
> |-----------------|
> 1. | jan-90 1990m1 |
> 2. | jan-99 1999m1 |
> 3. | jan-00 2000m1 |
> 4. | jan-10 2010m1 |
> +-----------------+
>
> For a mix of years that spans a century-end, the third argument must be somewhere in the middle of a century. See -help dates_and_times- for more. The third argument is described in the help as "topyear", and it will typically not be 2000.
>
> Nick
> [email protected]
>
>
> Abhimanyu Arora
>
>> I appended the following command to the earlier ones.
>
>> replace temp=monthly(date,"MY",2100) if yofd(dofm(monthly(date,"MY",2000)))<1920
>
>> While I haven't been able to figure out the explanation still,
>> nevertheless, I am a bit hesitant to cry bug!
>
> Abhimanyu Arora
>
>>> I just got myself in a puzzling situation.
>
>>> I had a variable string variable date taking up values
>>> Jan-90...Jan-99...Jan-00...Jan-01...Jan-10 and so on for different
>>> months.
>>> Making use of the time and date functions I typed the following commands
>>>
>>> gen temp=monthly(date,"MY",2000) *2000 is the base year*
>>>
>>> Subsequently, -format temp %tm - yields for the above months
>>> respectively, 1990m1...1999m1...2000m1...1901m1...1910m1 and so on.
>>>
>>> I an eager to know what could be the possible reason? And possible
>>> rectifying steps (both in terms of the possible commands I used
>>> initially and suppose given the output, into the desired form which is
>>> needless to say is 2001m1, 2010m1 etc?
>
>
> *
> * 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/
>
*
* 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/