Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

st: merging in data directly from ODBC sources


From   László Sándor <sandorl@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: merging in data directly from ODBC sources
Date   Sat, 9 Feb 2013 23:21:43 -0500

Hi all,
I am working with many-many ODBC tables, with many different variables
but sharing a common identifier. Is there a quicker way to build
datasets of variables corresponding to the identifier than loading
each table separately, saving it in Stata format, and then merge over
these Stata files?

I found no such use in the help file, so I am afraid this does not
exist. Would it require anything in ODBC/SQL, or Stata would need to
be smart with such a merge, which is just not implemented?

Thanks,

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


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