Cheers,
Bret
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Michael McCulloch
Sent: Tuesday, June 24, 2008 7:53 PM
To: [email protected]
Subject: Re: st: St: variable editing
Don't know how to do this in Stata, but one approach would be:
1. export from Stata to a text file
2. open with MS WORD, and remove the asterisks doing a global Find-and-Replace, 3. copy and paste from WORD to EXCEL, 4. save as *.csv 5. re-importing the data using infile or insheet.
Michael
>Greetings,
>
>I have several data sets (from the World Bank Governance indicators)
>where the names of countries sometimes have one or two asterisks
>following their names, e.g.:
>
>Afghanistan
>Albania**
>Armenia
>Azerbaijan*
>
>etc. I want to get rid of the asterisks to merge them with a master
>data set. Aside from editing each name individually, I presume that
>there is an easier way that I just don't know. Any help would be
>greatly appreciated.
>
>Thanks,
>
>Ric Uslaner
>
>
>
>
>*
>* 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/
