similar to: UNION

Hi, I have another problem, can you help? When i type: > library(RODBC) > a<-odbcConnect("oracle") > sqlQuery(a,"select DISTINCT(DOENT_ID) from EPISGDHS where (VALFACT BETWEEN 100 AND 50)") Comes the error: [1] "S1000 904 [unixODBC][Easysoft][Oracle]ORA-00904: \"DOENT_ID\": invalid identifier at offset 16" [2] "[RODBC] ERROR: Could

hi again, i still cannot open the file in spss :( i type: library(foreign) read.spss("H:\\Desktop\\bd1\\experiencia1") and the error comes: Error in read.spss("H:\\Desktop\\bd1\\experiencia1") : unable to open file can you help me? margarida,portugal

Hi, I have a data base in oracle and need to link R using ODBC. When i use the command odbcConnect a dsn is needed. I would like to create a dsn.Do you know how can i do it? Thank you. Margarida,Portugal

Hi, I would like to read a spss file in R. When i type read.spss("...") Comes the error: couldn't find function "read.spss" What shall i do? Margarida [[alternative HTML version deleted]]

hi, i can?t download a file in access. when i type: > library(foreign) > read.spss("H:\Desktop\bd1\experiencia1") comes the error: Error in read.spss("H:Desktop\bd1experiencia1") : unable to open file do you know what is the problem? can you help me? margarida,porto,portugal

Hello, I??m trying to read data from a text file but i can??t When i print: > a<-read.table(file="C:/dados10.txt") The next error appears: Error in file(file, "r") : unable to open connection In addition: Warning message: cannot open file `C:/dados10.txt' Can you help me? Margarida PS:The operating sistem i??m using is Unix

Hi, I would like to do a MannWitney test. Can anyone help me with the propper command? Thanks, Margarida

On Mon, 8 Mar 2004 r-help-request at stat.math.ethz.ch wrote: > Send R-help mailing list submissions to > r-help at stat.math.ethz.ch > > To subscribe or unsubscribe via the World Wide Web, visit > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > or, via email, send a message with subject or body 'help' to > r-help-request at stat.math.ethz.ch > >

Full_Name: Michael Hecht Version: 1.7.1 OS: WinNT Submission from: (NULL) (193.158.76.205) I've got a problem with the RODBC library while trying to access to an MS-Excel file. The Excel file was originally exportet by a commercial software, so I cannot influence it. The problem is, that the names of the tables include spaces, e.g. "Scan 1","Scan 2" etc. If I use RODBC, I

Hello, I am a beginner in R, and I wonder if anyone could help me with a partial least square regression in R. I have looked up the instructions and the manual from Bjorn Mevi and Ron Wehrens. However, I think I managed to write the script correctly, but I dont understand the output on the R environment, and also how to decide on the number of components to use (from the RMSEP), and also how to

I'm tryuing to get the RODBC package to work with a MS Sql database (Wonderware's InSQL). I'm able to connect to the database using the following: version _ platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status Under development (unstable)

Hello, I need help with a partial least square regression in R. I have read both the vignette and the post on R bloggers but it is hard to figure out how to do it. Here is the script I wrote: library(pls) plsrcue<- plsr(cue~fb+cn+n+ph+fung+bact+resp, data = cue, ncomp=7, na.action = NULL, method = "kernelpls", scale=FALSE, validation = "LOO", model = TRUE, x = FALSE, y =

Sorry for the numerous posts, I found that an old (~ June) post had the same title and confused me (and the list server) greatly (and made it hard to get this as a new thread). Anyway... I'm trying to get the RODBC package to work with a MS Sql database (Wonderware's InSQL). I'm able to connect to the database using the following: version _

Hi I am running R2.15.2 64-bit on Windows 7, using RODBC 1.3-6, MySQL5.5.20, MySQL Connector 5.5.2 - these are the latest 64-bit versions AFAIK. sqlQuery and sqlSave work fin as expected, but in a long session with a few sqlSave() calls, I get an error, for example: Error in sqlSave(channel = channel, dat = USArrests[, 1, drop = FALSE], : HY000 1461 [MySQL][ODBC 5.2(w)

Hello, I am trying to play with RODBC library and Excel Files. In my file (doubs.xls) there are 2 spreadsheets: > library(RODBC) > connection<-odbcConnect("Excel Files") > sqlTables(connection) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 F:\\Th?se\\R\\Doubs NA Faune$ SYSTEM TABLE NA 2 F:\\Th?se\\R\\Doubs NA Milieu$

Margarida Soares <margaridapmsoares at gmail.com> writes: > Thanks for your reply on pls! > I have tried to do a correlation plot but I get the following group of > graphs. Any way of having only 1 plot? > This is my script: > > corrplot(plsrcue1, comp = 1:4, radii = c(sqrt(1/2), 1), identify = FALSE, > type = "p" ) "Correlation loadings" are the

Se não pode visualizar este e-mail corretamente, clique aqui <http://www.almasoma.pt/newsletter--terapia-para-bebes-aprenda-a-ajuda-los> . <http://www.almasoma.pt/> Formação em Terapia para Bebés Lisboa, Outono 2013 - Primavera 2016 Workshop: "Baby Clinic", 6 e 7 de Abril de 2013 Conferência de Apresentação, 5 de Abril de 2013 Karlton Terry Pioneiro da assistência aos

I know this is very off topic, but getting MySQL and unix ODBC to play nice via SSL on Centos has been a battle. I finally have it working via isql but when I connect via Oracle I get an error. If I use the mysql odbc connector directly: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][MySQL][ODBC 3.51 Driver]SSL connection error

I have searched the archives for using insert into to update spreadsheets using RODBC and have come up short. So, first off, is it possible? I have put together a dummy xls table (c:\foo.xls)for exploring possibilities of RODBC. Ultimately, I am interested in replacing much of our previous use of vba macros with R ( I'd prefer elimination, but will take what I can get ). In order to

Hi! I'm trying to compare maximum likelihood estimator with maximum spacing estimator (in Generalized extreme value distribution). My problem is the following: i know how to determinate maximum likelihood estimator on R, but i dont find a way to do the maximum spacing estimator...:-( Any help would be great:-) -- View this message in context: