Date: Wed, 26 Jun 2002 11:38:58 +0800
Reply-To: YCF <s007422@CUHK.EDU.HK>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: YCF <s007422@CUHK.EDU.HK>
Organization: The Chinese University of Hong Kong
Subject: How to make a brief summary table?
Hi all,
After some data treatment, I have information of a dataset like this:
id A(in) M(in) J(in) A(out) M(out) J(out)
a005513 1 0 1 1 0 0
a004422 1 1 0 0 1 0
a003316 1 1 0 0 0 1
The dataset contains many "1" and "0" and A,M,J denote April, May and June
respectively.Now I would like to make a brief summary table which shows the
SUM of each column:
Month Total IN Total OUT
APR 3 1
MAY 2 1
JUN 1 1
Is it possible to do this? I have tried this but it always gives me a
lot of "1" and "0"!!! My expected output is just a simple summary table.
Thanks for your help!!
YCF
|