topic Re: Finding range for each row in SAS Programming

Finding range for each row

pubhealthguy — Fri, 06 Sep 2019 02:09:14 GMT

Hi,

I'm trying to analyze data by looking at changes in blood pressure (BP) over three measurements. I would like to add a column to each row that shows the difference between the highest and lowest of the three measurements.

For example: BP1- 120, BP2 - 160, BP3 - 140 -----> Range = (160 - 120) = 40

I am new to SAS and am at a loss of how to approach this. I have looked everywhere for a solution.

Any help would be great.

Thanks.

Re: Finding range for each row

SASKiwi — Fri, 06 Sep 2019 03:03:10 GMT

range = range(of BPZSY1 - BPZSY3);

You will find it useful to bookmark documentation.sas.com:

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n11w5ix15y2l4fn1l8arb0ntlpra.htm&docsetVersion=9.4&locale=en

Re: Finding range for each row

pubhealthguy — Fri, 06 Sep 2019 16:53:55 GMT

This is just what I was looking for.

Thank you for your help!

Re: Finding range for each row

SASKiwi — Fri, 06 Sep 2019 21:51:37 GMT

@pubhealthguy - glad this answer helped. Please update this post as answered.