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
Carhart 4 factor modelHi there, I am currently doing some analysis looking at the affect of CSR on stock returns during a…
help with mergeHello! I really had a headache with merge. I have a dataset with the following relevant variables: …
Reporting populations size using svy: (subpop)Hello, I am working on a project with survey data. I use the svy: subpop command when running the r…
Hello FriendsHello Friends, I ran a MG command and STATA displayed an error message which reads: "invalid new va…
Compute column-vector correlations for external validity?Hi Statalists! I was reading Gosling, Rentfrow, and Swann Jr.'s (2003) "A very brief measure of the…
Subscribe to:
Post Comments (Atom)
0 Response to Help with Data Cleaning
Post a Comment