similar to: Simple one

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 character in COLUMN2 and creat COLUMN3 with that value ex: COL2,COL3 135,1 461,4 247,2 -in every

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 mailing list archive at Nabble.com.

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(channel, "select * from

Hi, I'm dealing with an optimization problem. I'm using 'optim' to maximize the output of a function, given some restrictions on the input. I would like to know if there is a way to impose some restrictions on 'intermediate variables' of the function. An example.. fx = function (x) { s <- 0 for (i in 1:3) { s <- x[i]^3 + s } s } optim(rep(4,3),

Hola Soy Maricela Debo realizar un proyecto de autenticacion de usuarios para una red interna de una empresa, esto se realizara en linux con Samba 3.0.2 y LDAP. Estube mirando este articulo porq me recomendaron usar: sambaSamAccount y posixAccount, pero tengo dudas. Queria preguntarte si me puedes ayudar: 1. El esquema jerarquico es definir el los componentes de domino y los objectclass

Hi Everyone, I'm writing to announce my new R beginner's guide book and answer questions related to it. The primary focus of Statistical Analysis with R is helping new users become accustomed to R and empowering them to apply R to suit their own needs. It is a beginner's guide written for a broad audience and should be well received by businesspeople, IT professionals, researchers,

I am currently developing a asterisk ncurses interface using the manager API. The project is currently awaiting sourceforge's approval but I have a beta online at http://sig.lange.googlepages.com/assman . The projects real home will be assman.sf.net. This project really consists of two parts, libassman is a C manager API and assman is the ncurses portion. It's still beta but I have been

I own a lot to the folks on r-help list, especially arun who answered every of my question and was never wrong. I am disinclined to once again ask this question, since it is more arithmatic than technical. But, having worked 2 days on it, I realized my brain is just not juicy enough.... Here is the problem. Trust not for freedom to the Franks--- They have a king who buys and sells. -

Well I must say. I certainly feel like a fool now. I have been contributing to Wine for about five months, and was shocked to see a blatant advertisement for CrossOver, who take the hard work of those who have contributed their intellect for free and sell it for profit, on your home page. I then discovered through your own FAQ that most Wine developers are employed by CrossOver. Is this legal?

Hello Jean: Big mistake!! One of the three things that a supplier should never discuss is politics ... that's business 101. Speex may be a very good product, but we will never use it because of the politics that you espouse ... some of us out here believe strongly in the free market. And we also know that monopolies can't exist because entrepreneurs will always exploit the

Hello, I have a beginner's Q: if i want to know all the functions provided by a package, what is command for that? in another word, Is there a command to list all the commands available in a packege? thanks a lot, yan

First of all, thanks to everyone who answers these questions - it's most helpful. I'm new to R and despite searching have not found an example of what I want to do (there are some good beginner's guides and a lot of complex plots, but I haven't found this). I would like to plot two variables against the same abscissa values. They have different scales. I've found how to make

Is there a beginner's tutorial/documentation on how to write passes for the llc tool? I've managed to write some simple analysis passes for the opt tool but can't figure out how to do the same for llc. What is the proper way to integrate a new MachineFunction pass with llc? Is there a way to register passes and selectively enable them on the command line (as with opt) or do I need to

Hello, This is probably a bit of a beginner's question but I am new to LLVM I have been examining the possibility of constructing something similar to the JnJVM for a language which supports dynamic class loading. The problem I am having is determining how the JIT system allows for dynamic loading of functions into the JIT. The paper indicates the JnJVM use some sort of callback when the JIT

Hi R, Can I get a comparison between R and MATLAB? How is R efficient than MATLAB? Or what are the weaknesses of R compared to MATLAB? Thank you very much for your help, Shubha Shubha Karanth | Amba Research Ph +91 80 3980 8031 | Mob +91 94 4886 4510 Bangalore * Colombo * London * New York * San José * Singapore * www.ambaresearch.com This e-mail may contain confidential and/or

Help. - Is there a beginner's manual for R? - How do i analyse gene expression data using R, to generate a dendrogram. I would greatlyy appreciate every bit of input. -- BEST Paul [[alternative HTML version deleted]]

Probably a stupidly simple question, but I wouldn't know how to google it: xyplot(neuro ~ time | UserID, data=data_sub) creates a proper plot. However, if I add type = "l" the lines do not go first through time1, then time2, then time3 etc but in about 50% of all subjects the lines go through points seemingly random (e.g. from 1 to 4 to 2 to 5 to 3). The lines always start at time

Dear R-help, This is my first R day. I want to ask some more beginner's questions. Q1. How can I obtain the covariance matrix for parameter estimates of a multiple regression? I checked ?lm but didn't get the information. Q2. How can I see the old graphs in the graph window? Q3. Can R plot animated graph? For example, I want to see the dynamic change of a 2D graph during a time

Hi, guys. I have a beginner's question. The virtual machine I develop have instructions to dynamically allocate variable in stack and to free it (consistency of such instructions is checked before the actual jitting). To allocate memory in stack we have alloca IR instruction, but I didn't find any instruction to free it (such variables will be freed only when an enclosing function will

On Sun, Jul 12, 2009 at 2:09 PM, shu<shuguang.feng at gmail.com> wrote: > Is there a beginner's tutorial/documentation on how to write passes > for the llc tool?  I've managed to write some simple analysis passes > for the opt tool but can't figure out how to do the same for llc. > What is the proper way to integrate a new MachineFunction pass with > llc?  Is there