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).
Try using a double dash (--) not single dash.
Try using a double dash (--) not single dash.
This worked! Thanks.
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.
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);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.