Statalist


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

Re: st: Calling local variable in twithin()


From   Jacob Smith <jsmith@frbatlanta.org>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Calling local variable in twithin()
Date   Tue, 14 Oct 2008 15:06:39 -0400

That worked like a charm, thank you for the help.

And sorry to have those I have offended on the list with my ignorance to 
Stata terminology (local-macro vs variable).

Thanks again,

Jake

Austin Nichols wrote:
> Jacob Smith <jsmith@frbatlanta.org>:
> Try:
>
> local lda: di %td da
> local lfd: di %td fd
>
> instead of
>
> local lda %td da
> local lfd %td fd
>
> since the latter will only work the way you want after -display-.
>
> On Tue, Oct 14, 2008 at 11:14 AM, Jacob Smith <jsmith@frbatlanta.org> wrote:
>   
>> Hi,
>>
>> I have tried to find a solution to how to use a local variable to pass
>> two dates to a twithin() statement.
>>
>> I currently have to pull a date range from a ODBC connection and I am
>> trying to use the dates I retrieve to some information from another
>> information source. If I manually put in twithin(07oct2008, 17oct2008) I
>> have no problems, but I cannot seem to get the contents of a local
>> variable to work within the twithin() option. I have tried with both the
>> double representation of a date as well as a string, and it seems almost
>> any other possible combination with no luck.
>>
>> Currently this is what I am trying to run:
>>
>>
>> clear
>> odbc load, exec("SELECT day, futuredate FROM Table ORDER BY day DESC
>> LIMIT 1") dsn("DSN")
>> scalar da=day
>> local lda %td da
>> scalar fd=futuredate
>> local lfd %td fd
>>
>> clear
>> haver use FLODON FLOD1 FLOD3 FLOD6 FLOD1Y using c:\location\of\file.dat,
>> twithin(`lda' ,`lfd')
>>
>> Here is what my local variables look like:
>>
>> . di `lda'
>> 07oct2008
>> . di `lfd'
>> 17oct2008
>>
>> and when I use the following I have no problem:
>>
>> . haver use FLODON FLOD1 FLOD3 FLOD6 FLOD1Y using
>> c:\location\of\file.dat, twithin(07oct2008,17oct2008)
>>
>>     
> *
> *   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/



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