st: From: Qunzi Zhang <zhangqunzi@googlemail.com>

[owner-statalist@hsphsun2.harvard.edu]

Dear All

May I ask you a question about construction the data set?

Currently I have the following panel data format
permno    date    prc
27174    19700102    56.375
20386    19700102    34
12052    19700102    28.75
27174    19700101    56.375
20386    19700101    34
12052    19700101    28.75



in Stata, how can I reshape the data and get the format as below: a
big matrix the row is the date, column is the firm identity permno and
input is the stock price?

date          firm 1 firm2 firm3 .....(permno as identifer index for firm)
19700101   56.37 5.37 6.35
19700102  .7  .37 .35


I think merge could be the correct command but using it might create a
lot of dta wrt each firm.... Can you please suggest me an efficient
way to do this?
Thanks a lot in advance
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/