Re: [Gretl-users] import data via odbc

On Thu, 3 Feb 2011, Leon Unger wrote: > Am 31.01.2011 21:43, schrieb Allin Cottrell: >> 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. > I created an empty panel dataset with appropriate obs:time > combinations and then used the GUI to read in the oberservation > markers from a txt file. I know how to create the 'normal' empty > panel via script, but how can I get the markers directly from > script? Well, you could do something like this: <script> scalar N = 3 scalar T = 10 scalar yr0 = 1990 string s1 = "FRA" string s2 = "GER" string s3 = "GBR" set echo off outfile markers.txt --write loop i=1..N --quiet loop j=1..T --quiet printf "%s:%d\n", s$i, yr0+j-1 endloop endloop outfile --close </script> That will give you a file containing the observation markers. You can add these to a dataset using the GUI ( /Data/Observation markers ), or, if you use the latest snapshot from http://gretl.sourceforge.net/win32/ , you can add the markers via script using a new option to "setobs", as in <script continues> scalar NT = N*T nulldata NT --preserve setobs T 1:01 --stacked-time-series setobs --labels=markers.txt </script> Allin Cottrell _______________________________________________ Gretl-users mailing list Gretl-users(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users