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
Non-parametric regression estimations to understand relationship between 2 variables: npregress, lpoly vs lowessI am trying to understand the relationship between two variables with non-parametric regressions usi…
Interaction in linear regressionI have a question regarding interaction in linear regression: For example, I have run a regression …
VECM diagnostics and testsDear all, I have four variables, one of which is the price of crude oil and the other three variabl…
Looping over if statementsI want to write code that loops over various if conditions in a regression. I have data like this: …
Difference in DifferencesHi, I have a question about how to code the variables in the following DID equation. Dep.Var= B1 IF…
Subscribe to:
Post Comments (Atom)
0 Response to Help with Data Cleaning
Post a Comment