Date:         Mon, 27 Sep 2010 05:48:53 -0400
Reply-To:     SUBSCRIBE SAS-L Olivier Van Parys <olivier.vanparys@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SUBSCRIBE SAS-L Olivier Van Parys <olivier.vanparys@GMAIL.COM>
Subject:      Easier way to produce tables

Hi Folks,

I am trying to change a bad habit I have have acquired, when checking
predictor in a model with Y as the variable to predict and Pred1... PredN
representing N binomial predictors - I usually run the following:
proc summary data=DB;
class Pred1;
var Y;
output out=table_pred1;
...
proc summary data=DB;
class PredN;
var Y;
output out=table_predN;

That give me N table which I then collate back together using excel. This
obviously ends up being a rather time consuming & tedious process. I was
wondering what would be a better /more efficient syntax to produce the final
table (i.e. A single table with Predictors on each row showing the average Y
when Pred=1 or Pred=0).

Thanks again for your tips,

Olivier