It certainly didn't save you time to use Excel (except that you didn't know
about a basic Stata command). In Stata, you could just:
encode country, gen(countrys)
which would create a numeric variable "countrys" that is also labeled with
the string values.
Michael Blasnik
[email protected]
----- Original Message -----
From: "ACHINTYA RAY" <[email protected]>
To: <[email protected]>
Sent: Friday, January 30, 2004 9:53 PM
Subject: st: Re: tsset
> Juan,
>
> I faced the same problem in my work. So I took the harder route and
created
> a numeric ID for each country in Excel and then got the data into STATA.
In
> Excel, this is a piece of cake after you sort your data by the country
name.
> But taking the harder route saved a lot of time for me. May be there is a
> better way out.
>
> Achintya
>
> ***************
> ACHINTYA RAY
> Department of Economics
> Vanderbilt University, VU Station B #351819
> 2301 Vanderbilt Place, Nashville,
> TN 37235-1819, USA
> email: [email protected]
> URL: http://rayatmkt.tripod.com
>
> ----- Original Message -----
> From: "Juan Manuel Jauregui" <[email protected]>
> To: <[email protected]>
> Sent: Friday, January 30, 2004 8:11 PM
> Subject: st: tsset
>
>
> > I have a panel data of countries and years and when entering the command
> tsset
> > country year, I receive the error message that the string is not
allowed.
> > Obviously country is a string. How can I solve this problem? Do I have
to
> > create
> > an id number for each country? How can I do that?
> >
> > Thanks to all of you!
> >
> > Juan
*
* 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/
