Date:         Wed, 14 Feb 1996 09:01:09 EDT
Reply-To:     John R Gerlach <John_R_Gerlach@SBPHRD.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         John R Gerlach <John_R_Gerlach@SBPHRD.COM>
Subject:      Re-shape problem

In regards to the 're-shape the data' problem:
 
     Use the FREQ procedure with the SPARSE
and OUT= options, as follows:
 
data one;
   input id $ grp $ sex $ smoking $;
cards;
101     exp     m       y
101     exp     m       y
104     exp     m       n
105     exp     f       n
105     exp     f       n
103     con     m       n
102     con     f       y
102     con     f       y
;
 
proc freq data=one;
   tables grp * sex * smoking / sparse out=counts noprint;
run;
 
proc print;
   title 'COUNTS Data Set';
run;
 
 
--- John R Gerlach