Here is my data and I want create the new variable in the stata based on the information given in the data. But when I apply the following command, I do not see the correct calculation. (Variable are in numeric format when I do the analysis)
1- New_Var1: should have value of either var2 or var3, whichever is the bigger.
my command " gen New_Var1= var1 if var1>var2"
"replace New_Var1= var2 if var2>=var1"
When I check the results, it does not show the right answer. The below data is just an example, my real data has some missing values. Do I need to put somethings in the command for missing value?
Thanks in advance
clear
input str4(var1 var2 var3)
"var1" "var2" "var3"
"1" "12.4" "10.9"
"2" "9.5" "9.3"
"3" "13.2" "7.6"
"4" "14.5" "9.9"
"5" "12.1" "12.4"
"6" "17.6" "25.0"
"7" "15.4" "12.8"
"8" "7.9" "7.8"
"9" "16.7" "14.5"
"10" "10.6" ""
end
Related Posts with New Variable
Identifying outlier clustersHello everyone, I have an unbalanced panel data set which consists of 5000 banks operating in 38 co…
Selecting variables in a dataset from observations within another datasetHello, Hope there is someone who could help me to solve this... I have a dataset with monthly retu…
🐛 Suspected bug in frames handling of dataDear All, I think I have encountered a bug in Stata where using a temporary frame may result in dat…
convergence with SEMDear all, I use STATA 15.1 to build a full model with SEM. In the final process, STATA shows me th…
can one use MATA within an ML programI am trying to write a customize likelihood function, where I want to numerically integrate using MA…
Subscribe to:
Post Comments (Atom)
0 Response to New Variable
Post a Comment