One way to do it:
Suppose your variable names are
Rohan
Gondor
Shire
Put them in a local macro:
. local vars "Rohan Gondor Shire"
. stack `vars' , into(data) clear
. gen country = word("`vars'", _stack)
With lots of countries, there are
extra tricks.
Nick
[email protected]
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of
> [email protected]
> Sent: 25 March 2004 17:26
> To: [email protected]
> Subject: Re: st: RE: Data manipulation
>
>
> The countries were listed as variable names in the original
> data set. When I
> stacked the data, I was left with only the stack variable,
> and the data stacked
> with only one variable name.
>
> Justin
>
> Quoting Nick Cox <[email protected]>:
>
> > Please tell us how country names were held originally.
> >
> > Nick
> > [email protected]
> >
> > [email protected]
> > >
> > > I am trying to manipulate my data in the following way: after
> > > stacking my data
> > > (and losing the data in memory), I am trying to recover the
> > > country name. So
> > > anytime the stack variable is 1 in the dataset, I want to
> > > input a string into
> > > another variable called "country", when the stack variable is
> > > 2 in the dataset,
> > > I want to input a different string in the "country" variable.
> >
> > *
> > * For searches and help try:
> > * http://www.stata.com/support/faqs/res/findit.html
> > * http://www.stata.com/support/statalist/faq
> > * http://www.ats.ucla.edu/stat/stata/
> >
>
>
>
>
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
