On Thu, 8 Aug 2013, Logan Kelly wrote: > Hello, > > I need to delete a series inside a loop. Is there a way to do this? What I am doing is loading data on a country, process the data, save some results, replace the data with the next country's in my data set. Below is my code that does not work: > > loop i = 1..numcountry > cc = strsplit(ccode,i) > append "(a)datafile.xlsx" --time-series --sheet="@cc" --coloffset=0 > --rowoffset=1 > > #Do some stuff > > delete Q* # yields an error > delete R* # would yield an error if previous line did not end loop > > This of course yields the error: > > You cannot delete series in this context > > I understand that delete does not work in a loop, but is there a work around? Or a better way to handle repeated processes? Why not just wrap everything into a function and then call the funciton from within the loop? That will take care of thrashing local variables automatically. ------------------------------------------------------- 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 -------------------------------------------------------

Why not just wrap everything into a function and then call the function from within the loop? That will take care of thrashing local variables automatically.

-----Original Message----- From: gretl-users-bounces(a)lists.wfu.edu [mailto:gretl-users- bounces(a)lists.wfu.edu] On Behalf Of Allin Cottrell Sent: Friday, August 9, 2013 12:45 PM To: Gretl list Subject: Re: [Gretl-users] How to delete a series in a loop? On Fri, 9 Aug 2013, Logan Kelly wrote: > OK. open does not work in a function, so I did not think to try > append. > > So here is my test: > > set echo off > set messages off > set skip_missing off I don't think you want/need "skip_missing off" there, that's just for matrices. > clear > > string datafile ="@workdir\EMU_RAW" > > open &quot;(a)datafile.xlsx&quot; --preserve --sheet=1 --coloffset=0 --rowoffset=1 > > function void opendata(string file, string cc) > append &quot;(a)file.xlsx&quot; --time-series --sheet="@cc" --coloffset=0 > --rowoffset=1 --quiet end function Do you want the --time-series option there? That's just for panel data. > opendata(datafile, "BD") > > This causes Gretl to crash, i.e. Windows error box saying > Gretl32 has stopped working. I am using Win8 64 bit Gretl CVS > (2013-07-21). At what point does the crash occur? I'm trying a a version of this on Linux using dummy data and it's working OK. The xlsx file is attached and the script is below. (BTW, I'm keeping the 64-bit Windows build up to date with CVS, so the file now under windows-testing is today's CVS, which includes a little fix in regard to dates in xlsx files.) <hansl> function series opendata (string fname, string cc) append "@fname" --sheet="@cc" --rowoffset=1 string retv = varname($nvars - 1) return @retv end function set echo off set messages off string datafile = &quot;(a)workdir/test-append.xlsx&quot; open "@datafile" --preserve --sheet=1 --rowoffset=1 print -o series x2 = opendata(datafile, "BD") print -o </hansl> Allin Cottrell

-----Original Message----- From: gretl-users-bounces(a)lists.wfu.edu [mailto:gretl-users- bounces(a)lists.wfu.edu] On Behalf Of Allin Cottrell Sent: Friday, August 9, 2013 1:58 PM To: Gretl list Subject: Re: [Gretl-users] How to delete a series in a loop? On Fri, 9 Aug 2013, Logan Kelly wrote: > set messages off is just there because I cut and pasted out of script > I am working on, so opps;-) > > Before I try your script out I will install the latest build. Do you > think I should uninstall GNUPLOT as well as Gretl before reinstalling? > I still seem to be having issues with the 64 bit version calling > GNUPLOT. Yes, I think that's worth trying. I've rebuilt gnuplot for the 64-bit Windows package since you last tried it (I think). But I'm kinda in the dark as to whether this has made any difference until I can get access to 64-bit Windows myself. If gnuplot doesn't work as called from gretl, could you try starting the 64-bit wgnuplot.exe by itself and see if that works? Thanks. Allin Cottrell _______________________________________________ Gretl-users mailing list Gretl-users(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users

I think the problem is with the GNUPLOT packaged with the 64 bit CVS. I just installed the latest CVS and still no joy with plotting. Also, wgnuplot.exe will not execute.

So I installed and GNUPLOT to C:\Program Files\gretl and then copied the files out of the bin directory to the C:\Program Files\gretl. Now Gretl 64 works great.