similar to: RODBC Bug?

Thanks in advance for any help I can get on this. I'm trying to change variable names between 2 systems - R and old SPSS, Oracle. I'm using the grep() and gsub() commands but I'm getting the following result - > test.dat <- c("a", "b.c", "d.e.f", "p_q,r") > test.dat [1] "a" "b.c" "d.e.f"

Help! I have a very large data file with about 100 columns. Instead of loading all of the columns using read.table() (my PC won't be able to handle the resulting data frame), I'd like to read in one column of the datafile at a time using scan() in conjunction with the 'what = ' option. I've tried loading just the third column using - > scan(file.name, what = list(NULL,

Does anyone have any experience using R to pull/push data from an ODBC compliant database? I'm working on a small project and am undecided about whether to use just R or use some other software for extracting and transforming. TIA Samir. The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If

essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle") > sqlTables(essai)$ORESTE ... 1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA> 1316 <NA> ORESTE S_PROVENANCES TABLE <NA> 1317 <NA> ORESTE

Dear r-helpers! I have trouble reading data from an Oracle data base using RODBC Version 1.0-3, R Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME

Hello, I want to leave pwd blank (to comply w/ company security protocol) and just be prompted by the driver-specific data source dialog box to enter the password after. But for some reason it is not working. R Version: "R version 2.15.1 (2012-06-22)" R Studio Version: 0.97.312 OS: Windows 7 library(RODBC) ##HERE IS THE CODE THAT DOES WORK ##my DSN, UID, PWD is entered something like

Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not

I thought I'd field this question in case someone has already done this, before proceeding with trying to develop a function on my own. I'm generating a number of files and to keep track of them, I'm also outputting the names of these files to external files & datasets. Depending on the platform I'm working on, Windows or Unix, i'd like to be able to switch between UNIX

Hi everyone, I've got a question concerning the function acf(.) in R for calculating the autocorrelation in my data. I have a table with daily returns of several stocks over time and I would like to calculate the autocorrelation for all the series (not only for one time series). How can I do this? After that I want to apply an autoregressive model based on the estimated lag in the

Hi everyone, I've got a question concerning the function Box.test for testing autocorrelation in my data. My data consist of (daily) returns of several stocks over time (first row=time, all other rows=stock returns). I intend to perform a Box-Ljung test for my returns (for each stock). Since I have about 3000 stocks in my list, I'm not able to perform the test individually for each

Hi Johannes, Thank you for your quick feddback. As I am using linux os build with buildroot on my raspberry pi I can't use package manager such as apt-get to install R. What I need to do is to get the precompiled R for arm arch and then when I build my linux image using buildroot I include the R precompiled package to my rootfs. Could you please send me a link where I can download

Hello, I m using Centos 5.2 in my virtual machine VMWARE i've got the rpm of VMWARE tools, after double clicking on it, it installs successfully. but after this installation i still can not change my displaay r?solution.. (the max is 800 * 600) any help? -- Samir RHAOUSSI ENIM 2009 - G?nie Informatique -------------- next part -------------- An HTML attachment was scrubbed... URL:

Dear all, I am currently trying to cross compile R3.5.2 using X86 host and trying to cross compile for ARM target (raspberry pi 3 running on linux system generated by buildroot). The problem I am encountering is that the compilation fails because the current R buildsystem I trying to execute the R binary generated for Arm arch on the host X86 computer. My question is: Is there an R

Dear All, I have an asterisk server version 1.2.12.1 along with trixbox and I am having this nasty problem, I have a TE200P and have an E1 pri attached to it and zttool says it's OK, I have configured the whole 31 channels into one group as follow: Zapata-auto.conf: callerid=asreceived signalling=pri_cpe switchtype=euroisdn context=from-zaptel group=0 channel=>1-15,17-31

Hello everyone I have a couple of questions about the usage of the R function "read.table(.)". My point of departure is that I want to import a matrix (consisting of time and daily stock returns of many stocks) in R. Most of the data is numeric, however some values are missing (blanks) and in other cases I have the character "#DIV/0!" (from excel). My goal is to do some

Dear All, My problem is the following > varname <- c("age","sex","edu","mrt") > varstates <- c(10,2,4,3) # 10 age groups, 2 sexes, 4 education group and 3 marital status.. Now, I want four variables (vector with length1) named nrage, nrsex, nredu, nrmrt and assing some values > for (i in 1:4) paste("nr",varname[i],sep="")

I am running debian etch with dovecot 1.0 rc15 from the debian repository with postfix 2.3 I am using virtual users in a postgreSQL database as taken from the dovecot wiki while making use of the password field for authentication I am using deliver as LDA and I am attempting to use the sieve plugin but try as I might I can't seem to get it working. Am I wrong in thinking that a sieve

Hi I want to authenticate the asterisk users from the LDAP directory server not from the sip.conf. I tried to use the astirectory-1.2<http://www.asterisk-ev.org/download/astirectory-1.2-0.3.tgz>. But i am not able to configure it properly. If somebody used it then please help. In the res_ldap.conf file i made the following entries. I am using my normal username and password to connect my

Dear R-Users, I have a data frame with several categorical variables. I want to create a new data frame with dummy variables (with all levels). I know the function model.matrix (see below) but it works only for one categorical variable : > tt <- c("a","a","b","a","c") > tt <- factor(tt) > model.matrix(~ tt - 1) is there anyone who

Hi David, In the general case, there is still a gap in your solution >sum( tbl["1", 2:ncol(tbl)] ). This solution refers to a specific column number (here: column number 2) and not to the actual length of the run, doesn't it? That is, in this simple example the column number 2 actually corresponds to the length "2", but this must not be the case in general. For