[R] R-question

[Frank E Harrell Jr]

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 <f.harrell at vanderbilt.edu> 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 <MUEHGE at de.ibm.com> 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: muehge at de.ibm.com
>> >> (See attached file: Debug1.csv)

-- 
Frank E Harrell Jr   Professor and Chair           School of Medicine
                      Department of Biostatistics   Vanderbilt University