On Wed, 8 Jun 2005, Lapointe, Pierre wrote:
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.
My Excel ODBC driver is sending NULLs for those rows, so I think this is
an ODBC driver problem.
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
--
Brian D. Ripley, [EMAIL PROTECTED]
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595
______________________________________________
[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
