[R] Make matrix from SQL query result

From: Gilbert Wu <gilbert.wu_at_sabrefund.com>
Date: Sat 25 Jun 2005 - 02:36:07 EST


Hi,  

I am trying to form a matrix from a SQL query result.  

The SQL query result looks like this:  

equity_id         date              returns
1                 20050619          0.12
2                 20050619          0.03
1                 20050620          -0.01
2                 20050620          0.01
 

The target matrix looks like this:    

date                     1               2
20050619           0.12            0.03
20050620           -0.01           0.01
 

Any suggestion would be much appreciated.  

Many Thanks.  

Gilbert

        [[alternative HTML version deleted]]



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 Received on Sat Jun 25 02:41:46 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:02 EST