Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Data Management


From   David Ashcraft <ashcraftd@rocketmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Data Management
Date   Wed, 28 Mar 2012 09:37:13 -0700 (PDT)

These all are balance sheet and income statement items e.g. cash, securities, inventory fixed assets sales etc.


----- Original Message -----
From: Joerg Luedicke <joerg.luedicke@gmail.com>
To: statalist@hsphsun2.harvard.edu
Cc: 
Sent: Wednesday, March 28, 2012 7:26:09 PM
Subject: Re: st: Data Management

"In my case v1 v2 v3 have completely different names."

What does that mean? In what way exactly do they differ? What you
posted does not indicate any differences between variable names across
years or years across variable names.

J.

On Wed, Mar 28, 2012 at 9:10 AM, David Ashcraft
<ashcraftd@rocketmail.com> wrote:
> I have my data in the following format
>
> id v1_97 v1_98 v1_99 ...... v1_11 v2_97 v2_98
>
> Each variable span over 15 years and there are total of 200 variables and about 4000 subjects (id). I want to change the dataset in a panel where data can be arranged like this:
>
> id year v1 v2 v3
> 1  1997
> 2  1998
> 3  1999
>
> I thought this  may be the case of RESHAPE - wide to long. In my case v1 v2 v3 have completely different names. Somehow I could not figure out, how to deal with this scenario. Any help will be really appreciated.
>
> Thanks
>
> David
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*  http://www.stata.com/help.cgi?searchhttp://www.stata.com/support/statalist/faqhttp://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index