[R] R-question

[Wensui Liu]

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.

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)
> >>
> >> ______________________________________________
> >> 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
> >> and provide commented, minimal, self-contained, reproducible code.
> >>
> >>
> >>
> >
> >
>
>
> --
> Frank E Harrell Jr   Professor and Chair           School of Medicine
>                       Department of Biostatistics   Vanderbilt University
>


-- 
WenSui Liu
(http://spaces.msn.com/statcompute/blog)
Senior Decision Support Analyst
Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center