> From: gretl-users-request@lists.wfu.edu
> Subject: Gretl-users Digest, Vol 87, Issue 8
> To: gretl-users@lists.wfu.edu
> Date: Fri, 11 Apr 2014 12:00:05 -0400
>
> Send Gretl-users mailing list submissions to
> gretl-users@lists.wfu.edu
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.wfu.edu/mailman/listinfo/gretl-users
> or, via email, send a message with subject or body 'help' to
> gretl-users-request@lists.wfu.edu
>
> You can reach the person managing the list at
> gretl-users-owner@lists.wfu.edu
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Gretl-users digest..."
>
>
> Today's Topics:
>
> 1. Re: Export output to excel or csv (Ignacio Diaz-Emparanza)
> 2. Re: Export output to excel or csv (Riccardo (Jack) Lucchetti)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 11 Apr 2014 10:07:11 +0200
> From: Ignacio Diaz-Emparanza <ignacio.diaz-emparanza@ehu.es>
> Subject: Re: [Gretl-users] Export output to excel or csv
> To: gretl-users@lists.wfu.edu
> Message-ID: <5347A2AF.4020800@ehu.es>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On 11/04/14 09:56, Ignacio Diaz-Emparanza wrote:
> > ..
> > ##########
> > set messages off
> > set echo off
> > matrix B=$coeff
> > scalar ncoefs=rows(B)
> > outfile coefficients.csv --write
> > loop i=1..ncoefs --quiet
> > printf "%.4f, %.4f\n ", B[i,1], B[i,2]
> > endloop
> > outfile --close
> > </hansl>
> >
>
> Sorry, the space after \n should not be there.
>
>
> --
> Firma Arista
> *Ignacio D?az-Emparanza*
> Zuzendaria/Director
> ignacio.diaz-emparanza@ehu.es <mailto:ignacio.diaz.emparanza@ehu.es>
> 94 6013732
> *EKONOMIA APLIKATUA III SAILA (EKONOMETRIA ETA ESTATISTIKA)/
> DEPARTAMENTO DE ECONOM?A APLICADA III (ECONOMETR?A Y ESTAD?STICA)
> UPV/EHU*
> Avda. Lehendakari Aguirre, 83 | 48015 BILBAO
> *T.: +34 946013740* | *F.: +34 946013754*
> *www.ea3.ehu.es* <http://www.ea3.ehu.es>
>
> ERNE! Baliteke mezu honen zatiren bat edo mezu osoa legez babestuta
> egotea. Mezuak badu bere hartzailea. Okerreko helbidera heldu bada
> (helbidea gaizki idatzi, transmisioak huts egin) eman abisu igorleari,
> korreo honi erantzunda. Kontuz! Mezua ez bada zuretzat, ez erabili, ez
> zabaldu beste inori, ez kopiatu eta ez baliatu.
> ?ATENCI?N! Este mensaje contiene informaci?n privilegiada o confidencial
> a la que s?lo tiene derecho a acceder el destinatario. Si usted lo
> recibe por error le agradecer?amos que no hiciera uso de la informaci?n
> y que se pusiese en contacto con el remitente.
>
> E-mail hau inprimatu baino lehen egiaztatu inprimatzeko beharra.
> Antes de imprimir este e-mail piense bien si es necesario hacerlo.
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.wfu.edu/pipermail/gretl-users/attachments/20140411/7d7194ce/attachment-0001.html
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: firma_email_upv_euskampus_bilingue.gif
> Type: image/gif
> Size: 4236 bytes
> Desc: not available
> Url : http://lists.wfu.edu/pipermail/gretl-users/attachments/20140411/7d7194ce/attachment-0002.gif
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: recicla_firma_email_upv.gif
> Type: image/gif
> Size: 225 bytes
> Desc: not available
> Url : http://lists.wfu.edu/pipermail/gretl-users/attachments/20140411/7d7194ce/attachment-0003.gif
>
> ------------------------------
>
> Message: 2
> Date: Fri, 11 Apr 2014 10:15:40 +0200 (CEST)
> From: "Riccardo (Jack) Lucchetti" <r.lucchetti@univpm.it>
> Subject: Re: [Gretl-users] Export output to excel or csv
> To: Gretl list <gretl-users@lists.wfu.edu>
> Message-ID: <alpine.DEB.2.10.1404111013330.4241@ec-4.econ.univpm.it>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Fri, 11 Apr 2014, Ignacio Diaz-Emparanza wrote:
>
> > On 10/04/14 16:14, valentina colombo wrote:
> >> Dera gretl users,
> >> I had estimate my SVAR model and I need to export the estimated
> >> coefficients (bootdata) to excel or csv file. I have tried to use the
> >> following command but it is storing my variables but not bootdata (from a
> >> SVAR).
> >> store /home/valentina/bootdata.csv bootdata
> >> ! gnumeric /home/valentina/bootdata.csv
> >> Any suggestion? I cannot go on with my estimation!!
> >> Thanks
> >> Valentina
> >>
> >
> > For this type of things I use a combination of 'outfile' and 'printf'
> > commands. An example is below. The lines from 'open' to 'var' command are
> > taken from gretl example sw_ch14.in. The result is the file
> > "coefficients.csv" in your current gretl working directory.
> >
> > <hansl>
> > open sw_ch14.gdt
> >
> > # set the robust std errors variant used by S and W
> > set force_hc on
> > set hc_version 1
> >
> > genr infl = 400 * log(PUNEW/PUNEW(-1))
> > diff infl
> > lags d_infl LHUR
> > smpl 1962:1 1999:4
> >
> > # run "automatic" VAR, (see equations 14.5 and 14.6) in Stock and Watson,
> > # "Introduction to Econometrics", chapter 14
> > var 4 d_infl LHUR const -r
> >
> > ##########
> > set messages off
> > set echo off
> > matrix B=$coeff
> > scalar ncoefs=rows(B)
> > outfile coefficients.csv --write
> > loop i=1..ncoefs --quiet
> > printf "%.4f, %.4f\n ", B[i,1], B[i,2]
> > endloop
> > outfile --close
> > </hansl>
>
> Also: don't be fooled by file extensions. If you use the "mwrite" command,
> like Sven suggested, you'll obtain a text file that you can conveniently
> open either in your favourite text editor or in any spreadheet worth
> considering.
>
>
> -------------------------------------------------------
> Riccardo (Jack) Lucchetti
> Dipartimento di Scienze Economiche e Sociali (DiSES)
>
> Universit? Politecnica delle Marche
> (formerly known as Universit? di Ancona)
>
> r.lucchetti@univpm.it
> http://www2.econ.univpm.it/servizi/hpp/lucchetti
> -------------------------------------------------------
>
> ------------------------------
>
> _______________________________________________
> Gretl-users mailing list
> Gretl-users@lists.wfu.edu
> http://lists.wfu.edu/mailman/listinfo/gretl-users
>
> End of Gretl-users Digest, Vol 87, Issue 8
> ******************************************