Wensui Liu wrote: > well, Harrell, > > I understand sweave or R2html could be a solution. > > but please show me their applications in a large business setting. On > the contrary, I can give you many such cases using SAS.
SAS requires much more coding than R/S-Plus to produce reports that are not nearly as beautiful or informative. Please define 'large business setting'. R is being used routinely in many large businesses. Frank > > On 9/13/06, Frank E Harrell Jr <[EMAIL PROTECTED]> wrote: >> Wensui Liu wrote: >> > For your 1st question, you can write query against the tables in DB >> using RODBC. >> > >> > Being a SAS programmer, I have to say that reporting function of R is >> > not as good as that of SAS. >> >> I beg to differ. See for example >> http://biostat.mc.vanderbilt.edu/StatReport >> >> Frank Harrell >> > >> > >> > >> > On 9/13/06, Thorsten Muehge <[EMAIL PROTECTED]> wrote: >> >> >> >> Hello Colleagues, >> >> I programmed in SAS for 3 years and would like to switch to a not >> so costly >> >> software product. >> >> >> >> Hence I started to evaluate R, and my first test look promising. >> >> >> >> However I have some question: >> >> >> >> 1. Is it possible to query R files by SQL internally on data frames >> (not on >> >> a database) and how is the syntax (I have the RODBC package >> installed). >> >> >> >> I would like to extract year, Quarter, week, from a date column in >> a data >> >> frame (see attachment). After this I want to attach the column to the >> >> original data frame. >> >> >> >> How do I do this in R? >> >> >> >> Dr .Th.Mühge, >> >> >> >> PMP(r) >> >> Procurement Technology Center >> >> IBM Deutschland GmbH, Hechtsheimer Str.2, D-55131 Mainz >> >> Phone: xx49-(0)6131-84-2416 >> >> Mobile: xx49-(0)15117457978 >> >> e-mail: [EMAIL PROTECTED] >> >> (See attached file: Debug1.csv) -- Frank E Harrell Jr Professor and Chair School of Medicine Department of Biostatistics Vanderbilt University ______________________________________________ R-help@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 and provide commented, minimal, self-contained, reproducible code.