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?
Problem with LR test in a multilevel modelDear Statalist, I am trying to figure out if it is necessary to include a random intercept in a thr…
Using a secondary dataset to generate new variables to main dataset given conditionsHi all, So as usual, I'm having a hard time describing what I'm trying to do, which I believe is wh…
lincom after transform_marginsHi I was wondering how to obtain appropriate lincom results after using transform_margins. I am usi…
Multiple imputation takes foreverHello everyone, I'd like to get some help with multiple imputation. I searched everywhere but could…
repeated time values in sample problemHello, I have panel data on cryptocurrencies. Uniquely identified by coin's rank and date. I used ts…
Subscribe to:
Post Comments (Atom)
0 Response to How do I replace the contents of one variable with that of another?
Post a Comment