From: gretl-users-request(a)lists.wfu.edu Subject: Gretl-users Digest, Vol 87, Issue 8 To: gretl-users(a)lists.wfu.edu Date: Fri, 11 Apr 2014 12:00:05 -0400 Send Gretl-users mailing list submissions to gretl-users(a)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(a)lists.wfu.edu You can reach the person managing the list at gretl-users-owner(a)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(a)ehu.es&gt; Subject: Re: [Gretl-users] Export output to excel or csv To: gretl-users(a)lists.wfu.edu Message-ID: <5347A2AF.4020800(a)ehu.es&gt; 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(a)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/... -------------- 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/... -------------- 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/... ------------------------------ Message: 2 Date: Fri, 11 Apr 2014 10:15:40 +0200 (CEST) From: "Riccardo (Jack) Lucchetti" <r.lucchetti(a)univpm.it&gt; Subject: Re: [Gretl-users] Export output to excel or csv To: Gretl list <gretl-users(a)lists.wfu.edu&gt; Message-ID: <alpine.DEB.2.10.1404111013330.4241(a)ec-4.econ.univpm.it&gt; 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(a)univpm.it http://www2.econ.univpm.it/servizi/hpp/lucchetti ------------------------------------------------------- ------------------------------ _______________________________________________ Gretl-users mailing list Gretl-users(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users End of Gretl-users Digest, Vol 87, Issue 8 ******************************************