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?
output spearman correlationHello, I am trying to output spearman correlation matrix into rtf or excel using estpost but I am g…
How to get excel file from dta file of data set, not results.Hello, I would like to change dta dataset to excel file(not result of analysis, but the data set as…
wanting to run STATA via a websocketHi, I am setting up stata on a Linux server and am hoping there is a way to run stata using websocke…
inspecting and comparing same variable content in relation to other variablePlease am new to stata and need help in extracting wrong inputs in a dataset. The data set contains …
network rank min and sucra prob errorsHi , I am trying to generate a cumulative probability graph and rankograms for my network meta analy…
Subscribe to:
Post Comments (Atom)
0 Response to How do I replace the contents of one variable with that of another?
Post a Comment