Re: [Gretl-users] Question about join
On Tue, 9 Dec 2014, Logan Kelly wrote:
Thanks Allin, here is an example:
string frequency = "q"
#join "gretl_tmp_3785.csv" out --tkey="obs,%Y@frequency%@frequency"
--aggr="avg" --data="ENU2705340010"
join "gretl_tmp_3785.csv" out --tkey="obs,%Yq%q"
--aggr="avg" --data="ENU2705340010"
Both join commands yields the same error. Attached is the csv file (also pasted below).
obs, ENU2705340010
2013q4, 1209
2013q3, 1163
2013q2, 1142
2013q1, 1276
2012q4, 1239
2012q3, 1135
2012q2, 1123
2012q1, 1278
Thanks, Logan. Now what does the "inner" dataset look like before
you try the join? For comparison, here's an example I just tried:
I open data9-7.gdt (quarterly data 1975:1 to 1990:4) and then I try
using join on the following data file, named "import.csv":
obs x
1980q1 1
1980q2 2
using this script:
<hansl>
open data9-7.gdt
join import.csv x --tkey="obs,%Yq%q"
print QNC x -o
</hansl>
This works as expected, showing values 1 and 2 for "x" in quarters
1980:1 and 1980:2 respectively.
Allin