Data management question
Try ?reshape Carlos J. Gil Bellosta http://www.datanalytics.com Quoting "Daye, Wilfred" <wilfred.daye at dbzco.com>:
I have a text file data that looks like this Date ticker price 06/1/06 A x1 06/2/06 A x2 ;; ;; ;; 06/1/06 B y1 06/2/06 B y2 ;; ;; ;; 06/1/06 C z1 06/2/06 C z2 ;; ;; ;; So on I want to arrange tickers as column fields and match the time series price by date. To be Date A B C 06/1/06 x1 y1 z1 The time series per ticker does not necessarily equal to those of others Thx in advance