Dear Stata-Community,
I am currently working on a paper in which I want to create a variable that indicates the number of respondents that mentioned unemployment as most important problem and indicated the same or plus/minus one value on a left-right scale as the party under observation. So in the end, I want a variable for each party in each country that indicates how many respondents, that are (+/-1) close on the left-right scale, said unemployment is the most important problem. Unfortunately, my dataset only contains a country variable (country), a most important problem variable with the unemployment-specification (qpp1==70101), a self-placement variable (qpp13) and eight different party-placement variables for all countries (qpp14_1 to qpp14_8). So my problem is that the Swedish Green Party might be the variable qpp14_3 while this variable in Belgium means a conservative party. The dataset contains 25.000 individual respondents and I want for each of the in qpp14_1 to qpp_14_8 mentioned parties how many potentially close respondents (+/-1) indicated unemployment as most important problem. My question now is: Is there any possibility to automatize this process?
I am using stata version 15.1 and would be very grateful for any ideas.
Thanks in advance!
Robin
0 Response to Generating a new variable based on several specified conditions
Post a Comment