Reshape is the command you want; explore the help file for that syntax to be sure and to make sure your i's and j's are clearly identified as you want them to be.
It appears that your data are currently in "long" form and you want to reshape "wide"; and that your i's are date and your j's are permno (firm). When you reshape wide, you're repeating variables (e.g. permno, prc) will be appended with _1, _2, etc. I always find it helpful to sort the data before running a reshape command.
Regards,
Kerry
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Qunzi Zhang
Sent: Thursday, November 01, 2012 11:17 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: reshape problem [was: Re: st: From: Qunzi Zhang <zhangqunzi@googlemail.com>]
Hi Nick,
I am not doing analysis in Stata neither for panel analysis. But using stata, I want to have the format which I shown as before.
Thanks
On Thu, Nov 1, 2012 at 4:13 PM, Nick Cox <njcoxstata@gmail.com> wrote:
> Your data doesn't obviously have a panel identifier, unless it is -permno-.
>
> The command to reshape your data is called -reshape-.
>
> Your data already seem to have the best structure for most panel
> analyses. It's not clear that you will be better off reshaping.
>
> Nick
>
> On Thu, Nov 1, 2012 at 3:06 PM, <owner-statalist@hsphsun2.harvard.edu> wrote:
>
>> 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?
> *
> * 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/
*
* 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/
*
* 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/