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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.