Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: St: variable editing


From   Michael McCulloch <mm@pinest.org>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: St: variable editing
Date   Tue, 24 Jun 2008 17:53:00 -0700

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index