Generating dummy

[Tim Huizingh]

Dear Community,

I am trying to generate a dummy for current Y and N values.
My code looks like this:
gen CGCPO09Vbyte = .
replace CGCPO09Vbyte = 1 if CGCPO09V == "Y"
replace CGCPO09Vbyte = 0 if CGCPO09V == "N"

However, Stata makes no changes when I use this command:
. gen CGCPO09Vbyte = .
(11,894 missing values generated)

. replace CGCPO09Vbyte = 1 if CGCPO09V == "Y"
(0 real changes made)

. replace CGCPO09Vbyte = 0 if CGCPO09V == "N"
(0 real changes made)

It does not recognize the Y and N, and I do not know how to solve this.

The variable list looks like this:

Please let me know what I am doing wrong, thank you in advance

[Nick Cox]

Full real name please. See https://www.statalist.org/forums/help#realnames and https://www.statalist.org/forums/help#adviceextras #3

More important: No data example here, just an image, contrary to advice at https://www.statalist.org/forums/help#stata

My best guess is that you have multiple spaces there as well as characters Y and N, so try

replace CGCPO09V = trim(CGCPO09V)

and then try again. If no change, we need to know more about your data. Please read about dataex at the last link above.

[Tim Huizingh]

Thank you so much! The spaces were indeed the problem. Everything works fine now.
I have sent a message to the site moderators, asking them to change my username to my real full name

[Nick Cox]

Good!