Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

Re: -reshape- question [was: Re: st: Thread-Index: <random garbage>]


From   Nick Cox <[email protected]>
To   "[email protected]" <[email protected]>
Subject   Re: -reshape- question [was: Re: st: Thread-Index: <random garbage>]
Date   Fri, 23 Aug 2013 16:30:28 +0100

You have probably read irritating interviews in which some rich person
smirks and says, "Well, the first million dollars was the hardest."
(Probably billion these days.)

It won't get in any dictionary of quotations, but the first 10
-reshape-s are the hardest. Then it just clicks. Meanwhile, my own
small struggles are documented at

http://www.stata.com/support/faqs/data-management/problems-with-reshape/

Nick
[email protected]


On 23 August 2013 16:11, Nickolas Lyell <[email protected]> wrote:
> Thanks, I got it to work in a slightly less elegant manner. (using javascript to write all my rename commands)  I'll go back and clean up the code in this manner though.
>
> Cheers,
> --
> Nicholas Lyell
> Research Associate
> National Association of Counties | NACo
> [email protected] | 202.661.8820
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
> Sent: Friday, August 23, 2013 11:00 AM
> To: [email protected]
> Subject: Re: -reshape- question [was: Re: st: Thread-Index: <random garbage>]
>
> . input County description v1990 v1991 v1992
>
>         County  descrip~n      v1990      v1991      v1992
>   1. 1  611  512.2  436.7 347.9
>   2. 1  612   63.4   67.8  83.4
>   3. end
>
> . reshape long v, i(C d) j(year)
> (note: j = 1990 1991 1992)
>
> Data                               wide   ->   long
> -----------------------------------------------------------------------------
> Number of obs.                        2   ->       6
> Number of variables                   5   ->       4
> j variable (3 values)                     ->   year
> xij variables:
>                       v1990 v1991 v1992   ->   v
> -----------------------------------------------------------------------------
>
> . reshape wide v, i(County year) j(desc)
> (note: j = 611 612)
>
> Data                               long   ->   wide
> -----------------------------------------------------------------------------
> Number of obs.                        6   ->       3
> Number of variables                   4   ->       4
> j variable (2 values)       description   ->   (dropped)
> xij variables:
>                                       v   ->   v611 v612
> -----------------------------------------------------------------------------
>
> . l
>
>      +------------------------------+
>      | County   year    v611   v612 |
>      |------------------------------|
>   1. |      1   1990   512.2   63.4 |
>   2. |      1   1991   436.7   67.8 |
>   3. |      1   1992   347.9   83.4 |
>      +------------------------------+
>
>
> Nick
> [email protected]
>
>
> On 23 August 2013 15:50, Nickolas Lyell <[email protected]> wrote:
>> Haha, Thanks Nick.
>>
>> Maybe always the best answer.  Just being a bit lazy I suppose.  (there  is a lot of renaming for 3-digit NAICS codes)
>>
>> --
>> Nick
>>
>> -----Original Message-----
>> From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
>> Sent: Friday, August 23, 2013 10:40 AM
>> To: [email protected]
>> Subject: Re: -reshape- question [was: Re: st: Thread-Index: <random garbage>]
>>
>> Here the best way to learn it is probably to try what you want -- and come back to us if you don't understand the results.
>>
>> I know that could be an answer to almost any question, but I give it nevertheless.
>> Nick
>> [email protected]
>>
>>
>> On 23 August 2013 15:25, Nickolas Lyell <[email protected]> wrote:
>>> Ok.  So when I am attempting to reshape long in time (after the very wide transformation), I will Most likely want to rename my variables to reshape long in time, correct?  (from dec1990211) with "1990" being the year part and "211" being the NAICS code.
>>>
>>> As long as I rename them "NAICS2111990", Stata will understand which part identifies the year? Or will I have to indicate that in the reshape command?
>>>
>>>
>>> Nicholas Lyell
>>> Research Associate
>>> National Association of Counties | NACo [email protected] | 202.661.8820
>>>
>>>
>>> -----Original Message-----
>>> From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
>>> Sent: Friday, August 23, 2013 10:11 AM
>>> To: [email protected]
>>> Subject: -reshape- question [was: Re: st: Thread-Index: <random garbage>]
>>>
>>> Numeric digits 0...9 are fine in variable names so long as they are not offered as first character. Just specify a stub you like in -j()-.
>>>
>>> Nick
>>> [email protected]
>>>
>>>
>>> On 23 August 2013 14:54, Nickolas Lyell <[email protected]> wrote:
>>>> I seem to remember a warning against using numbers for variable names in the reshape command, but I wanted to make sure.
>>>>
>>>> I have a list of county GDP by industry with Industry by county long and GDP by year wide.  I would like to invert this so that I have years by county long and GDP by industry wide.  I know that I cannot use variable names that are more than one word long when transforming to wide, so I would like to turn the “description” variable into it’s industry NAICS code.  IE: “GDP: Educational Services” → 611 .
>>>>
>>>> My data is formatted like this:
>>>>
>>>> County description         1990       1991       1992       …
>>>> 1              611                         512.2     436.7     347.9     …
>>>> 1              612                         63.4        67.8        83.4        …
>>>>
>>>>
>>>> Can I use the 3-digit NAICS codes to reshape my data into wide with numbers as NAICS (year-NIACS) so that I can then reshape it long (so it can be a time series)?
>>>>
>>>>
>>>> Nicholas Lyell
>>>> Research Associate
>>>> National Association of Counties | NACo [email protected] | 202.661.8820
>>>>
>>>>
>>>> *
>>>> *   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/
>>
>> *
>> *   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/
>
> *
> *   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index