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. 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) > > ______________________________________________ > 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. > > > -- 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.