Proc Means

apple — Tue, 26 Nov 2013 08:27:23 GMT

New to SAS

I want to find the mean, median for variable X

in Dataset A

& Dataset B.

I want the mean & median for both datasets to display side-by-side in the same table, how do I do it?

Thank you

Re: Proc Means

RichardinOz — Tue, 26 Nov 2013 09:28:08 GMT

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

topic Proc Means in SAS Programming

Proc Means

Re: Proc Means