Coding issues

[Philippe Kab]

Hello everyone,
I have some difficulties to find the right specifications. I would like to replace some rows by "." if the sum of
(b_meantp1 b_meantp2 b_meantp3 b_meantp4 b_meantp5 b_meantp6 b_meantp7 b_meantp8 b_meantp9 b_meantp10 b_meantp11)==0
Please find attached the dataex data.

* Example generated by -dataex-. To install: ssc install dataex
clear
input int year double(b_meantp1 b_meantp2 b_meantp3 b_meantp4 b_meantp5 b_meantp6 b_meantp7 b_meantp8 b_meantp9 b_meantp10 b_meantp11)
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  1  3  4  4 13 11 18 22
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  2  3  5  6  9 12 25 21
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0 10  9  9 12 19 20 21 17
2000 0 0 0  3 16  8 15 13 21 24 21
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  9 10 11  7 21 20 21 25
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  2  4  4  9 13 12 28 24
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  4  8 16  5 20 21 22 24
2000 0 0 0  1 15  8  8 16 22 24 23
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  4  9 10  7 19 17 25 25
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 2  3  1  5  9 13 17 23 36
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  6  4 10 12 13 28 23
2000 0 0 1  4  2  8 12  9 23 22 31
2000 0 0 0  3  2  8  9  9 19 19 24
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 1  2  3 10  9 10 18 29 25
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  2  5  7  7 15 17 23 22
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  7 13  6 10 20 20 20 24
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 1  5 10 11  7 21 22 18 24
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 1  7  4 16 10 15 26 21 23
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 0  0  0  0  0  0  0  0  0
2000 0 0 2  8 11 10  8 22 17 19 25
end

Thank you for your help.

[Carlo Lazzaro]

Philippe:
you may want to try:

. egen flag=rowtotal( b_meantp*)

. foreach var of varlist b_meantp1-b_meantp11 {
  replace `var'=. if flag==0
  }

. drop flag

[Philippe Kab]

Thank you very much Carlo,
It works well.