[R] RODBC package -- sqlQuery(channel,.....,nullstring=0) still gives NA's

R-help, I'm using the RODBC package to retrieve data froma ODBC database which contain NA's. By using the argument nullstring = 0 in sqlQuery() I expect to coerce them to numeric but still get NA's in my select. I'm running on Windows XP version _ platform

Re: [R] RODBC package -- sqlQuery(channel,.....,nullstring=0)stillgives NA's

, if you want to. On Wed, 12 Jan 2005, Luis Rideau Cruz wrote: There is something strange in R behaviour (perhaps). Your negative remarks are not appreciated. I have run the same select in Oracle SQL*Plus (version 10.1.0.2.0) and the output comes out with NULLs (which is what it ougth

[R] extraction of p-value

R-help, I wish to get the p-values of anova model as numeric and not as part of the standard output (print,summary,,,) I have tried several commands but to not vail Thank you __ [EMAIL PROTECTED] mailing list

[R] length with missing values

R-help I have a martix with missing values( in which I want the sample size by column) When I : apply(matrix,2,length) I get the length of the vector regardless of missing values. I can't pass an argument to length in apply. Alternatively I could ifelse ( is.na ( matrix [, columns in matrix

[R] 'Replace' in internal editor causes R to crash

R-help, While using the internal editor in R (R 2.0.0) I have encountered the following problem : When I execute the facility 'Replace' (Ctrl H) R crashes (exactly when I paste to field 'look for') This is not one-off.I have faced it several days ago (and today as well). System specifications:

[R] library/utils/man/utils.RD.gz : Nosuch file or directory

R-help I have installed R 2.0.0 ( Windows) on my machine and had several 'crashes' while working on it. I have reinstalled a couple of times and still got strange behaviour from time to time(screen goes white and no prompt is printed out,,,) Last time I have reinstalled I checked the md5sum.txt

[R] Multi-dimensional scaling

R-help, Is there any package/function in R which can perform multi-dimensional scaling? Thank you in advance __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide!

[R] Restore function in R

R-help, Any function in R that restore an object to its original state so that if not satisfied with the modifications made to it there is no need to redefine again ( 'undo' action) I believe there is something like that in S-plus. Thank you __

[R] for (i in ...) { df[[i]]- .....}

R-help, In the following loop : for(i in 1:8) { cc[[i]]-tapply(test[,i+6],list(puntar=test$puntar),sum)/tapply(test[,5],list(puntar=test$puntar),sum) cbind.data.frame(cc[[1]],cc[[2]],cc[[3]],cc[[4]], cc[[5]],c[[6]],cc[[7]],cc[[8]]) } Is there anyway I can 'cbind.data.frame' the objects cc[[ i

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] R-help,

R-help, __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] removing last element from a character string

R-help, Any function to remove last element (or any specific elemnet in the sequence) from a character string? t-c(aaab,qqqc) function(t) ### remove last character (b and c respectively) aaa qqq Thanks `·._ .· `·. _ .· `·._ .· `·. _ .· `·._ .· `·. _ .· `·.. Luis Ridao Cruz

[R] levels of factor

R-help, I have a data frame wich I subset like : a - subset(df,df$column2 %in% c(factor1,factor2) df$column2==1) But when I type levels(a$column2) I still get the same levels as in df (my original data frame) Why is that? Is it right? Luis Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1

[R] adding sem to a plot

R-help, I have a barplot and I wish to add standard erros (or deviations) bars to it. How? Thank you Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe Islands Phone: +298 353900 Phone(direct): +298 353912 Mobile: +298 580800 Fax:

[R] lapply problem

R-help, I wish to replace NULL elements(or missing) in the following list : z2 $cod mean sd 62.56190 12.65452 $haddock mean sd 36.61490 11.50365 $ling mean sd 86.17949 20.43587 $saithe meansd 50.275847 5.453606 $whiting NULL $norway pout

[R] barplot and names.arg

R-help Is there any option to get closer the x-axis and names.arg from barplot? Thank you Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe Islands Phone: +298 353900 Phone(direct): +298 353912 Mobile: +298 580800 Fax:

[R] titles to plots

R-help par(mfrow=c(2,4)) lapply(lgd.aov.sum,function (x) {plot(x[,1],x[,3]) }) What I get is a 2x4 layout plot How can I get the names argument of lgd.aov.sum and pass it as title names for every plot?? Thank you Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn

[R] two-way ANOVA

R-help This is more a statistic thing than an R question. I have length measurements of organisms which I want to use for an two-way ANOVA( fixed factors) The problem is that I have different number of replicates for each combination of factors. What are the strengths and weakness of these

[R] list of frames without first element

R-help, I have a list of several data frames. I want to compute the rowSums of the columns of these data frames but first one. Something like this lapply(my.list,rowSums) Thank you Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe

Re: [R] RODBC with MS Microsoft Access

Rideau Cruz [EMAIL PROTECTED] 04/08/2004 15:05:53 Hi all, I tried to retrieve a table from a desktop database and got an error. The thing is that when I changed the table name it worked out. The former names was length-spring The new was test Is - character not valid for tables? Thank you Luis

[R] function output

I have the next function : extracting.lgddata-function(channel) { library(RODBC) channel-odbcDriverConnect() ... ... } .. is just a sequence of SQL selects. But when I try to call the objects created from the select they do not seem to have been created. I checked with ls() and they

[R] RODBC with MS Microsoft Access

Hi all, I tried to retrieve a table from a desktop database and got an error. The thing is that when I changed the table name it worked out. The former names was length-spring The new was test Is - character not valid for tables? Thank you Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O.

[R] list problem

Hi all, I have the folowing frame(there are more columns than shown), 1 2 34 5 Year Total TusWhi Norw 1994 1.00 1830 0 355 1995 1.00 0 00 1995 1.00 0

[R] aggregate function

Hi all, I have the folowing frame(there are more columns than shown), 1 2 34 5 Year Total TusWhi Norw 1994 1.00 1830 0 355 1995 1.00 0 00 1995 1.00 0

[R] retrieve rows from frame assuming criterion

Hi all, I have a data frame in which one column(PUNTAR) is of character type. What I want is to retrieve is the frame but only with those rows matching elements of PUNTAR with a list characters (e.g c(IX49,IX48) ) YearTUR STODNR PUNTAR 1994 9412 94020061 IX49 1994 9412 94020062

[R] Sort a data frame

Hi all I have the next data frame year STODSLAGNR TAL TALT TALVEKT 1 2002 2120006 57 1 NA 1 2 1997 9703003257 NA NA NA 3 1997 9703007127 1 NA NA 4 1997 9703000557 1 NA NA 5 1997 9702012760 NA 1

[R] Problem with plot

Hi all I'm trying to plot 2 columns of a frame but whatever option I choose for argument type I always get bars with height equal to 1. I quit and restart but problem remais Help! Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe Islands Phone:

[R] How to order a vector

Hi all I have a vector like this 2003 2002 2001 2000 1999 1998 1997 1996 106 105 106 106105 106 101 107 How can I get it sorted right(19962003)? Thank you Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe Islands Phone: +298

[R] Fwd: problem in long select from RODBC

Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe Islands Phone: +298 353900 Phone(direct): +298 353912 Mobile: +298 580800 Fax: +298 353901 E-mail: [EMAIL PROTECTED] Web:www.frs.fo

[R] How to insert a bitmap in a grph device

If I have a plot and I want to insert a bitmap in the same devicehow to do it? Thank you Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe Islands Phone: +298 353900 Phone(direct): +298 353912 Mobile: +298 580800 Fax:

[R] nls

Hi all, I have define a function Statistical_Catch_At_Age - function(Cya,Mya,Fy,Sa) { .. here there are the objects Cya,Mya,Fy,Sa and the most important of all is the next: fitting-nls( formula=Cya ~ (Sa*Fy) / (Sa*Fy + Mya) * Nya * (1-exp( -( Sa*Fy + Mya ))), start = list( Fy =

[R] Naming list elements

How to name the following list GH.MEINKV.byyear ( a list consisting of 9 data frames) GH.MEINKV.byyear-as.list(numeric(length(levels(GH.MEINKV$Year Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O. Box 3051 FR-110 Tórshavn Faroe Islands Phone: +298 353900 Phone(direct):

[R] fill up a matrix

Hi all, I want to fill in this matrix vectors (by column) without overwriting the first elements in column 1995. Is there any other way than concatenate the first element with the vector and then assign this new vector to the column in matrix? matrix[,3]-c(1591,vector)

[R] R1.9.0

I have just installed R 1.9.0 on my computer(Windows XP) and uninstalled 1.8.1 When Itry to execute .RData I'm asked to specify the program to open it.But whe I do it I get a message .RData is not a valid Win32 program Can anyone help please? Luis Ridao Cruz Fiskirannsóknarstovan Nóatún 1 P.O.