[R] R-question

[Wensui Liu]

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


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