Re: [R] R-question

From: Wensui Liu <liuwensui_at_gmail.com>
Date: Wed 13 Sep 2006 - 15:56:18 GMT

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@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@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@de.ibm.com
> >> (See attached file: Debug1.csv)
> >>
> >> ______________________________________________
> >> 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.
> >>
> >>
> >>
> >
> >
>
>
> --
> 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

______________________________________________
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.
Received on Thu Sep 14 02:00:48 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Wed 13 Sep 2006 - 16:36:06 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.