How to input observation/row means into missing values

[steveirk]

Hi guys,

OBS      ID      TRIAL1      TRIAL2     TRIAL3      AVG

1           1         1.5              1.4            1.6           1.5

2           2         1.5                .              1.9           1.7

3           3           .                2.0            1.6           1.8

4           4           .                  .              2.2           2.2

5           5         2.1              2.3            2.2           2.2

6           6        1.8               2.0            1.9           1.9

I'm having trouble figuring out how to substitute row average into missing values so for obs 2. how can i input avg 1.7 into trial2 missing value, for obs3 input avg 1.8 into trial1 missing value and so forth? Thank you guys in advance!!!

[steveirk · Accepted solution]

I figured it out:

I used the coalesce function.