From cottrell@wfu.edu Fri Feb  4 12:36:24 2011
From: Allin Cottrell <cottrell@wfu.edu>
To: gretl-users@gretlml.univpm.it
Subject: Re: [Gretl-users] import data via odbc
Date: Fri, 04 Feb 2011 12:36:23 -0500
Message-ID: <Pine.A41.4.58.1102041231120.393318@f1n11.sp2net.wfu.edu>
In-Reply-To:
 3233_1296736782_p13Cdfnv006831_4D4AA165.5060000@zedat.fu-berlin.de
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2793322796842150435=="

--===============2793322796842150435==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

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



--===============2793322796842150435==--


From pindar@zedat.fu-berlin.de Sat Feb  5 05:57:50 2011
From: Leon Unger <pindar@zedat.fu-berlin.de>
To: gretl-users@gretlml.univpm.it
Subject: Re: [Gretl-users] import data via odbc
Date: Sat, 05 Feb 2011 11:57:48 +0100
Message-ID: <4D4D2D2C.9020105@zedat.fu-berlin.de>
In-Reply-To: Pine.A41.4.58.1102041231120.393318@f1n11.sp2net.wfu.edu
Content-Type: multipart/mixed; boundary="===============4978589893861236863=="

--===============4978589893861236863==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEgVHJhbnNpdGlvbmFs
Ly9FTiI+CjxodG1sPgogIDxoZWFkPgogICAgPG1ldGEgY29udGVudD0idGV4dC9odG1sOyBjaGFy
c2V0PUlTTy04ODU5LTEiCiAgICAgIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSI+CiAgPC9oZWFk
PgogIDxib2R5IGJnY29sb3I9IiNmZmZmZmYiIHRleHQ9IiMzMzMzZmYiPgogICAgQW0gMDQuMDIu
MjAxMSAxODozNiwgc2NocmllYiBBbGxpbiBDb3R0cmVsbDoKICAgIDxibG9ja3F1b3RlCiAgICAg
IGNpdGU9Im1pZDpQaW5lLkE0MS40LjU4LjExMDIwNDEyMzExMjAuMzkzMzE4QGYxbjExLnNwMm5l
dC53ZnUuZWR1IgogICAgICB0eXBlPSJjaXRlIj4KICAgICAgPHByZSB3cmFwPSIiPk9uIFRodSwg
MyBGZWIgMjAxMSwgTGVvbiBVbmdlciB3cm90ZToKCjwvcHJlPgogICAgICA8YmxvY2txdW90ZSB0
eXBlPSJjaXRlIj4KICAgICAgICA8cHJlIHdyYXA9IiI+QW0gMzEuMDEuMjAxMSAyMTo0Mywgc2No
cmllYiBBbGxpbiBDb3R0cmVsbDoKPC9wcmU+CiAgICAgICAgPGJsb2NrcXVvdGUgdHlwZT0iY2l0
ZSI+CiAgICAgICAgICA8cHJlIHdyYXA9IiI+c3RyaW5nIFEgPSAiU0VMRUNUIGNvdW50cnkseWVh
cix5IEZST00gRm9vQmFzZSIKZGF0YSB5IG9icy1mb3JtYXQ9IiVzOiVkIiBxdWVyeT1RIC0tb2Ri
YwoKVGhpcyBzaG91bGQgd29yayBpZiB0aGUgImNvdW50cnkiIHZhcmlhYmxlIGNvbnRhaW5zIHN0
cmluZwpjb3VudHJ5LWNvZGVzIHN1Y2ggYXMgIkZSQSIsICJHRVIiLCBldGMuLCBhbmQgdGhlIHll
YXIgdmFyaWFibGUKY29udGFpbnMgeWVhcnMgYXMgaW50ZWdlcnM6CgpHRVI6MTk5MCAxMjMuNQpH
RVI6MTk5MSAxMjcuNgoKVGhpcyBhc3N1bWVzIHRoYXQgdGhlIHByZS1leGlzdGluZyBncmV0bCBk
YXRhc2V0IGhhcyBvYnNlcnZhdGlvbgpzdHJpbmdzIG9uIHRoZSBwYXR0ZXJuIHNob3duIGFib3Zl
Lgo8L3ByZT4KICAgICAgICA8L2Jsb2NrcXVvdGU+CiAgICAgICAgPHByZSB3cmFwPSIiPgpJIGNy
ZWF0ZWQgYW4gZW1wdHkgcGFuZWwgZGF0YXNldCB3aXRoIGFwcHJvcHJpYXRlIG9iczp0aW1lCmNv
bWJpbmF0aW9ucyBhbmQgdGhlbiB1c2VkIHRoZSBHVUkgdG8gcmVhZCBpbiB0aGUgb2JlcnNlcnZh
dGlvbgptYXJrZXJzIGZyb20gYSB0eHQgZmlsZS4gSSBrbm93IGhvdyB0byBjcmVhdGUgdGhlICdu
b3JtYWwnIGVtcHR5CnBhbmVsIHZpYSBzY3JpcHQsIGJ1dCBob3cgY2FuIEkgZ2V0IHRoZSBtYXJr
ZXJzIGRpcmVjdGx5IGZyb20Kc2NyaXB0Pwo8L3ByZT4KICAgICAgPC9ibG9ja3F1b3RlPgogICAg
ICA8cHJlIHdyYXA9IiI+CldlbGwsIHlvdSBjb3VsZCBkbyBzb21ldGhpbmcgbGlrZSB0aGlzOgoK
Jmx0O3NjcmlwdCZndDsKc2NhbGFyIE4gPSAzCnNjYWxhciBUID0gMTAKc2NhbGFyIHlyMCA9IDE5
OTAKCnN0cmluZyBzMSA9ICJGUkEiCnN0cmluZyBzMiA9ICJHRVIiCnN0cmluZyBzMyA9ICJHQlIi
CgpzZXQgZWNobyBvZmYKb3V0ZmlsZSBtYXJrZXJzLnR4dCAtLXdyaXRlCmxvb3AgaT0xLi5OIC0t
cXVpZXQKICBsb29wIGo9MS4uVCAtLXF1aWV0CiAgICBwcmludGYgIiVzOiVkXG4iLCBzJGksIHly
MCtqLTEKICBlbmRsb29wCmVuZGxvb3AKb3V0ZmlsZSAtLWNsb3NlCiZsdDsvc2NyaXB0Jmd0OwoK
VGhhdCB3aWxsIGdpdmUgeW91IGEgZmlsZSBjb250YWluaW5nIHRoZSBvYnNlcnZhdGlvbiBtYXJr
ZXJzLiBZb3UKY2FuIGFkZCB0aGVzZSB0byBhIGRhdGFzZXQgdXNpbmcgdGhlIEdVSSAoIC9EYXRh
L09ic2VydmF0aW9uCm1hcmtlcnMgKSwgb3IsIGlmIHlvdSB1c2UgdGhlIGxhdGVzdCBzbmFwc2hv
dCBmcm9tCjxhIGNsYXNzPSJtb3otdHh0LWxpbmstZnJlZXRleHQiIGhyZWY9Imh0dHA6Ly9ncmV0
bC5zb3VyY2Vmb3JnZS5uZXQvd2luMzIvIj5odHRwOi8vZ3JldGwuc291cmNlZm9yZ2UubmV0L3dp
bjMyLzwvYT4gLCB5b3UgY2FuIGFkZCB0aGUgbWFya2Vycwp2aWEgc2NyaXB0IHVzaW5nIGEgbmV3
IG9wdGlvbiB0byAic2V0b2JzIiwgYXMgaW4KCiZsdDtzY3JpcHQgY29udGludWVzJmd0OwpzY2Fs
YXIgTlQgPSBOKlQKbnVsbGRhdGEgTlQgLS1wcmVzZXJ2ZQpzZXRvYnMgVCAxOjAxIC0tc3RhY2tl
ZC10aW1lLXNlcmllcwpzZXRvYnMgLS1sYWJlbHM9bWFya2Vycy50eHQKJmx0Oy9zY3JpcHQmZ3Q7
CgpBbGxpbiBDb3R0cmVsbAoKCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fCkdyZXRsLXVzZXJzIG1haWxpbmcgbGlzdAo8YSBjbGFzcz0ibW96LXR4dC1saW5r
LWFiYnJldmlhdGVkIiBocmVmPSJtYWlsdG86R3JldGwtdXNlcnNAbGlzdHMud2Z1LmVkdSI+R3Jl
dGwtdXNlcnNAbGlzdHMud2Z1LmVkdTwvYT4KPGEgY2xhc3M9Im1vei10eHQtbGluay1mcmVldGV4
dCIgaHJlZj0iaHR0cDovL2xpc3RzLndmdS5lZHUvbWFpbG1hbi9saXN0aW5mby9ncmV0bC11c2Vy
cyI+aHR0cDovL2xpc3RzLndmdS5lZHUvbWFpbG1hbi9saXN0aW5mby9ncmV0bC11c2VyczwvYT4K
PC9wcmU+CiAgICA8L2Jsb2NrcXVvdGU+CiAgICA8Zm9udCBzaXplPSIrMSI+PGZvbnQgZmFjZT0i
Q2FtYnJpYSI+SGkgdGhlcmUsPGJyPgogICAgICAgIDxicj4KICAgICAgICB3b3csIHRoYXQncyBy
ZWFsbHkgbmljZSE8YnI+CiAgICAgICAgSSB0cmllZCBpdCBhbmQgaXQgd29ya3MgZmluZSB3aXRo
IGEgc2xpZ2h0IG1vZGlmaWNhdGlvbiBpbiB0aGUKICAgICAgICBzZXRvYnMgY29tbWFuZDo8YnI+
CiAgICAgICAgPGJyPgogICAgICAgIHNjYWxhciBOVCA9IE4qVDxicj4KICAgICAgICBudWxsZGF0
YSBOVCAtLXByZXNlcnZlPGJyPgogICAgICAgIHNldG9icyBUIDE6MDEgLS1zdGFja2VkLXRpbWUt
c2VyaWVzPGJyPgogICAgICAgIDxiPnNldG9icwogICAgICAgICAgLS1sYWJlbHM9QzpcVXNlcnNc
UGluZGFyXERvY3VtZW50c1xncmV0bFxHUkVUTFxtYXJrZXJzLnR4dDwvYj48YnI+CiAgICAgICAg
PGJyPgogICAgICAgIElmIEkgZG9uJ3QgZ2l2ZSBHUkVUTCB0aGUgcGF0aCwgaXQgZG9lcyBub3Qg
ZmluZCAnbWFya2Vycy50eHQnCiAgICAgICAgYWx0aG91Z2ggaXQncyBpbiB0aGUgZGVmYXVsdCBs
b2NhdGlvbi48YnI+CiAgICAgICAgPGJyPgogICAgICAgIEhhdmUgYSBuaWNlIHdlZWtlbmQ8YnI+
CiAgICAgICAgUGluZGFyPGJyPgogICAgICA8L2ZvbnQ+PC9mb250PgogIDwvYm9keT4KPC9odG1s
Pgo=

--===============4978589893861236863==--