Hi everyone,
I require urgent assistance!
I have 3 variables about means of transport whose values are 1, 0 in case of having them
X1: Bicycle
X2: Auto
X3: Motorcycle
I need to generate a Means of Transport variable that is binary and that even if the individual has a bicycle, car and motorbike at the same time the result is 1.
X1: 1
X2:1
X3:0
Means of Transport X4: 1 because it already fulfilled the condition of having at least one means of transport.
Another thing, I'm cleaning my data, but I have a problem many of my observations are binary variables and numerical variables, but I have instead of 1 "YES" combined with 1 and instead of 0 "no" combined with zeros, that already corrected.
But where I have Sales values, I have these values: "???" "Not yet"
How do you identify this kind of thing in Stata? or is it better to correct it in Excel?
Translated with www.DeepL.com/Translator (free version)
Related Posts with Help with Data Cleaning
Hep with spmap option polygonHi, Im working in a map of the metro area of Medellín, Colombia. So far good, but when I try to impo…
Comparing each observation from one variable to few hundred thousand in anotherHi all, I am wondering if anyone has any ideas on how I can compare each observation from one varia…
Analyzing length of stay in clustered data (back transform)Hello, I'm a relatively new Stata user and am working on a project. I'm looking at length of stay (…
Predicted probabilities with mimrgns after xtgeeHello, This question refers to Daniel Klein's excellent mimrgns program. I am attempting to obtain …
Calculation of directly standardized rates "distrate" or "dstdize" commandsHello, First of all I dont know if this is the proper site to publish this, correct me if its not. …
Subscribe to:
Post Comments (Atom)
0 Response to Help with Data Cleaning
Post a Comment