[R] sqldf

Hello, I would like some help with sqldf syntax. Suppose I have table 1 and table 2. What do I have to do to generate a table with columns 2,5,6 from table 1 (for example), and columns 3,4,5,9 from table 2, but only when values in column 2 from table 1 are equal to values in column 5

[R] Problems With RODBC, sqlQuery

Hello, Im trying to get a Oracle database to R, but I'm having problems with most of SQL sintax. Suppose that Im trying to bring a table "TABLE" with columns "COL1","COL2",.. from schema "SCHEMA". What am I doing wrong? library(RODBC) channel<-odbcConnect("xxx",uid="xxx",pwd="xxx") sqlQuery(

[R] problems with RODBC, sqlQuery

Hello, Im trying to get a Oracle database to R, but I'm having problems with most of SQL sintax. Suppose that Im trying to bring a table "TABLE" with columns "COL1","COL2",.. from schema "SCHEMA". What am I doing wrong? library(RODBC) channel<-odbcConnect("xxx",uid="xxx",pwd="xxx") sqlQuery(cha

Re: [R] libname version in R

Michael Yutzi wrote: > > Hello friends, > in SAS there is the 'libname' source. You associate a way.. ex: ab .. > "C:\My Paste\Works" and when u do > > data ab.example; > (...) > run; > > you are saving the archive "example" in a SAS format, and you can see > C:\My Paste\Works\example "gro

[R] Some SQL Challenges

Hi, Im trying to complete a list of jobs using SQL Querries and some "if else" commands but im stucked in some steps. Could any of you give me some help? -in COLUMN1 change the format 20JAN2000:00:00:00 to 20JAN2000 and exclude every row that date is different from 20. -extract the first charac

Re: [R] SQL on R

Fala ai cara! Era o RMySQL mesmo q eu precisava, vlw Bernardo Rangel tura wrote: > > On Sat, 2009-07-04 at 22:24 -0700, JoK LoQ wrote: >> I'm dealing with lots of columns and conditions, wats t best way to deal >> with >> that? >> How do I work with SQ

[R] SQL on R

I'm dealing with lots of columns and conditions, wats t best way to deal with that? How do I work with SQL on R? the manual is quite confuse talking about that. Do I need a package? -- View this message in context: http://www.nabble.com/SQL-on-R-tp24340314p24340314.html Sent from the R help mail

Re: [R] Simple one

Ben that subset(..) works, and it solves all my problems. thnks! Ben Bolker wrote: > > > > JoK LoQ wrote: >> >> Just a quickly beginner's question. >> >> I wanna find the mean only from the values from a column related to >> specific

[R] Simple one

Just a quickly beginner's question. I wanna find the mean only from the values from a column related to specific values from another one. Like, theres a 'region' column, i want the mean of the value on 'profit' column only from "south" sells from 'region' column -- View this message in context: