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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.