Calculating the mean of three variables with condition

mantubiradar19 — Sat, 23 Jul 2016 16:10:17 GMT

I'm working with BP data - where in they have measured SBP and DBP.

1. I have SBP and DBP measured twice as - SBP1 and SBP2

2. I have the data for SBP3 if - the difference between SBP1 and SBP2 is more than 10

3. I would like to calculate mean SBP using SBP1 and SBP2 if there is no data for SBP3

4. I would like to calculate mean SBP using SBP3 along with SBP2 or SBP1 - based which values (SBP1 or SBP2) are nearest to SBP3.

Can someone suggest me a code for this?

Thanks

if SBP3 is missing then SBP = mean (SBP1, SBP2); else if the diff of SBP1 and SBP2 > 10 then use SBP3; SBP = Mean (SBP1 and SBP3) if abs(SBP3-SBP1) < (SBP2 and SBP3); SBP = Mean (SBP2 and SBP3) if abs(SBP2-SBP3) < (SBP1 and SBP3); run;

Re: Calculating the mean of three variables with condition

PGStats — Sat, 23 Jul 2016 17:43:14 GMT

Code is:

if missing(SBP3) 
	then SBP = mean(SBP1, SBP2);
else 
	if abs(SBP3-SBP1) < abs(SBP3-SBP2) 
		then SBP = mean(SBP1, SBP3);
	else SBP = mean(SBP2, SBP3);

(not tested)

topic Re: Calculating the mean of three variables with condition in SAS Procedures

Calculating the mean of three variables with condition

Re: Calculating the mean of three variables with condition