Help using Base SAS procedures

How to input observation/row means into missing values

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

How to input observation/row means into missing values

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!!!



Accepted Solutions
Solution
‎02-21-2015 12:02 PM
New Contributor
Posts: 2

Re: How to input observation/row means into missing values

I figured it out:

I used the coalesce function.

View solution in original post


All Replies
Solution
‎02-21-2015 12:02 PM
New Contributor
Posts: 2

Re: How to input observation/row means into missing values

I figured it out:

I used the coalesce function.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 193 views
  • 0 likes
  • 1 in conversation