similar to: importing data from Excel using RODBC

Hi, P-values in Durbin-Watson test obtained through the use of functions available in packages "lmtest" and "car" are different. The difference is quite significant. function "dwtest" in "lmtest" is much faster than "burbinwatson" in "car". Actually, you can take a nap while the latter trying to calculated Durbin-Watson test. My question

Full_Name: Ahmad Abu Hammour Version: rw0651 OS: windows 95 Submission from: (NULL) (63.23.128.44) Although I know that "ts package" is preliminary, I wanted to compare the results from R and SPSS. I ran ARIMA(2,1,2) in both softwares. I got NaN in standard errors of coefficients from R and real figures from SPSS. I changed "delta" in R to match that used by SPSS, I received

Hi, Is there a function in any of R-packages that can produce and plot the impulse response function for any model.. Thank you Ahmad Abu Hammour -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body",

Hi, I have the following hypothetical optimization problem: -det(t(x-A%*%x1)%*%(x-A%*%x1)) where A,x,x1 are matrices. A coefficients and x and x1 are variable matrices or vectors. I tried to apply optim and nlm functions but I kept receive the following massage: Error in A%*%x1 : non-conformable arguments. The massage appears even the -det() can be calculated and the dimensions are checked. here

Hi, I noticed that paste and expression in the following manner does not produce the desired result. vnames=c("pi","y","delta") vx=vn=3 m=16 # mydata any matrix that takes for the following form mydata=array(somedata,c(m,vn,vx)) # producing plots for (j in 1:vx){ for (i in 1:vn) { plot(mydata, type="l", main=expression(paste("Effect of",

Hi, I have a matrix and time series "xmat". I have no problem executing any matrix functions except t(xmat) which gives the following error message. My question if "xmat" is a matrix why I can not execute this matrix function?? converting the time series and matrix into a data frame solves the problem >dim(xmat) [1] 98 7 > t(xmat) Error in "tsp<-"(*tmp*,

Hi, I need help regarding estimating a linear model where restrictions are imposed on the coefficients. An example is as follows: Y_{t+2}=a1Y_{t+1} + a2 Y_t + b x_t + e_t restriction a1+ a2 =1 Is there a function or a package that can estimate the coefficient of a model like this? I want to estimate the coefficients rather than test them. Thank you for your help Ahmad Abu Hammour --------------

Hi, I am using R interactively for estimation and even data manipulation. I want to use lag() function within lm() function in a way looks like: mymodel<- lm(y~x+I(lag(y,-1)-1, data=anydata) What I get is always perfect fit; (that is, coefficient=1) which is not true. If the model looks like mymodel<- lm(y~z+x+I(lag(x,-1)-1, data=anydata) summary returns only one coefficient for x and

Hi, Thanks for showing me how to use RODBC and odbcConnect. Now works nicely. The question I've got now is: noms <- list.files(pattern=".DBF") # removing extension names: noms <- sapply(noms, function(x) as.character(strsplit(x,".DBF")) , USE.NAMES=F) for (i in 1:length(noms)) { s <- sqlFetch(bdades, noms[i]) # etc. } But it seems that sqlFetch()

Hello, I have 4 data frames, say A, B, C, D. Each A, B, C has different columns set, and D has all of what A, B, and C have. So, here is the example: A has c1, c2, and c3 B has c4 and c5 C has c1, c5, and c6 D has c1, c2, c3, c4, c5, and c6. I want to load these data frames into an Oracle SQL server. I am using RODBC with sqlSave, and managed to load D. But when I tried to load the other data

I am working with transition matrices of sequences of animal behaviours. What I would like to do is parse the original matrices, adjusting row/column order so that the matrix has its main values in blocks surrounding the diagonal. This would cause behaviours involved in functional groupings (e.g. grooming, resting, foraging etc) to appear as blocks. This can be done manually by applying

Not an R question directly, but has anyone got a method for placing a moderately large number of (near) equi-spaced points on a sphere? I have a nasty feeling platonic solids are needed for exact solutions and I'm thinking of samplings involving around 200 - 1000 regularly-spaced points, Thanks, Richard Rowe Richard Rowe Senior Lecturer Department of Zoology and Tropical Ecology, James

I am attempting to plot frequency of occurrence against (calendar) time. As the output is to be produced as a Powerpoint picture on a dark background I wish to make the plot output yellow > par(col="yellow", col.axis="yellow", col.lab="yellow", col.main="yellow") > plot(t2, t1, ylim=c(0,40), main="Episynlestes run 2",

Hi, I am trying to change the number of the ticks on each axis, but every time I can not succeed and receive the error message shown below even I use the default values: >plot.mts(infldata1[,3:4],lty=c(1:2),plot.type="single",lab=c(5,5,7)) Error in axis(side, at, labels, tick, line, pos, outer, font, vfont, ...) : location and label lengths differ, 6 != 3 Thank you for

Hi, I am trying to change the number of the ticks on each axis, but every time I can not succeed and receive the error message shown below even I use the default values: >plot.mts(infldata1[,3:4],lty=c(1:2),plot.type="single",lab=c(5,5,7)) Error in axis(side, at, labels, tick, line, pos, outer, font, vfont, ...) : location and label lengths differ, 6 != 3 Thank you for

I think this was asked recently but I can't find the item. Is it possible to find the colour at a point on a graphics page? I want to estimate the area of a complex shape by colouring it then random sampling from an enclosing box ... Richard Rowe Richard Rowe Senior Lecturer Department of Zoology and Tropical Ecology, James Cook University Townsville, Queensland 4811, Australia fax (61)7

I'm trying to use the biological female and male signs in R2.5.1 under Windows XP. I can access and insert these symbols using word-processors. In general these should be available as \u2640 and \u2642 but I can't make them happen in R using (say) text(5,5, "\u2640") message "invalid \uxxxx sequence" I've replaced Arial with Arial unicode MS in Rdevga and

I am having problems with the 'if' syntax. I have an n x 4 matrix, X say. The first two columns hold x, y values and I am attempting to fill the second two columns with the quadrant in which the datapoint (x, y) is and with the heading angle. So I have two problems 1) how to do this elegantly (at which I've failed as I can't seem to vectorize the problem) and 2) how to

Dear list, How should missing values be expressed in Excel before extraction to R via RODBC. I'm bewildered. Sometimes the representation with NA in Excel appears to work and shows up in R as <NA> but sometimes the use of NA in Excel changes the whole vector to NA's. Blank or nothing or NA as representation for missing values in Excel with dateformat gives NA's of the whole

L.S. I am trying to get data from an excel sheet using the RODBC library, quite like the example on page 34 of the 'Data manipulation with R' book written by Phil Spector. It seems very straightforward, yet I get the same error everytime I try it, with different excel sheets and trying to tweek the code a bit. This is what I do: library(RODBC) sheet='X:\\example.xls'