similar to: BETWEEN

Hi, I have a problem, can you help? When i type: > library(RODBC) > a<-odbcConnect("oracle") > sqlQuery(a,"(select VALFACT>500 from EPISGDHS) UNION (select VALFACT<1000 from EPISGDHS)") Comes the error: [1] "S1000 923 [unixODBC][Easysoft][Oracle]ORA-00923: FROM keyword not found where expected at offset 15" [2] "[RODBC] ERROR: Could not

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

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 > >

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

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)

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

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$

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

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 =

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

Hi, I tried many things to insert a data in an Oracle Table, but the Rails compiler never Works! I create this Oracle table: CREATE TABLE "FOO" ( "id" int NOT NULL primary key, "acolumn" VARCHAR(10) NULL ) and when i tried to insert a new row the Rails compiler tell me : OCIError: ORA-00904: invalid column name: INSERT INTO AGO.FOO (acolumn, id)

A person has a many company_branches and A company_branch has many people. This join is represented using a "contacts" table. I am using a legacy schema so i am forced into using non-standard rails primary keys. I am using the new through relationship in rails 1.1. p=Person.find(1) b=p.company_branches # gives this error: ActiveRecord::StatementInvalid: OCIError: ORA-00904:

Hi, I am trying the following in Ruby using InstantRails 1.7 on WindowsXP Publication.find(:all, :include => [:doc_type, :release_state] ) but I get the error: OCIError: ORA-00904: "DOC_TYPES"."PUBLICATION_ID": invalid identifier: SELECT publications.id AS t0_r0, publications.docid AS t0_r1, publications.doc_type_id AS t0_r2, publications.title AS t0_r3,