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 <[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) > >> > >> ______________________________________________ > >> [email protected] 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 ______________________________________________ [email protected] 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.
