Re: [Gretl-users] gretl interacting with R

I have problem with getting gretl to interact with R. After launching R successfully I should (according to Gretl User's Guide) have a couple of commands being executed automatically (loading the dataset into an R-dataframe). Nothing of the sort happens. Is it a problem with R or gretl (both the latest version of gretl and R otherwise runs perfectly) ? Lars Lars Palsson Syll Professor of Civics Malmo University Sweden 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: ODBC troubles (Allin Cottrell) 2. Re: ODBC troubles (Chris) 3. Re: ODBC troubles (Allin Cottrell) 4. Re: ODBC troubles (Chris) 5. Re: ODBC troubles (Allin Cottrell) ---------------------------------------------------------------------- Message: 1 Date: Wed, 3 Feb 2010 17:20:35 -0500 (EST) From: Allin Cottrell Subject: Re: [Gretl-users] ODBC troubles To: Gretl list Message-ID: Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 3 Feb 2010, Chris wrote: Thanks for persevering! We're making some progress -- you've given me some ideas for making the manual more explicit. As to the specifics: First, on the "obs-format" business: the point of that is if you want to screen the values coming in via ODBC and add only some of them to the dataset. But if your identifiers look like "20070201" and you use "%d" to grab the whole integer value, then _all_ the ODBC values will be screened out (leaving nothing but missing values or NAs in the input series). That's because a string like "20070201" will not match any gretl observation identifier. Note that the gretl obs identifiers are what you see in the leftmost column if you do "print index --byobs" after doing "nulldata" and "setobs". So in this case it looks as if you want a straight one-column import. And I need to research "numeric(7,3)" in mssql and see what I can find. My first thought is that since gretl is asking for SQL_C_DOUBLE, it's the server's fault that it's _not_ giving gretl the values in the C double-precision format. But I'm not an SQL expert and maybe it's not that simple. Jack, any thoughts? Allin Cottrell ------------------------------ Message: 2 Date: Wed, 3 Feb 2010 15:42:29 -0700 From: Chris Subject: Re: [Gretl-users] ODBC troubles To: Gretl list Message-ID: <93b3787f1002031442o6e0bae9ck1b47ea21c167c9ef(a)mail.gmail.com&gt; Content-Type: text/plain; charset="iso-8859-1" Thanks, That straightens out some things for me. http://www.servers.net.in/Servers%20Archive-odbc%20sqlserver%20public%20m... I suspect that is the reason this isn't working. If you have any suggestions on how to get around this I would appreciate it. Thanks, Chris On Wed, Feb 3, 2010 at 3:20 PM, Allin Cottrell wrote: -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.wfu.edu/pipermail/gretl-users/attachments/20100203/02a446a1/... ------------------------------ Message: 3 Date: Wed, 3 Feb 2010 17:51:49 -0500 (EST) From: Allin Cottrell Subject: Re: [Gretl-users] ODBC troubles To: Gretl list Message-ID: Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 3 Feb 2010, Chris wrote: Ah, that reference is helpful. We'll see if we can find a way to work around the bug in question. But I think that has to be in the bowels of gretl's ODBC-import code; I don't think there's any way to work around it at the level of user input. Allin Cottrell ------------------------------ Message: 4 Date: Wed, 3 Feb 2010 15:58:32 -0700 From: Chris Subject: Re: [Gretl-users] ODBC troubles To: Gretl list Message-ID: <93b3787f1002031458o63140865mb4d7ab77877861ea(a)mail.gmail.com&gt; Content-Type: text/plain; charset="iso-8859-1" That's ok. It's about time for a Microsoft product to screw me over again; I was just starting to think Microsoft products were decent and maybe I was wrong to be a linux user at home for the last decade;) If you guys can come up with anything to get me around this I would really appreciate it. As a side note, do you know if anyone is working on updating the import features to allow multiple variable imports? Thanks, Chris On Wed, Feb 3, 2010 at 3:51 PM, Allin Cottrell wrote: -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.wfu.edu/pipermail/gretl-users/attachments/20100203/09f57ac2/... ------------------------------ Message: 5 Date: Wed, 3 Feb 2010 18:35:17 -0500 (EST) From: Allin Cottrell Subject: Re: [Gretl-users] ODBC troubles To: Gretl list Message-ID: Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 3 Feb 2010, Chris wrote: Well, I don't want to start a flamefest here, but I don't see how one could possibly be wrong to use linux. Try the new snapshot at http://ricardo.ecn.wfu.edu/pub/gretl/gretl_install.exe or on sourceforge. Nobody's working on that, that I know of. But it's not too hard to replicate your query string with modification so as to grab as many variables as you need. Allin ------------------------------ _______________________________________________ Gretl-users mailing list Gretl-users(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users End of Gretl-users Digest, Vol 37, Issue 7 ******************************************