BookmarkSubscribeRSS Feed
apple
Calcite | Level 5

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

1 REPLY 1
RichardinOz
Quartz | Level 8

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

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 553 views
  • 0 likes
  • 2 in conversation