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
Nickolas Lyell <[email protected]>
To
"[email protected]" <[email protected]>
Subject
RE: -reshape- question [was: Re: st: Thread-Index: <random garbage>]
Date
Fri, 23 Aug 2013 10:25:18 -0400
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/