similar to: use of databases with R?

Some days ago I asked for general methods to access SQL-Databases. Thanks to: Terry Westley [twestley at buffalo.veridian.com], partha_bagchi at hgsi.com, F.Tusell [etptupaf at bs.ehu.es], Michael Lapsley [mlapsley at ndirect.co.uk], Robert Gentleman [rgentlem at jimmy.harvard.edu], Torsten Hothorn [hothorn at statistik.uni-dortmund.de] Several solutions were suggested: (1) using Michael

Here is another of those 'is it a bug or am I using it wrong' questions: I'd be very grateful if someone could help. I am doing a lot of graphs for a thesis at the minute, many of which need (ideally) greek letters in xlab and ylab. This works: >plot(c(1,2,3,4),c(1,2,3,4),xlab=expression( alpha * "-1-m")) > This does not: >

Here is a nasty one: (0.65.1 on linux) > plot(c(1,2,3,4),c(2,4,6,8),log="Y") Segmentation fault (core dumped) [ml at athome ml]$ Seems the bug is in errorcall(). yes, I know the syntax is wrong, but it is an easy mistake to make and it is inconvenient to lose the work space at times. Michael ---------------------------------- E-Mail: Michael Lapsley <mlapsley at

Dear R-helpers, I wonder if I could impose upon you for forther assistance, this time with dataframes: hopefully this will be of general interest, as I personally have found them hard to get to grips with. I was trying to transpose rows and cols and move col1 to the names. Then all sorts of things go wrong. Although the end result looks the same, page() shows the structure to be quite

Can anyone give advice how to interactively exchange data between R and SQL-Databases like DB2, ORACLE, MS-SQL-Server ? If the answer is: 'currently not', this would be information for me as well. I will summarize to the list. Best regards -- Dr. Jens Oehlschl?gel-Akiyoshi MD FACTORY GmbH Bayerstrasse 21 80335 M?nchen Tel.: 089 545 28-27 Fax.: 089 545 28-10 http://www.mdfactory.de

I have recently been introduced to R for win95 and have been impressed by it. It seems to outperform S-Plus greatly. I have had 2 problems. I am using visual basic to automate an analysis. The vis basic routine waits for the creation of a data file then calls R to start the analysis. I have placed the source() command in the rprofile file so it will be run automatically. Output of the

Dear R Gurus, I would very much appreciate some help with this code snippit from my RODBC package. R crashes or exhibits bizarre behaviour when repeatedly fetching large numbers of rows. Examples: > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx 3rd

Dear list, What is the correct approved way to abort a library install if the c fails to build? I am tarting up my odbc library, and I would like to stop the install process if the needed header files and libraries are not present on the system. Error messages flash past so fast that it is easy to miss their significance. Michael ---------------------------------- E-Mail: Michael Lapsley

Would anyone care to comment if this is the best solution to this problem? > trygrep <-function(x,y) + if(grep(x,y)) + print("yes") else + print("NO") > >trygrep("foo","bafoobar") [1] "yes" > > trygrep("foo","bar") Error in if (grep(x, y)) print("yes") else print("NO") : missing value

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

I have just finished a first rough cut of RODBC, a database connectivity addon. In theory it should allow access to any odbc compliant database for which the driver set is installed. On unix this includes MySQL, mSQL and postgres using the unixODBC set. On windows it should include access, sqlserver etc if the odbc drivers are installed. For those who have never taken an interest in this,

Dear developers, I wonder would you consider making a save to a graphics file format (as opposed to ps)? What prompts this is that we have just finished my wife's thesis using R heavily for stats and graphs. The combination of latex, bibtex and R generated .eps worked a treat and we were very pleased with both the final outcome and the efficiency of gernerating it, especially when all the

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

Spoetry is a book on S+ by Patrick Burns available on the net at http://www.seanet.com/~pburns/Spoetry/Spoetry.pdf Its about 439 pages with 16 chapters. You can read all about it at http://www.seanet.com/~pburns/Spoetry/ Michael Lapsley

Dear all, platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status major 1 minor 2.3 year 2001 month 04 day 26 language R I wrote the following to import tables in different database formats (Access, Visual FoxPro, etc.): getTable <-

Full_Name: David Whiting Version: 2.1.0 Under development (unstable) OS: linux Submission from: (NULL) (82.39.106.169) I have just upgraded from a previous version (2.0.0?) and found some of my code that used okay to run now gives an error. The function being called is sqlSave(). I am pretty sure (but not 100% certain) that the data frame I am trying to save has not changed. I am 100% sure that

Dear List, I would like to plot the diagnostic plots for an anova object and the anova table in a single window divided into 5 plotting regions. Plotting the diagnostics is simple engough but is there an easy way to plot the formatted table of an anova object in the fifth plotting region? I am using v1.2.1 on RH7. The code I am using follows: ... aov.objects <-

List Members, I am using R 1.3.1 for windows and trying to capture the output of some summaries using textConnection. I then want to incorporate the text with summary graphics output. The code below works (captures the output) when it is not used in a loop or function. When placed in a loop or function, the cat outputs are captured to 'foo' but the summary outputs are not. The

As I read this, my answers to the other guys don't seem to be delievered to the list, although I sent them nearly 4 hours ago. I fear, I only sent them to the posters and not to the list ... I try to correct this! Sorry! Axel Benz schrieb: > Which name do you want? > varA1 This one resp. the corresponding one in this way (varA2 etc.). > or > fb.12.unt[varA1] > or even then