Re: st: How do I convert a numeric monthly date into 1jan2000 format for use as an argument to the haver command?

[Aaron Kirkman <ak1795mailserv@gmail.com>]

No, that doesn't work. Haver expects the date in the 01aug2013 format,
so combining your macro declaration with the original code sample
works:

    loc monthn 643
    local month : di %td dofm(`monthn')
    haver use FXAUS using "haver\DAILY.dat", twithin(01jan2013, `month') clear


Aaron


On Mon, Aug 5, 2013 at 2:01 PM, Nick Cox <njcoxstata@gmail.com> wrote:
> Quite so, but your syntax as posted would have led to
>
> loc monthn 643
> loc month `=dofm(`monthn')'
> haver use PCUP using "haver\USECON.dat", twithin(01jan2013, 19571) clear
>
> Would that work even if the data were daily?
>
>
> Nick
> njcoxstata@gmail.com
>
>
> On 5 August 2013 19:45, Aaron Kirkman <ak1795mailserv@gmail.com> wrote:
>> Nick,
>>
>> You're exactly right about the haver command. It expects date
>> constants that match the frequency of the data in question. Running:
>>
>>     haver use PCUP using "haver\USECON.dat", twithin(2012m1,2013m8) clear
>>
>> works as expected. Aside: I wasn't expecting the display command to
>> have any side effects; I forgot to remove it when I reduced my do file
>> to a minimal working example.
>>
>> Aaron
>>
>> On Mon, Aug 5, 2013 at 10:32 AM, Aaron Kirkman <ak1795mailserv@gmail.com> wrote:
>>> Statalist,
>>>
>>> I have a numeric monthly date stored in a macro, i.e.
>>>
>>>     loc currentmonth 643
>>>
>>> for August 2013. Is there a way to convert this month into the format
>>> 01aug2013 for use with the haver command's "twithin" or "tin" option?
>>> Currently, I have this code:
>>>
>>>     loc monthn 643
>>>     loc month `=dofm(`monthn')'
>>>     di %td `month'
>>>     haver use PCUP using "haver\USECON.dat", twithin(01jan2013,`month') clear
>>>
>>> but this returns an r(198) invalid syntax error. If I follow the
>>> documentation and omit the macro:
>>>
>>>     haver use PCUP using "haver\USECON.dat", twithin(01jan2013,01aug2013) clear
>>>
>>> I get the same error. The command works properly if I omit the "twithin" option:
>>>
>>>     haver use PCUP using "haver\USECON.dat",  clear
>>>
>>> What is the proper date format for the haver command, and how do I
>>> convert this numeric date into that format?
>>>
>>>
>>> Thank you,
>>>
>>> Aaron Kirkman
>>> *
>>> *   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/
> *
> *   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/