Help with Data Cleaning

[Fiamma Benson]

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)

[Zhe Zhang]

gen X4=1 if X1==1 | X2==1 | X3==1
try the code and see if it's what you want.

[Nick Cox]

Zhe Zhang's helpful answer gets you started, but will produce an indicator variable that is 1 or missing.

Indicators that are 1 or 0 are immensely more useful.

gen wanted = max(X1, X2, X3)

will produce 1 if any input is 1, 0 if otherwise any is 0 and missing if all are missing.

You don't need it for your immediate question but https://journals.sagepub.com/doi/pdf...36867X19830921 is a review of indicator variables in Stata

It's easy enough to look for inconsistent string values in Stata. Many active users here don't use Excel at all, or at all willingly, so there are differing views on its merits.

[Zhe Zhang]

Zhe Zhang's helpful answer gets you started, but will produce an indicator variable that is 1 or missing.

Indicators that are 1 or 0 are immensely more useful.

gen wanted = max(X1, X2, X3)

will produce 1 if any input is 1, 0 if otherwise any is 0 and missing if all are missing.

You don't need it for your immediate question but https://journals.sagepub.com/doi/pdf...36867X19830921 is a review of indicator variables in Stata

It's easy enough to look for inconsistent string values in Stata. Many active users here don't use Excel at all, or at all willingly, so there are differing views on its merits.

Thank you, Nick. I forgot the "replace" step. But your approach is much more desirable!

[Fiamma Benson]

Zhe Zhang's helpful answer gets you started, but will produce an indicator variable that is 1 or missing.

Indicators that are 1 or 0 are immensely more useful.

gen wanted = max(X1, X2, X3)

will produce 1 if any input is 1, 0 if otherwise any is 0 and missing if all are missing.

You don't need it for your immediate question but https://journals.sagepub.com/doi/pdf...36867X19830921 is a review of indicator variables in Stata

It's easy enough to look for inconsistent string values in Stata. Many active users here don't use Excel at all, or at all willingly, so there are differing views on its merits.

do you can help me with this??

876. | XXXt015 |
877. | GGrt2002 |
878. | 0 |
879. | 0 |
880. | WErt002 |
|--------------|
881. | Art2002 |
882. | Xt015 |
883. | Art2002 |
884. | ASXrt2002 |
885. | tr 2002 |
|--------------|
886. | Bsd002 |
887. | AFF4t2002 |
888. | Yt015 |
889. | AHtet02 |
890. | AGtete2 |
|--------------|
891. | ASHH - 2002 |
892. | ASFHtet2 |
893. | AERtrtr |
894. | ASreer |
895. | 0 |
|--------------|

I want to change the text observations to 1

[Joseph Coveney]

I want to change the text observations to 1

This didn't work for you?

.ÿ
.ÿversionÿ16.1

.ÿ
.ÿclearÿ*

.ÿ
.ÿinputÿstr11ÿvar

ÿÿÿÿÿÿÿÿÿÿÿÿÿvar
ÿÿ1.ÿXXXt015
ÿÿ2.ÿGGrt2002
ÿÿ3.ÿ0
ÿÿ4.ÿ0
ÿÿ5.ÿWErt002
ÿÿ6.ÿArt2002
ÿÿ7.ÿXt015
ÿÿ8.ÿArt2002
ÿÿ9.ÿASXrt2002
ÿ10.ÿ"trÿ2002"
ÿ11.ÿBsd002
ÿ12.ÿAFF4t2002
ÿ13.ÿYt015
ÿ14.ÿAHtet02
ÿ15.ÿAGtete2
ÿ16.ÿ"ASHHÿ-ÿ2002"
ÿ17.ÿASFHtet2
ÿ18.ÿAERtrtr
ÿ19.ÿASreer
ÿ20.ÿ0
ÿ21.ÿend

.ÿ
.ÿquietlyÿreplaceÿvarÿ=ÿ"1"ÿifÿmissing(real(var))

.ÿ
.ÿlist,ÿnoobsÿseparator(0)

ÿÿ+-----+
ÿÿ|ÿvarÿ|
ÿÿ|-----|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ0ÿ|
ÿÿ|ÿÿÿ0ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ1ÿ|
ÿÿ|ÿÿÿ0ÿ|
ÿÿ+-----+

.ÿ
.ÿexit

endÿofÿdo-file


.