On Mon, 31 Jan 2011, Leon Unger wrote:
In terms of importing data via ODBC I've got another general
obs-format combinded with string (%s) does not work, or to be
crashes immediately! Could someone provide an example for such
The conversion "%s" in an obs-format string requires that the
corresponding variable from the database is of string type. For
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:
This assumes that the pre-existing gretl dataset has observation
strings on the pattern shown above.