st: RE: Re: Replacing certain characters in variable labels.

["Nick Cox" <n.j.cox@durham.ac.uk>]

I guess that what you needed in the first version was 

local a = subinstr("`a'","’","'",.)

rather than 

local a: subinstr("`a'","’","'",.)

The code you ended up with is naturally fine too.

Nick 
n.j.cox@durham.ac.uk 

Anna Reimondos

After a bit more exploration I found the solution:



foreach i of varlist _all {
local a : variable label `i'
local a: subinstr local a "’" "'"
label var `i' "`a'"
}

On Fri, Apr 9, 2010 at 11:49 AM, Anna Reimondos <areimondos@gmail.com> wrote:

> I am currently cleaning a dataset but am having some trouble with the
> variable labels. The variable labels are related to the wording of the
> actual question in the survey.
> For example for the first variable the variable name should   "A
> woman's job is to stay at home?"
>
> However whenever apostrophes are displayed strangely so that in the
> dataset the name looks like "A woman’s job is to stay at home?".
>
> What I would like to do is to replace all occurrences of "’" with an
> apostrophe instead " ' ".
>
> I attempted to do this but it did not work and I am not really sure
> what I am doing...
>
> foreach i of varlist _all {
> local a: variable label `i'
> local a: subinstr("`a'","’","'",.)
> label var `i' "`a'"
> }
>

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/