this is my macro:
%macro ib;
%DO II=1 %to 175;
data aaⅈ
set a1;
if h1=&ii or h2=ⅈ
proc means;
%end;
%mend ib;
%ib
not yet.
I wiil bs"d.
I wrote Macro to solve the problem.
So it sounds like you first should convert your data from wide to tall format and then you can calculate the mean.
data tall ;
set have ;
h=h1; mx=mx1; output;
h=h2; mx=mx2; output;
keep h mx ;
run;
proc means data=tall ;
where h in (101 175);
class h ;
var mx;
run;
Get started using SAS Studio to write, run and debug your SAS programs.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.