Date:         Tue, 4 Jun 2002 10:32:00 -0400
Reply-To:     "Fehd, Ronald J." <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J." <rjf2@CDC.GOV>
Subject:      Re: Simple Frequency Table?
Comments: cc: "Fay, Richard M. (Mike)" <rmf4@cdc.gov>
Content-Type: text/plain

> From: Mike Fay [mailto:rmf4@CDC.GOV]
> I'm a beginner and want a tabulation of my data as follows.

you're looking for the tables option list:
proc FREQ data = LIBRARY.DATA1;
          tables A * B * C * D
          /      list
                 %*missing sparse %*try these, too;
                 ;

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2@cdc.gov

RTFM: I'm an engineer, I don't get paid to know,
I get paid to know where to look it up.
RTFM: Read The Finite Manual.

> Proc Freq and
> Proc Tabulate keep trying to give me 1 x 1 or 2 x 2 tables
> etc. instead of a summarization as shown.
>
> I have four variables whose values are 1 or 0 (they go to 0,
> going from left to right):
>
>    A  B  C  D
>    1  1  0  0
>    1  1  1  1
>    1  1  1  0
>    1  0  0  0
>    1  1  0  0
>
> All I want is a count (N). So for the example above, since
> only one of the six lines repeat, the count would be:
>
>    A  B  C  D  N
>    1  1  0  0  2
>    1  1  1  1  1
>    1  1  1  0  1
>    1  0  0  0  1
>
> That's all I want. But like I say, Freq and Tabulate keep
> trying to do them
> individually (count of A's 1s and 0s) or as 2x2 tables, no
> matter how I
> word the Tables keyword, etc. This is very simple in Access... just
> checkmark the fields and add a Count field.