similar to: R: R: RODBC

I've just uploaded the files Thanks for your attention, Federico Spinazzi spinazzi@databankgroup.it Databank S.P.A Via Spartaco, 19, ITALY Tel. + 39 02 55002251 -----Messaggio originale----- Da: Kurt Hornik <Kurt.Hornik@ci.tuwien.ac.at> A: Federico Spinazzi <spinazzi@databankgroup.it> Cc: r-devel@stat.math.ethz.ch <r-devel@stat.math.ethz.ch> Data: lunedì 18 dicembre 2000

Under which version of R is it supposed to run ? With 1.1.0 under windows NT 4.0 against Access databases it doesn't work, I cannot get the name of the tables, every query I execute returns with "No Data". I'm surely doing something wrong ... Federico Spinazzi spinazzi@databankgroup.it Databank S.P.A Via Spartaco, 19, ITALY Tel. + 39 02 55002251 >Several of you have kindly

Well, I think the better solution would be to put them on the web: I tried to open two web pages but I forget the possword every time :-(. I see 2 quick solutions: - send the files via e-mail - put the files on CRAN (where?); However I can do these in 2-3 days only (I have sources home). Regards, Federico Spinazzi spinazzi@databankgroup.it Databank S.P.A Via Spartaco, 19, ITALY Tel. + 39 02

A trick I use is to give tab-delimited text files created by excel or R the .xls extension: this may apply, and it may be better, to CSV: R couldn't see any difference whichever the extension will be, and windows will be foolished by the .xls extension an will open the file with Excel that will handel it CORRECTLY. If you need to have the data always alligned in Excel and R this trick will

>Functions that handle probability weights and frequency weights (I think >the latter is what you want) are on my To Do list, but they are a long way >off so it would be great if someone else were to handle them. > I never wrote a package for R, but I'm quite fluent in other programming languages. Even if I don't use R from much time I think I can help. I basically need two

Dear R users, I wonder how to weight observationswhen computing statistics and creating tables (e.g. of counts) I'm used to the SPSS paradigm (WEIGHT by foo.) where any subsequent command will weight any variable ... Suppose that I want to compute a table of weighted counts: is the right R-approach to write a little custom function or it could be better to write a new class

Hy you all, Short version: I think I have some code that could be interesting to make the R architecture evolve towards better thread support, easier memory management, better user interface programming (progress bar, logs), powerful debugging without recompiling (hach!) some years ago I start learning C with an ambitious project: write a C library for multivariate data analysis. On the route I

-----Messaggio originale----- Da: Michael Camann <camann at babylon.cnrs.humboldt.edu> A: r-help at stat.math.ethz.ch <r-help at stat.math.ethz.ch> Data: marted? 22 agosto 2000 21.02 Oggetto: [R] various ordinations >Colleagues, > >I'm developing a library of functions for community ecology analyses and >have a couple of questions that I've not been able to answer

I recently set up a samba PDC 2.2.8 for testing purposes only. Everything runs well enough now. There is one thing I can't seem to get to work. I made a logon.bat logon script for sharing a share called 'databank' on T: and it works correctly, but trying to get the windows mount the home folder too results in no mounting. That is: no databank and no home folder (on T: and Y:). My

Gladly and with the help of this list, I have solved my previous problem with Samba as a PDC. My new and improved problem is with the ntusers.ini file. Which seems to be overwritten at each and every login. This creates a problem in that that file lists directories to be excluded and THAT list includes the Local Settings directory. In someone's infinite wisdom, they decided to also keep

I'm looking for data to use with nonparametrics exploration technics. I'm a undergraduate student in statistics at the Unicamp (Brazil), and i've to make a project (with orientation of a professor). I choose nonparametrics statistics to make the project. But in this project i must have to use a databank and present analisys. So, if somebody give me indications where i can find

>For example, > >> cc -I/usr/local/lib/R/include -lmath test.c ??? I guess it should be > cc test.c -I/usr/local/lib/R/include -lmath The order specified for object files (libraries are) on the compiler command line is IMPORTANT to the linker as it searches for symbols from left to right. Hope that helps. Regards, federico

Sorry, I was commenting on the previous windows version (version file says 0.5a) (the first one which ran under RW.1.0.0) I have Win NT 4.0 Service pack 5 and R is > version _ platform Windows arch x86 os Win32 system x86, Win32 status major 1 minor 0.0 year 2000 month February day 29 language R > -----Original Message----- > From: Prof Brian

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

Several of you have kindly sent me examples of bugs in RODBC, but none of them reproduce on my systems. I am fairly sure I know what is happening, and that it is client-specific. (Do empty strings get returned as "", NULL or skipped?) Also, empty character fields were getting mapped to NA. There's a comment in the code that fields need to set to a null string, and that was only

(1) I do read the posting guide (the fact that I missread o missunderstood something does not imply not reading) (2) I could change NAs to 0 (I know) but I have previously (older versions of R and SQL*Plus) used the same select with the "right" output (namely with 0s). (3) AFAIK "strange" is not a negative remark and does not seem to me at the very least but that is always a

I've recently done a lot of re-writing of the internals of RODBC, and have a test version 0.99-6 available. This is a run-up to the release of 1.0. Both the source code and a Windows binary (prepared under rw1062) are available at http:/www.stats.ox.ac.uk/pub/R, and I would appreciate some real users testing this version. It should be more efficient as data frames are transferred to and from

On behalf of Michael Lapsley, who is away. There is a new version of RODBC on CRAN, version 0.8-2. A version compiled for rw1011 will propagate to CRAN tonight. Main differences: - This will work with the up-coming R 1.2.0. - Nulls in databases are handled (more) correctly. The bug that has been reported with repeated entries was it transpires to do with null fields, not empty ones

The first non-maintenance update of RODBC since January 2003 is now on CRAN and will soon propagate to mirrors. From the ChangeLog: * Select the decimal point from Sys.localeconv. * Add an external reference and finalizer so open channels get closed at the end of the session or when there is no R object referring to them. * There is no longer a