Hi,
I got some survey data. The raw data is in text, like for example there was a question about education where the responses are "undergraduate degree", "postgraduate degree" etc. Now, I'd like to turn this into binary variables (one "undergraduate" variable, one "postgraduate" variable etc). I know that this can be done manually though it's quite time-consuming, but I was wondering if this process could be automated somehow using STATA.
I was thinking of generating a variable and then have the variable take the value 1 when the response was in a certain way (so the value "undergraduate" takes the value 1 when the response is "Undergraduate degree". However, when I tried this I got a "type mismatch" error.
Is there any way to get around this or should I just start translating the data into 1's and 0's manually?
Related Posts with Creating variables from text
Unable to obtain marginal effects after cmclogitDear all, I am trying to run the postestimation command for marginal effects after an alternative s…
Define subroutine in a .do fileHi, I have a large do file that I would like to break down in several smaller pieces of code that I…
Dealing with missing dataHi, I use the following equation for calculating return for a portfolio of stocks. gen MOMf3_p1= ( …
Using Foreach with loop to calculate averageHi, I want to calculate average of a variable X for all households for each 200 categories on varia…
Reshaping matched panel dataHi I am working with a panel data of firms (BvDIDnumber/BvDIDnumber_U being the unique firm ID for …
Subscribe to:
Post Comments (Atom)
0 Response to Creating variables from text
Post a Comment