How to replace missing values for certain rows

Question

I'm wondering how to replace missing values in Stata for certain rows only (as noted above).

I have a long column with 842 cells. The first 160 should be 1, and the rest should be 0. However, I have missing values scattered throughout 1-842. How can I replace the missing values in 1:160 with 1, and the missing values in 161:842 with 0?

Welcome to SO! Which rows? How will you identify them? What have you tried? What do you want to replace them with? — Stuart
– Stuart, Commented Apr 27, 2020 at 4:22
Hi Stuart! I Have a long column with 842 cells. The first 160 should be 1, and the rest should be 0. However, I have missing values scattered throughout 1-842. How can I replace the missing values in 1:160 with 1, and the missing values in 161:842 with 0? — Nick Cox
– Nick Cox, Commented Apr 27, 2020 at 4:30
To Stata programmers, rows are observations and columns are variables. Stern conventions here to focus on the technical question and answer are friendlier than they may seem: everyone benefits long-term from avoidance of personal comments. — Nick Cox
– Nick Cox, Commented Apr 27, 2020 at 7:00

Wouter · Accepted Answer · 2020-04-27 06:37:13Z

2

replace myvar = cond(_n <= 160, 1, 0) if missing(myvar)

answered Apr 27, 2020 at 6:37

Wouter

3,27110 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to replace missing values for certain rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related