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?
Check if a group of variables exists before running a series of commandsHi I have other two questions for you all. I have a number of datasets (about 250) and I want to cr…
Equation not found after gsem + ImputationDear all, using Stata 15.1, I want to run a gsem model after Multiple Imputation. First I impute usi…
Collapse dataHi, Having monthly panel data, I want to convert from monthly to quarterly. Used these following op…
How can I handle "id: maxvar too small" in Bayesian binary item response theory model using bayesmhPlease house I need help on this, I have gone through manual, blog stata and past statalist post. Th…
Store regression results of a loop in a new datasetHello everybody, I am new in this forum and I hope that I will get some advice from you. I would l…
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