DATA Step, Macro, Functions and more

min, max, mean, std of values in a single observation

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

min, max, mean, std of values in a single observation

I have the following data set resp:

PatientID  RespRate1  RespRate2 ....  RespRate20

XYZ           16                18                       17

ACW          21                17                       21

 

For each row (PatientID) I want to be able to obtain the min, max, mean, and std of the first 10 respiratory rates, then the next ten respiratory rates. I wanted to do this:

 

data resp; set resp;

    min1 = min(of RespRate1-RespRate10);

   max1 = min(of RespRate1-RespRate10);

  mean1 = min(of RespRate1-RespRate10);

  std1 = min(of RespRate1-RespRate10);

   min2 = min(of RespRate11-RespRate12);

   max2 = min(of RespRate11-RespRate20);

  mean2 = min(of RespRate11-RespRate20);

  std2 = min(of RespRate11-RespRate20);

run;

       

Yet the min, max, mean, and std functions don't work unless you list out all of the variables, i.e. min1 = min(RespRate1, RespRate2, RespRate3.... RespRate10).

 

Any ideas on how to do this in Base SAS (I dont want to go over to IML in this instance).

Andrew A. Kramer, PhD
President
Prescient Healthcare Consulting

Accepted Solutions
Solution
‎04-19-2017 10:00 AM
Super User
Posts: 17,912

Re: min, max, mean, std of values in a single observation

Try using a double dash (--) not single dash. 

View solution in original post


All Replies
Solution
‎04-19-2017 10:00 AM
Super User
Posts: 17,912

Re: min, max, mean, std of values in a single observation

Try using a double dash (--) not single dash. 

Contributor
Posts: 28

Re: min, max, mean, std of values in a single observation

This worked! Thanks.

Andrew A. Kramer, PhD
President
Prescient Healthcare Consulting
Super User
Posts: 5,095

Re: min, max, mean, std of values in a single observation

There's nothing wrong with the code you are using.  Why do you say it doesn't work?  The only reason I could think of is if you have some character variables instead of numeric.  Of course, you need the numeric values populated ... missing values in the input will generate missing values in the output.

Super User
Posts: 17,912

Re: min, max, mean, std of values in a single observation

Note double dash only works if the variables are side by side. Other option is to declare arrays which you may want to do, if you're doing multiple calculations. 

 

Note you have a typo in one of your ranges. 

 

Array firstTen(*) resprate1-resprate10;

 

mean1 = mean( of firstTen(*));

mean2 = mean(of resprate1--resprate10);

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 160 views
  • 0 likes
  • 3 in conversation