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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.