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?
Identify 100 biggest companies within a firmyearDear all, We are trying to generate a new dummy variable (biggest_comp_d) indicating whether a comp…
Add Trend/Regression line in tslineHello! I have three parameters that measure an examiners performance over time. The data is noted f…
Problem with a synth command : error "uno() invalid -- invalid numlist has too many elements"Dear all, As described in the title, I try to implement the Synthetic Control method on STATA to st…
percentage of missing data for each group?Dear All, Suppose that the data set is Code: webuse grunfeld, clear set seed 1234 replace…
Create local macro already with double quotataion marksDear Statalist I would like to create a local macro for an if-condition that already includes doubl…
Subscribe to:
Post Comments (Atom)
0 Response to How do I replace the contents of one variable with that of another?
Post a Comment