Statalist


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

[no subject]



Cheers,
Bret

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Michael McCulloch
Sent: Tuesday, June 24, 2008 7:53 PM
To: statalist@hsphsun2.harvard.edu
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/



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