similar to: Package creation - require statement?

Hi, I am trying to run the command: R CMD INSTALL -l mypath mypackagename from within R (Windows XP) using system() and get the following error: ARGUMENT 'CMD INSTALL -l D:/R/JMB.LIBS jmb.test' __ignored__ Fatal error: you must specify '--save', '--no-save' or '--vanilla' My function contains these 3 lines: setwd("D:/R/R.pkgs") # path to files set

I am using the following: library(RODBC) chan = odbcConnectExcel("rats-lda") rats.lda = sqlFetch(chan, "data") close(chan) And getting the following error message: > library(RODBC) Error in library(RODBC) : there is no package called ?RODBC? > chan = odbcConnectExcel("rats-lda") Error: could not find function "odbcConnectExcel" > rats.lda =

How can I have SQL queries (ODBB/Windows) return dates (cf text) for date columns? I can successfully query and ODBC database with R. I can subsequently convert the text representations of dates in columns using as.POSIXxx functions but I figured there must be a way to achieve this at the time of the query. Any tips? paul

Buenas: A ver si te puede servir: 1.- Creo que ROBDC sólo corre en la versión de 32-bits, no en la de 64-bits. Para ello: 1.1 En R-Studio -> Tools -> Global Options -> General -> Change -> 1.2 Elegir version de 32-bits 1.3.a) Para que se produzca el cambio -> seleccionar la versión de 32-bits que elijas, -> aceptar ?botón OK-, ->

Ya he visto como hacerlo: conexion<-odbcConnect("rx") Pero pense que podria elegir luego la bd que yo quisiera. Entiendo que de esta manera la base de datos siempre se tiene que llamar igual y estar en el mismo sitio, si no quiero andar modificando de nuevo la conexion con Windows. ¿Verdad? Gracias Jesús ________________________________ De: Jesús Para Fernández

I am receiving an error when trying to connect to the Oracle Database using RODBC on a 64-bit Windows Server OS. The version of R is 2.10.0-win32.exe Is this the wrong version. Does RODBC only work with 32-bit ODBC drivers? 've read over all the posts and documentation manuals. The system is Windows Server 2003 with R 2.81. and the latest downloadable RODBC package. The Oracle SID/DSN is

Dear All, I want to compare formulas resulting from using stepAIC() on glm() objects. I have 2 different formulas, say F1 and F2, which consist of about 10 factors (Y~A+B+C+...) but one has an interaction term (A:B) while the other doesn't. But when I perform F1==F2 it comes back as TRUE. Is there a proper way to compare formulas? ------------------------------------------- Jeffrey M

Hello, I want to plot 3 boxplots [ par(mfrow=c(3,1)) ] but the first one has 8 groups, the 2nd has 7 and the third has 6. But I the groups to line up: 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 3 4 5 6 7 8 where the numbers actually refer to years. I suspect I have to manipulate the function bxp(). Is there a relatively simple way to do this? Thanks for any help. Jeff Breiwick NMFS, Seattle

De todas formas prueba a realizar la conexión de forma manual desde RStudio. Las últimas versiones (o al menos la Preview) incluyen una pestaña "Connections" con la que a través de un Wizard puedes configurar conexiones, entre ellas a ODBC y una de las opciones es "MS Access". Saludos, Carlos Ortega www.qualityexcellence.es El 31 de agosto de 2017, 12:11, Francisco Rodríguez

Hi, I am using R 2.3.0 and my .First() file has the following line which causes a warning: attach(what="c:/r/jmb/.RData", pos=3) I get the following message after .First() is loaded: During startup - Warning message: use of NULL environment is deprecated Is there a simple fix that will eliminate this warning message? Thanks. J. Breiwick

Hello, I have a workspace that contains a number of functions I want to put in a library. Under R 1.9.0 I did this fairly easily by putting them in a R folder, creating a DESCRIPTION & TITLE file etc. I could then load my library successfully. Under R 2.0.0 this simple process apparently no longer works. I have used package.skeleton() and have run R CMD INSTALL pkgname but still get various

Hello, I am running a simple nls model (which a friend ran OK) but I get the following error: Error in nls(y ~ R * (1 - (x/K)^2), data = nls.dat, start = list(R = 0.3, : object 'R_nls_iter' not found Does anyone know what the 'R_nls_iter' error is? The data are: x=1:8 ; y=c(14,19,25,34,43,56,69,76) # starting values: R=.3, K=94 Thanks in advance. Jeff

Dear R-Group, I have a function that sorts a data frame and oneo of the lines in the function is: vars <- unlist(strsplit(formc, "[\\+\\-]")) The function works fine and the above line is always reached. However, when I include the function in a package and run "R CMD check pkgname" it gives this error message: '\+' is an unrecognized escape in character

After loading the RODBC package version 1.1-7, Ctrl-C changes its behaviour and is quitting R and returning to the (unix-)command prompt on the solaris2.8 platform here. Here's what happened before and after loading RODBC > for (i in 1:10^5) rnorm(10) ^C > library(RODBC) > for (i in 1:10^5) rnorm(10) ^C bash-3.00$ platform sparc-sun-solaris2.8 arch

Hi, Does anyone know how to pass dynamic sql statement to RODBC function "odbcQuery()" or "sqlQuery()"? eg.: under R session, I did: >library(RODBC) >channel<-odbcConnect(...) >data1<-2.5 >data2<-5.0 I want to construct the INSERT sql statement using variables "data1" and "data2" and pass this statement to odbcQuery() . Can I do this?

Hi, I have a contour plot and I want to shade a polygon (the area below a line) but the polygon shading wipes out the contour lines. Does anybody know how to shade the polygon and still see the contour lines? Thanks. Jeff

Hi Folks, I've been bumping my head against the 4GB limit for 32-bit R. I can't go to 64-bit R due to package compatibility issues (ROBDC - possible but painful, xlsReadWrite - not possible, and others). I have a number of big dataframes whose columns all sorts of data types - factor, character, integer, etc. I run and save models that keep copies of the modeled data inside the model

Hi, I'm trying to use RODBC without having to set up a DSN, using hte direct connection string in odbcDriverConnect. My connection attempt looks something like: > odbcDriverConnect(connection = "SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;") And this returns the message: Warning messages: 1: In odbcDriverConnect(connection =

I am writing a package for a company for its internal use only. What is an appropriate license statement for the DESCRIPTION file? I would like a statement which reflects the private and proprietary nature of the package, giving copyright to the writer and the company. I also don't want to violate the licensing of R and the packages I am using (RODBC, ggplot2, zoo). David Scott --

Dear users, I can access an database oracle database using sql developer. This was done by importing an xml file that contains the login details - username, password and specifies that it uses the KERBEROS_AUTHENTICATION. I'm trying to connect R - so that it can access this database - do sql queries and convert the resulting tables into dataframes. I am a novice in SQL and database access