[R] Loading the stupid dataset--help!!!
I am using the following: library(RODBC) chan = odbcConnectExcel(rats-lda) rats.lda = sqlFetch(chan, data) close(chan) And getting the following error message: library(RODBC) Error in library(RODBC) : there is no package called ‘RODBC’ chan = odbcConnectExcel(rats-lda) Error: could not find function odbcConnectExcel rats.lda = sqlFetch(chan, data) Error: could not find function sqlFetch close(chan) I am sure there is a simple answer to this. Thanks. -- View this message in context: http://r.789695.n4.nabble.com/Loading-the-stupid-dataset-help-tp4630585.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Loading the stupid dataset--help!!!
On 05/19/2012 07:44 AM, SteveQ wrote: I am using the following: library(RODBC) chan = odbcConnectExcel(rats-lda) rats.lda = sqlFetch(chan, data) close(chan) And getting the following error message: library(RODBC) Error in library(RODBC) : there is no package called ‘RODBC’ The above error message indicates that the ROBDC package is not installed. Have you done an install.packages(ROBDC)? chan = odbcConnectExcel(rats-lda) Error: could not find function odbcConnectExcel rats.lda = sqlFetch(chan, data) Error: could not find function sqlFetch close(chan) I am sure there is a simple answer to this. Thanks. -- Kevin E. Thorpe Biostatistician/Trialist, Applied Health Research Centre (AHRC) Li Ka Shing Knowledge Institute of St. Michael's Assistant Professor, Dalla Lana School of Public Health University of Toronto email: kevin.tho...@utoronto.ca Tel: 416.864.5776 Fax: 416.864.3016 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Loading the stupid dataset--help!!!
?install.packages This functionality may also be available from a menu in an R GUI, e.g. on WIndows. But as you failed to provide your system details -- as requested by the posting guide -- we can't say. HOWEVER ... something appears to be rotten in Denmark (with apologies to Peter D.). IIRC, RODBC is part of the standard library that should be automatically installed when you install R. If so, then why isn't it there? How did you install R? Do you have access to your library directories where RODBC should reside? What other packages do you show in your session? If you post the results of sessionInfo(), someone wiser than I may be able to help you if install.packages() does not suffice. -- Bert On Sat, May 19, 2012 at 4:44 AM, SteveQ coupo...@gmail.com wrote: I am using the following: library(RODBC) chan = odbcConnectExcel(rats-lda) rats.lda = sqlFetch(chan, data) close(chan) And getting the following error message: library(RODBC) Error in library(RODBC) : there is no package called ‘RODBC’ chan = odbcConnectExcel(rats-lda) Error: could not find function odbcConnectExcel rats.lda = sqlFetch(chan, data) Error: could not find function sqlFetch close(chan) I am sure there is a simple answer to this. Thanks. -- View this message in context: http://r.789695.n4.nabble.com/Loading-the-stupid-dataset-help-tp4630585.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Bert Gunter Genentech Nonclinical Biostatistics Internal Contact Info: Phone: 467-7374 Website: http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Loading the stupid dataset--help!!!
I don't think it's part of the standard install -- I certainly didn't get it with Simon's [Mac] CRAN build and when I did download it it's marked with priority NA -- so no need to worry there. Best, Michael On Sat, May 19, 2012 at 10:36 AM, Bert Gunter gunter.ber...@gene.com wrote: ?install.packages This functionality may also be available from a menu in an R GUI, e.g. on WIndows. But as you failed to provide your system details -- as requested by the posting guide -- we can't say. HOWEVER ... something appears to be rotten in Denmark (with apologies to Peter D.). IIRC, RODBC is part of the standard library that should be automatically installed when you install R. If so, then why isn't it there? How did you install R? Do you have access to your library directories where RODBC should reside? What other packages do you show in your session? If you post the results of sessionInfo(), someone wiser than I may be able to help you if install.packages() does not suffice. -- Bert On Sat, May 19, 2012 at 4:44 AM, SteveQ coupo...@gmail.com wrote: I am using the following: library(RODBC) chan = odbcConnectExcel(rats-lda) rats.lda = sqlFetch(chan, data) close(chan) And getting the following error message: library(RODBC) Error in library(RODBC) : there is no package called ‘RODBC’ chan = odbcConnectExcel(rats-lda) Error: could not find function odbcConnectExcel rats.lda = sqlFetch(chan, data) Error: could not find function sqlFetch close(chan) I am sure there is a simple answer to this. Thanks. -- View this message in context: http://r.789695.n4.nabble.com/Loading-the-stupid-dataset-help-tp4630585.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Bert Gunter Genentech Nonclinical Biostatistics Internal Contact Info: Phone: 467-7374 Website: http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.