Append datasets of wo different languages

[Doris Schmidt]

Hi all,

I created two almost identical surveys in Qualtrics. I would now like to append both data sets in Stata. I have managed to do that. However, I have the problem that one survey is in German and the other in English. Now Stata shows me, for example, that "Female" and "Weiblich" are two different things.

For example, Stata shoes me that there are 131 Females and 78 "Weiblich". But I need it to say me 209 Females.

Can anybody help me with this problem?

Many thanks in advance.

[Andrew Musau]

If "Q3" is a string variable:

replace Q3="Female" if Q3=="Weiblich"

If it is a numerical variable with value labels, see

help lab list

and

help recode

[Doris Schmidt]

Thank you