If Proc SQL supported the median statistic I would have suggested that. The easiest method to code would be a couple of Proc Summary (alter ego of Proc Means) statements followed by a merge:
Proc Summary data = A ;
Var X ;
Output out = A_Stat
mean = Mean_XA
median = Median_XA
;
Run ;
Proc Summary data = B;
Var X ;
Output out = B_Stat
mean = Mean_XB
median = Median_XB
;
Run ;
Data Want ;
Merge A_Stat B_Stat ;
Run ;
[Not tested]
Richard in NZ
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.