Hi!
I have a few questions concerning reading of tables from R to
other programs. My main question is if it’s even possible to read a table
created in R (with the functions data.frame and save) to Excel (or
maybe SAS) and if so how does one do this? If I just mark the table in R
and copy-paste to Excel the whole table ends up in one single cell, (of
course). My goal is to copy the table to Excel (or SAS) in such a
way that a single observation gets placed in a single cell.
If this isn’t possible, is there any way to reduce the number of
digits in a table in R?
I would be more than happy if there were any one who knows the
answer to my questions!
Thanks before hand,
Fredrik Thuring
Research department
Codan Insurance, Copenhagen
------------------------------------------------------------------------------
This e-mail and any attachment may be confidential and may also be privileged.
If you are not the intended recipient, please notify us immediately and then
delete this e-mail and any attachment without retaining copies or disclosing
the contents thereof to any other person.
Thank you.
------------------------------------------------------------------------------
[[alternative HTML version deleted]]
[This email is either empty or too large to be displayed at this time]
Save your table in a text file ( see ?write.table ) with the separator set to "\t" ; you can then import it into excel for the nb of digits use>options(digits=3)see ?options Anne 2005/8/19, Fredrik Thuring <frt at codan.dk>:> > Hi! > > I have a few questions concerning reading of tables from R to > other programs. My main question is if it's even possible to read a table > created in R (with the functions data.frame and save) to Excel (or > maybe SAS) and if so how does one do this? If I just mark the table in R > and copy-paste to Excel the whole table ends up in one single cell, (of > course). My goal is to copy the table to Excel (or SAS) in such a > way that a single observation gets placed in a single cell. > > If this isn't possible, is there any way to reduce the number of > digits in a table in R? > > I would be more than happy if there were any one who knows the > answer to my questions! > > Thanks before hand, > Fredrik Thuring > Research department > Codan Insurance, Copenhagen > > > ------------------------------------------------------------------------------ > This e-mail and any attachment may be confidential and may also be privileged. > If you are not the intended recipient, please notify us immediately and then > delete this e-mail and any attachment without retaining copies or disclosing > the contents thereof to any other person. > Thank you. > ------------------------------------------------------------------------------ > > [[alternative HTML version deleted]] > > > ______________________________________________ > R-help at 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 > >-- Anne
On Fri, 19 Aug 2005, Fredrik Thuring wrote:> I have a few questions concerning reading of tables from R to > other programs. My main question is if it’s even possible to read a table > created in R (with the functions data.frame and save) to Excel (or > maybe SAS) and if so how does one do this? If I just mark the table in R > and copy-paste to Excel the whole table ends up in one single cell, (of > course). My goal is to copy the table to Excel (or SAS) in such a > way that a single observation gets placed in a single cell. >People have told you how to do this for Excel. For SAS you might want to try write.foreign() in the "foreign" package, which writes a text file and a SAS code file that you can use to read it into SAS. -thomas