input id t1 t2 t3
1 1.5 1.4 1.6
2 1.5 . 1.9
3 . 2.0 1.6
4 . . 2.2
5 1.9 2.1 2
6 1.8 2.0 1.9
7 . . .
end
As suggested above, I want to create a new variable called sign.
If t2>t1, then sign=1; if t2<=t1, then sign=0.
Because t1 and t2 all have missing values, how can I keep missing values in the new variable "sign" in Stata?
I think the rule is as long as there is a missing value in t1 or t2, then the variable "sign" should be missing value.
Thanks for your Stata code!
Related Posts with How to create a new binary variable (0-1) based on some conditions in Stata?
Monthly last observation in a temporal seriesHi, I have a temporal series with the follow variables: idcompany, lastprice and date (dd/mm/yyyy). …
OutliersDear All, I have a quick question, Is it necessary to remove outliers from survey data? Would that…
Calculation of Kolm–Pollack Index.Hello everybody! I.m trying to calculate the Kolm–Pollack Index of inequality for the distribution …
Adding Variables Gradually in RegressionsHi, I want to add multiple independent variables in the regressions gradually with the same depende…
Hypothesis Testing Regression Coefficients: One-sidedHelpful Link: https://www.stata.com/support/faqs/statistics/one-sided-tests-for-coefficients/ Hell…
Subscribe to:
Post Comments (Atom)
0 Response to How to create a new binary variable (0-1) based on some conditions in Stata?
Post a Comment