Cross sectional units in my panel data set are currently identified by
names (string variables). I want to make an integer variable out of it such
that it has a new (ascending) value for each new unit. All the standard
routines to "destring" and recode that I could find looking at the help
file would require me to type all the names (>400) at least once.
It might be important to know that the number of time observations differ
between units (unbalanced).
Is there any possibility to do this within state or do I better go back to
excel or gauss for that?
Thanks for your help, Thomas
Thomas Heckelei PhD
Assistant Professor, IMPACT Center and
Department of Agricultural and Resource Economics
Washington State University