[R] RODBC question: problem importing series with blank cells

From: Lapointe, Pierre <Pierre.Lapointe_at_nbf.ca>
Date: Wed 08 Jun 2005 - 23:42:39 EST


Hello,

I have an excel file that I load through RODBC. Some of my columns are blank. They are equity time series and the stocks did not exist at the earlier dates. My problem is that the whole column becomes <NA> even though there are numbers at later dates.

Here's my excel file

http://www.tradebit.com/download.php/35699 <http://www.tradebit.com/download.php/35699>

And here's the code I use:

library(RODBC)
chan <- odbcConnectExcel("C:/book54.xls") #load data ts<- sqlFetch(chan, "Sheet1")
close(chan)
ts<-ts[-1,]

str(ts)
head(ts)
tail(ts)

Regards,

Pierre Lapointe
Assistant Market Strategist
National Bank Financial



AVIS DE NON-RESPONSABILITE:\ Ce document transmis par courri...{{dropped}}

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Wed Jun 08 23:47:03 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:27 EST