topic Re: Average of all values only if all values are filled out in SAS Programming

Average of all values only if all values are filled out

pacman94 — Thu, 28 Jan 2021 13:54:47 GMT

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

Re: Average of all values only if all values are filled out

LeonidBatkhan — Thu, 28 Jan 2021 14:06:45 GMT

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.

Re: Average of all values only if all values are filled out

yabwon — Thu, 28 Jan 2021 14:03:40 GMT

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

Re: Average of all values only if all values are filled out

yabwon — Thu, 28 Jan 2021 14:06:10 GMT

Only disadvantage is this:

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

Bart

Re: Average of all values only if all values are filled out

novinosrin — Thu, 28 Jan 2021 14:09:06 GMT

or just-

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