Hi Allin's suggestions seems like a good one since knowing the starting period is not necessary. Thanks all for the help. Walt On 9/17/2012 8:32 AM, gretl-users-request(a)lists.wfu.edu wrote: > 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. extracting month number (Data Analytics Corp.) > 2. Re: extracting month number (Riccardo (Jack) Lucchetti) > 3. Re: extracting month number (Annaert Jan) > 4. Re: extracting month number (Riccardo (Jack) Lucchetti) > 5. Re: extracting month number (Ignacio Diaz-Emparanza) > 6. Re: extracting month number (Ignacio Diaz-Emparanza) > 7. Re: extracting month number (Allin Cottrell) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 16 Sep 2012 12:19:38 -0400 > From: "Data Analytics Corp." <walt(a)dataanalyticscorp.com&gt; > Subject: [Gretl-users] extracting month number > To: gretl-users(a)lists.wfu.edu > Message-ID: <5055FC1A.1020007(a)dataanalyticscorp.com&gt; > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi, > > I have a monthly time series of the Dow Jones Industrial Index beginning > 1928:10. I'd like to create a new variable that is just the month > number: 10, 11, 12, 1, 2, 3,.... How can I do this? I thought there > would be a month function in Gretl, but I don't see one. This question, > of course, extends to the year (1928, 1928, 1929, 1929,...) and quarter > if I have quarterly data. > > Thanks, > > Walt > > ________________________ > > Walter R. Paczkowski, Ph.D. > Data Analytics Corp. > 44 Hamilton Lane > Plainsboro, NJ 08536 > ________________________ > (V) 609-936-8999 > (F) 609-936-3733 > walt(a)dataanalyticscorp.com > www.dataanalyticscorp.com > _____________________________________________________ > > > > ------------------------------ > > Message: 2 > Date: Sun, 16 Sep 2012 22:40:23 +0200 (CEST) > From: "Riccardo (Jack) Lucchetti" <r.lucchetti(a)univpm.it&gt; > Subject: Re: [Gretl-users] extracting month number > To: walt(a)dataanalyticscorp.com, Gretl list <gretl-users(a)lists.wfu.edu&gt; > Message-ID: <alpine.DEB.2.02.1209162239370.15098(a)ec-4.econ.univpm.it&gt; > Content-Type: text/plain; charset="iso-8859-15" > > On Sun, 16 Sep 2012, Data Analytics Corp. wrote: > >> Hi, >> >> I have a monthly time series of the Dow Jones Industrial Index beginning >> 1928:10. I'd like to create a new variable that is just the month >> number: 10, 11, 12, 1, 2, 3,.... How can I do this? I thought there >> would be a month function in Gretl, but I don't see one. This question, >> of course, extends to the year (1928, 1928, 1929, 1929,...) and quarter >> if I have quarterly data. > Does this help? > > <hansl> > open bjg.gdt > series year = 1949 + floor((t-1)/12) > series month = 1 + ((t-1)%12) > </hansl> > > -------------------------------------------------- > Riccardo (Jack) Lucchetti > Dipartimento di Economia > > Universit? Politecnica delle Marche > (formerly known as Universit? di Ancona) > > r.lucchetti(a)univpm.it > http://www2.econ.univpm.it/servizi/hpp/lucchetti > -------------------------------------------------- > > ------------------------------ > > Message: 3 > Date: Mon, 17 Sep 2012 05:45:05 +0000 > From: Annaert Jan <jan.annaert(a)ua.ac.be&gt; > Subject: Re: [Gretl-users] extracting month number > To: Gretl list <gretl-users(a)lists.wfu.edu&gt; > Message-ID: > <F194DC2C2D2F4140AC6D295D5AA1F3CB0131B7635C(a)xmail30.ad.ua.ac.be&gt; > Content-Type: text/plain; charset="iso-8859-1" > > Very compact, as always. But it wouldn't work for a dataset with weekly or daily frequency, would it? > Jan Annaert > UNIVERSITEITANTWERPEN | Faculty of Applied Economics (TEW) | Dept. Accounting & Finance > Room S.B.335 | Prinsstraat 13 | B-2000 Antwerp | Belgium > Phone +32 32654163 |Fax +32 32654064 > http://www.ua.ac.be/jan.annaert > http://ssrn.com/author=143473 > > From: "Riccardo Lucchetti (Jack)" <r.lucchetti@univpm.it<mailto:r.lucchetti@univpm.it>> > Reply-To: "r.lucchetti@univpm.it<mailto:r.lucchetti@univpm.it>" <r.lucchetti@univpm.it<mailto:r.lucchetti@univpm.it>>, "gretl-users@lists.wfu.edu<mailto:gretl-users@lists.wfu.edu>" <gretl-users@lists.wfu.edu<mailto:gretl-users@lists.wfu.edu>> > Date: zondag 16 september 2012 22:40 > To: "walt@dataanalyticscorp.com<mailto:walt@dataanalyticscorp.com>" <walt@dataanalyticscorp.com<mailto:walt@dataanalyticscorp.com>>, "gretl-users@lists.wfu.edu<mailto:gretl-users@lists.wfu.edu>" <gretl-users@lists.wfu.edu<mailto:gretl-users@lists.wfu.edu>> > Subject: Re: [Gretl-users] extracting month number > > On Sun, 16 Sep 2012, Data Analytics Corp. wrote: > > Hi, > > I have a monthly time series of the Dow Jones Industrial Index beginning > 1928:10. I'd like to create a new variable that is just the month > number: 10, 11, 12, 1, 2, 3,.... How can I do this? I thought there > would be a month function in Gretl, but I don't see one. This question, > of course, extends to the year (1928, 1928, 1929, 1929,...) and quarter > if I have quarterly data. > > Does this help? > > <hansl> > open bjg.gdt > series year = 1949 + floor((t-1)/12) > series month = 1 + ((t-1)%12) > </hansl> > > -------------------------------------------------- > Riccardo (Jack) Lucchetti > Dipartimento di Economia > > Universit? Politecnica delle Marche > (formerly known as Universit? di Ancona) > > r.lucchetti@univpm.it<mailto:r.lucchetti@univpm.it> > http://www2.econ.univpm.it/servizi/hpp/lucchetti > -------------------------------------------------- >