Help using Base SAS procedures

Calculating the mean of three variables with condition

Reply
Contributor
Posts: 57

Calculating the mean of three variables with condition

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

 

OR

 

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;

 

Respected Advisor
Posts: 4,655

Re: Calculating the mean of three variables with condition

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)

PG
Ask a Question
Discussion stats
  • 1 reply
  • 189 views
  • 2 likes
  • 2 in conversation