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}} ______________________________________________ [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
