On Mon, 31 Jan 2011, Leon Unger wrote:
In terms of importing data via ODBC I've got another general
question
myself:
obs-format combinded with string (%s) does not work, or to be
precise, GRETL
crashes immediately! Could someone provide an example for such
string indices?
The conversion "%s" in an obs-format string requires that the
corresponding variable from the database is of string type. For
example:
string Q = "SELECT country,year,y FROM FooBase"
data y obs-format="%s:%d" query=Q --odbc
This should work if the "country" variable contains string
country-codes such as "FRA", "GER", etc., and the year variable
contains years as integers:
GER:1990 123.5
GER:1991 127.6
This assumes that the pre-existing gretl dataset has observation
strings on the pattern shown above.
Allin Cottrell