Re: [Gretl-users] import data via odbc
On Fri, 11 Mar 2011, Leon Unger wrote:
Hi there,
recently I tried to read in several series via odbc including one dummy series and I
forgot to change its entries
from "No" and "YES" to "0" and "1".
However, SQL retrieved for all series the correct number of observations. BUT ALL SERIES
were corrupted.
That's why two thoughts come up:
1) I know from importing STATA files that GRETL changes string entries to number entries.
Does GRETL use
information
provided by the STATA file, or does it this job by itself? If yes, would it be possible
to add this functionality
to the odbc read in process?
2) If one has always to provide numerical entries and e.g. one series is not correcltly
specified then actually
only this series should be corrupted.
Of course everything is doable with enough time and resources. I also
agree that automagic conversion of stuff coming from an ODBC connection
would be very cool. However, the development of gretl is something that
very few people do in their spare time. I don't mean to be rude, but
asking the user to put a little extra care in formulating an SQL query
doesn't sound unreasonable to me (especially considering that the user did
not have to pay a single penny for the program).
Riccardo (Jack) Lucchetti
Dipartimento di Economia
Università Politecnica delle Marche
r.lucchetti(a)univpm.it
http://www.econ.univpm.it/lucchetti