Statalist


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

Re: st: dummy variable name from a string variable


From   Ada Ma <heu034@googlemail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: dummy variable name from a string variable
Date   Fri, 13 Nov 2009 14:13:52 +0000

You have only 10 city codes, I presume?

One way to do it is to:

for any NY (put all your city codes here): gen citydummy_X=city=="X"

Note.  One, this is a v old Stata command but it still works.  Two,
whatever behind the colon, you put X in places where you want your
city codes appear, regardless of whether they are in the string
variable, in the variable name, etc.

HTH
Regards,
Ada

On Fri, Nov 13, 2009 at 2:06 PM, tom j <tomstata@gmail.com> wrote:
> I want to create 10 dummy variables based on one string variable
> "city", which lists the city codes (like NY) of 10 cities. I can do
> this simply by (after encoding the city variable):
>
> tabulate city, gen(citydummy)
>
>
> This would create citydummy1 to citydummy10. What I want is to suffix
> each dummy with city codes, listed in the variable 'city' , so I have
> the dummy variables named from, for example, citydummyNY to
> citydummyAM.
>
> The city variable has multiple occurrences of each code. I have had a
> look at -renvars- but I don't think that alone will solve my problem.
>
> Any ideas?
> Tom.
> *
> *   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/
>



-- 
Ada Ma
Research Fellow
Health Economics Research Unit
University of Aberdeen, UK.
http://www.abdn.ac.uk/heru/
Tel: +44 (0) 1224 555189
Fax: +44 (0) 1224 550926

*
*   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   |   What's new   |   Site index