In essence I want to tell STATA that when variable F11 = "Ya" replace it with the value in variable Score (SCREENSHOTS attached). [1]: https://i.stack.imgur.com/UvfDl.png
So basically I want to replace the contents of the variable "F11" as well as all the other indicator numbers (A01, B02, C03 etc.) with the score that applies to that indicator.
So for example, for the first observation in the screenshot, that person received a score of 19.88 (variable is Score) for the indicator F-11 (variable is Kat_Indikator_KG) and the label "Ya" under the varibale F-11 tells us that that individual was scored for this category.
What I would like to do is replace the "Ya" with the score obtained in variable "Score" and I would like to do that for all the indictor variables e.g. (A01, B02, C03 etc.)
So far I've tried the following, but none seem to work:
replace F11 = Score if Kat_Indikator_KG == "F-11"
replace F11 = Score if Kat_Indikator_KG == "F-11"
replace F11 = Score if Kat_Indikator_KG == "F-11" & F11 == "Ya"
replace F11 = Score if F11 == "Ya"enter code here
Screenshots are attached and help is appreciated!
[1]: https://i.stack.imgur.com/UvfDl.png
Related Posts with How do I replace the contents of one variable with that of another?
Number of IDs per groupHi all, I have panel data with an identifier(ID) and a time variable(mofd, monthly). Based on a cha…
Label firms with certain consecutive criteriaHi there, This sounds silly but i am stuck here for a while. I have a question regarding labelling f…
Help for analysis method in field trialHi My study is about finding the most effective intervention to reduce the risk factors of non-comm…
Regression tables with esttab - display confidence interval & p-valueHi, I am using esttab to create tables after logistic regression. I present the OR & the 95%CI …
Choosing between OLS, RE and FEDear Statalisters, I have an unbalanced panel data (N=19 and T=9), I want to choose between runnin…
Subscribe to:
Post Comments (Atom)
0 Response to How do I replace the contents of one variable with that of another?
Post a Comment