similar to: RODBC install unsuccessfully

Hi, I'd like to pass a string to a function as the value of the argument. Here is my code. However, it doesn't work. Please help me with this. Thanks, Yu-Ling Wu ----------------------------------------------------- library(RODBC) odbcConnect("console") -> myConnect fun1 <- function(dd1) { h3 <- sqlQuery(myConnect, "select * from console where byday =

Hi, I have a set of script like this: ---------------------- summary(data) plot(time, users, type="o", xlab ="Time", ylab="Number of Users") ---------------------- I type "rterm --slave < script.r > output.doc" and the graphic doesn't actually in the output.doc file. How to make the graphic embedded in Word or Excel file? Thanks, Yu-Ling Wu

Hi, I have a data set look like this: ================================= Fruit Quty apple 20 banana 10 orange 17 apple 30 apple 15 orange 26 banana 15 .........and so on .......... ================================= The level of fruit is 30, that is, there are 30 different fruits. I'd like to compute some simple statistics for each different fruit and get output like this:

Thanks! This is helpful. Three more questions. 1. How to convert a string into a numeric value. For example, convert '20010122' to 20010122. 2. How to convert a string into a date value. For example, convert 20010122 to 2001 Jan 22, and get its day of the week, i.e. Monday? 3. How to handle date variables in a loop? How to make the following codes work? And how users should pass the

Hi all, Does anybody know the easiest way to import excel data into R? I copied and pasted the excel data into a txt file, and tried read.table, but R reported that Error in read.table("data_support.txt", sep = " ", header = T) : more columns than column names Thanks! Ling

Hello, I am having a problem compiling R versions 1.6.1 or .16.2 on a Solaris 8 machine. It sees to have problems with an X11 module. Here is the relevant output: make[4]: Entering directory `/pkg-ling/src/R-1.6.2/src/modules/X11' gcc -I. -I../../../src/include -I../../../src/include -I/pkg/X11R5/include -I/usr/local/include -DHAVE_CONFIG_H -fPIC -g -O2 -c dataentry.c -o dataentry.lo

Hello. I have found a number of posts/threads on this subject and remain unsuccessful to determine the solution. In brief, my situation is: 1. Running FreeBSD 4.9 Stable in x86 2. Installed, and running, R 1.8.1 3. Installed, and running, postgreSQL 7.4.2 4. Installed, and running, unixODBC 2.2.8 5. Failed, repeatedly, to install RODBC. The following is my error log: tsunami# R CMD

Hello, I contact you after having unsuccessfully asked my question to R mailing list. I use the package RODBC to connect to a MS-SQL server. I am able to getQuery from the database. I am now studying the sqlSave some data into the database. Unfortunetly, I meet some issues relating to the format of the data that arrives into the database. I have three columns. The first one should be in the

R-help, I wish to replace NULL elements(or missing) in the following list : > z2 $cod mean sd 62.56190 12.65452 $haddock mean sd 36.61490 11.50365 $ling mean sd 86.17949 20.43587 $saithe mean sd 50.275847 5.453606 $whiting NULL $"norway pout" mean sd 13.739623 1.393104 $"great silver smelt" mean

Dear all, I'm trying to install lme4 (after having installed R 2.4.0 from source, and having installed the latest Matrix package). lme4 fails with the following message: pedigree.o definition of _lme4_xSym in section (__DATA,__common) pedigree.o definition of _lme4_ySym in section (__DATA,__common) make: *** [lme4.so] Error 1 ERROR: compilation failed for package 'lme4' ** Removing

Hi all, I try to install the RODBC to no avail. Where is sql.h and sqltext.h supposed to come from? I don't have such files anywhere on my hdd! After downloading latest RODBC.tar.gz, I do R CMD INSTALL RODBC and get the following: * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C

In the example below, from http://www.ling.upenn.edu/~joseff/rstudy/summer2010_ggplot2_intro.html I'd like to make (a) the fitted line thicker and (b) change the background fill color for the confidence envelope around each fitted line to a low-alpha transparent version of the same color used for the separate fitted lines for GENDER, rather than grey for both. How can I do this?

Hi all, I've got at really basic Q for you all: How do I produce a 3D plot in R? Like the one in the screenshot on the R-project wab-page. What is the command? /Fredrik -- ----------------------------------------------------------------- Fredrik Karlsson, Research Student Department of Philosophy and Linguistics Ume? University S-901 87 UME? SWEDEN Tel: +46 90 786 56 84 Web:

I'm trying to load Affy Annotation data from an Access database into R using RODBC. This has worked fine for quite some time. The bug seems to be correlated to RODBC versions 1.1-7 and later. Works fine: R 2.2.0 with RODBC 1.1-4; R 2.3.0 or R 2.4.1 with RODBC 1.1-6 Fails: R 2.3.1 with RDOBC 1.1-7; R 2.4.1 with RODC 1.1-7 or 1.1-8 Details ===== This works fine: Version 2.2.0

Hi Johannes and Dirk: A Divendres 27 Juny 2008 17:05, Johannes Ranke va escriure: > Hi, > > I just added RODBC to the list of packages maintained for the Debian > etch backports on CRAN. The r-cran-rodbc packages are on their way to > CRAN - if you want them now, you can use > > deb http://chem.uft.uni-bremen.de/r-cran etch-cran/ > > as an alternative. Thank you

> On Jun 20, 2016, at 9:19 AM, Spencer Graves <spencer.graves at prodsyse.com> wrote: > > "R CMD check sos" with R 3.3.0 under Mac OS X 10.11.5 ends as follows: > > > >* checking package dependencies ... ERROR > >Package suggested but not available: ?RODBC? > > > >The suggested packages are required for a complete check. >

Hi, Please excuse these questions if they're obvious. I'm new to R. I need to access a Postgres db from R. I'm currently trying RODBC as I spend part of my time on Windows and rdbi.pgsql seems not to support windows at this time. I unzipped the RODBC win binary download into my library directory and tried to load it using library(RODBC) I get the following error: Error in

Full_Name: Emmanuel Charpentier Version: R 1.1.1 OS: Windows 98 FE / Linux (Debian 2.2) Submission from: (NULL) (164.2.255.244) This bug report is pro forma. I've already reported it informally on R-help and R-devel. The current (0.7) version of RODBC has a problem with missing values. It correctly gets missing "character" values (as blanks), but puts the last non-missing value of

Hi, I have an ext3 file system created with -T largefile4 option. Now it is running out of inode but it's only about 10% full. - Is there a way now to increase the number of inode without making a new file system? - If not, I am thinking about shrinking the file system, and then use the free up space to create a new file system with more inodes, and move the data over. Since I am

On Sun, May 27, 2012 at 11:32 AM, Michael <comtech.usa@gmail.com> wrote: > Help! The R Console very quietly closed and exited without giving any > errors/warnings...after I loaded the RODBC library... > > Loading required package: RODBC > > > > > On Sat, May 26, 2012 at 10:27 PM, Michael <comtech.usa@gmail.com> wrote: > >> Hi all, >> >>