Save the results of data analysis in R

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110616/f37a7ebb/attachment.pl>
Hi everyone,

     I want to do data analysis using the values retrieved from a MySQL
database. Is there a way to save the results of data analysis in R.

Hi amrita,
If you mean "save the output of an analysis", there are several ways.

1) Enter "sink(<filename>) before running the analysis, and "sink()" 
after. This will store the results of whatever you did between the two 
"sink" commands in the file <filename> (which is the name you choose to 
call it).

2) Write your analysis as a script and use a function like "htmlize" to 
convert the output to HTML and store it. This allows you to get most 
bitmapped plots embedded in the output, which is what many people want.

For both of the above, you will want to write and test the R script 
until it runs correctly, then use "sink" or "htmlize" (or other 
functions from, say, the R2HTML package) to do the conversion. There are 
similar functions that will convert the output to document formats like 
Latex if you want.

Jim
On 06/16/2011 07:12 PM, amrita gs wrote:
Hi everyone,

     I want to do data analysis using the values retrieved from a MySQL
database. Is there a way to save the results of data analysis in R.

Hi amrita,
If you mean "save the output of an analysis", there are several ways.
...and if you mean "save the R objects" you need to look at save().

cheers,
Paul
1) Enter "sink(<filename>) before running the analysis, and "sink()"
after. This will store the results of whatever you did between the two
"sink" commands in the file <filename> (which is the name you choose
to call it).

2) Write your analysis as a script and use a function like "htmlize"
to convert the output to HTML and store it. This allows you to get
most bitmapped plots embedded in the output, which is what many people
want.

For both of the above, you will want to write and test the R script
until it runs correctly, then use "sink" or "htmlize" (or other
functions from, say, the R2HTML package) to do the conversion. There
are similar functions that will convert the output to document formats
like Latex if you want.

Jim

______________________________________________
R-help at 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.

Paul Hiemstra, Ph.D.
Global Climate Division
Royal Netherlands Meteorological Institute (KNMI)
Wilhelminalaan 10 | 3732 GK | De Bilt | Kamer B 3.39
P.O. Box 201 | 3730 AE | De Bilt
tel: +31 30 2206 494

http://intamap.geo.uu.nl/~paul
http://nl.linkedin.com/pub/paul-hiemstra/20/30b/770