Hello. I am working with survey data where participants are asked if they agree with a statement, in this case whether they consider themselves a public servant. They can choose between five answers. I would like to create a dummy variable PublicServant where 1 = yes and 0 = all other answers. I am not used to working with non-numerical answers and am unsure of the syntax needed. Do I use quotation marks around the potential answers? Is there a way to consolidate this code and say 1=yes and 0=all other answers?
This is my drafted code but I get a mismatch error:
gen publicservant=.
replace publicservant=0 if PublicServant=="[2] No"
replace publicservant=0 if PublicServant=="[3] Don't Know"
replace publicservant=0 if PublicServant=="[-1] No answer"
replace publicservant=1 if PublicServant=="[1] Yes"
replace publicservant=0 if PublicServant=="[-2] Does not Apply"
Related Posts with Generating dummy variables using non-numerical data
Quintile Sorting two variablesI have monthly observations from various funds over along amount of time but the time series are unb…
Year and industry fixed efffectsHello; I have a paneldataset of the S&P 500 from 2002 to 2019 and need to implement industry an…
R2 difference from different regressionsArray Hello, i'm working on replicating Peters and Taylor(2016) i want to know how to compare R^2 fr…
Very weird spmap problem: "master data not sorted"Hello all Suddenly, I am having some unexplained problem with spmap: syntax which previously was wo…
Displaying results in full form - double formatHi All, I am using the following command, in stata 13.1 total subsidyamt, over(fiscal_year1) to c…
Subscribe to:
Post Comments (Atom)
0 Response to Generating dummy variables using non-numerical data
Post a Comment