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: Creating new variables from a STATA panel dataset


From   Billy Schwartz <wkschwartz@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Creating new variables from a STATA panel dataset
Date   Thu, 4 Aug 2011 13:46:36 -0400

tsset t //for using the lag operator. not necessary though since you
can always use _n-1 subscripting
foreach var of varlist *_oldextension {
    local countrycode = regexr("`var'", "_.*", "") //chops off the
name of the variable stored in macro var
    generate `countrycode'_newextension = (`var' - L.`var') / L.`var'
}



On Wed, Aug 3, 2011 at 1:10 PM, Nick Cox <njcoxstata@gmail.com> wrote:
>
> * cannot be part of a variable name.
>
> Nick
>
> On 3 Aug 2011, at 17:14, Lucio Vinhas de Souza <lvdesouza@yahoo.com> wrote:
>
>> Dear All,
>>
>> Very basic question, for someone that has not used STATA for several years
>> now: I have a panel dataset (adequately tis t and iis id) of several hundred
>> variables, and I want to:
>>
>> a)    Generate new variables
>> b)    Run a xtbond from those new variables
>>
>> I have been trying to generate new variables which are change rates form
>> the existing ones. The names of the existing variables are all variations
>> from the format “countrycode_extension”. I have been trying to
>>
>> gen “*_extension_new”=((“*_extension”-“*_extension_new”[_n-1])/
>> “*_extension_new”[_n-1])
>>
>> and always get the message
>>
>> *invalid name
>>
>>
>
> *
> *   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?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