Re: [R] R-question

From: Frank E Harrell Jr <f.harrell_at_vanderbilt.edu>
Date: Wed 13 Sep 2006 - 15:49:01 GMT

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

______________________________________________
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 01:52:54 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 - 20:17:34 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.