Average of all values only if all values are filled out

[pacman94]

I would like to average all values ONLY if all values are filled out. 0 doesn't mean missing. if the values are not filled out, then they should be blank

ID	value1	value2	value3	value4
1	8	2	2	6
2	5		0	10
3	3	4	3	6
3	6	2	0	6

Want

ID	value1	value2	value3	value4	average_values
1	8	2	2	6	4.5
2	5		0	10
3	3	4	3	6	4
3	6	2	0	6	3.5

This is what i have so far

data test; set raw;

average_values = MEAN(value1, value2, value3, value4);

run;

it still calculates all average 

[LeonidBatkhan]

Hi pacman94,

You can achieve this with the following code:

options missing=' ';

data test;
    set raw;
   average_values = (value1+value2+value3+value4) / 4;
run;

Hope this helps.

[yabwon]

Only disadvantage is this:

NOTE: Missing values were generated as a result of performing an
      operation on missing values.

Bart

[yabwon]

data test; 
  set raw;
  if nmiss(value1, value2, value3, value4) then average_values =.;
  else average_values = MEAN(value1, value2, value3, value4);
run;

[novinosrin]

or just-

  if not nmiss(value1, value2, value3, value4) then 
 average_values = MEAN(value1, value2, value3, value4);