Thank you. I was working with quarterly GDP and monthly employment data. I wanted to "compact" the monthly employment data to quarterly and estimate a relationship between the two series. I brought the data into GRETL from an ODBC connection from my own access database that scrapes most current data from BLS and BEA. The database servers in GRETL are great but the best I can tell is there is some delay in updating the data. Since I need the most current data available for my application, I built a access database to scrape the government websites and serve as a repository for my data. I've used Matlab applications in the past that allowed workspace variables to have different frequencies and thought GRETL might be the same. Instead of GRETL as my data processing engine, I think it more efficient to do my data processing (compacting etc) in access and create a access data table to be brought into GRETL cleanly. I'm not suck on this concept so if you think it might be efficient for me to do it another way I would love to hear your thoughts. By the way, I have to say how much fun I am having learning GRETL and Econometrics again. Thank you very much for all your efforts. -----Original Message----- From: gretl-users-bounces(a)lists.wfu.edu [mailto:gretl-users-bounces@lists.wfu.edu] On Behalf Of gretl-users-request(a)lists.wfu.edu Sent: Wednesday, September 09, 2009 7:48 AM To: gretl-users(a)lists.wfu.edu Subject: Gretl-users Digest, Vol 32, Issue 13 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: compacting a single variable? (Allin Cottrell) 2. Re: Open .xls files (Henrique) 3. Opening a spreadsheet file (Henrique) 4. Re: Opening a spreadsheet file (Allin Cottrell) 5. Re: Opening a spreadsheet file (Allin Cottrell) 6. Re: Corrgm function (after thinking) (Ofer Cornfeld) 7. Re: Corrgm function (after thinking) (chris) 8. Re: Corrgm function (after thinking) (Ignacio Diaz-Emparanza) ---------------------------------------------------------------------- Message: 1 Date: Tue, 8 Sep 2009 12:59:03 -0400 (EDT) From: Allin Cottrell <cottrell(a)wfu.edu&gt; Subject: Re: [Gretl-users] compacting a single variable? To: Gretl list <gretl-users(a)lists.wfu.edu&gt; Message-ID: <Pine.A41.4.58.0909081256210.1970306(a)f1n11.sp2net.wfu.edu&gt; Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 8 Sep 2009, Mike Pfeiff wrote: single No, that wouldn't make sense: you can't have a gretl dataset in which variables of differing frequencies coexist. But of course you can do: store singlevar.gdt x open singlevar.gdt dataset compact <params> store singlevar.gdt x then reopen singlevar.gdt to get the compacted version of x. Allin Cottrell ------------------------------ Message: 2 Date: Tue, 8 Sep 2009 18:34:01 -0300 From: Henrique <henrique.coelho(a)gmail.com&gt; Subject: Re: [Gretl-users] Open .xls files To: Gretl list <gretl-users(a)lists.wfu.edu&gt; Message-ID: <b3173c600909081434h5cd6bdd7lc3679630823e5880(a)mail.gmail.com&gt; Content-Type: text/plain; charset="iso-8859-1" 2009/9/8 Allin Cottrell <cottrell(a)wfu.edu&gt; I also get correct results using another xls files. I checked my file and it doesn't have this kind of problem. I think my problem is caused by incorrect external links inside my xls file. I fixed it and now everything is working properly. Thanks a lot! Henrique