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