Im trying to import data from an excel sheet or a sas file to R...im not succeeding. Apparently the function read.xport for reading a SAS file doesnt exist. What do i have to type in EXACTLY to read from an excel sheet(i guess i would be using read.table?)? Thanks in advance for an answer Dassy
Hadassa Brunschwig wrote:> Im trying to import data from an excel sheet or a sas file to R...im not > succeeding. Apparently the function read.xport for reading a SAS file > doesnt exist. What do i have to type in EXACTLY to read from an excel > sheet(i guess i would be using read.table?)?- read.xport() is in package foreign, so use library(foreign) before using the function. Please read the manual R Data Import / Export. You cannot read from Excel with read.table() directly, but there are at least three other ways, in particular by using RODBC or exporting / importing through in ASCII format. Uwe Ligges> > Thanks in advance for an answer > > Dassy > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help
These functions are in the library "foreign". You may not have loaded the library. Load it first, before using the functions. I tried the following on R1.7.1 on Windows; the functions are available. library(foreign) help(read.xport) help(read.table) In a message dated 8/6/03 11:48:56 AM Eastern Daylight Time, dassybr@hotmail.com writes:> Im trying to import data from an excel sheet or a sas file to R...im not > succeeding. Apparently the function read.xport for reading a SAS file doesnt > > exist. What do i have to type in EXACTLY to read from an excel sheet(i guess > > i would be using read.table?)? > > Thanks in advance for an answer >[[alternative HTML version deleted]]