Statalist


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

st: Calling local variable in twithin()


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

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)


Thank you for any help in this matter,

Jake

*
*   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