Date:         Wed, 15 Jan 2003 19:36:50 -0200
Reply-To:     Marcos Sanches <marcos_sanches@gallup.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Marcos Sanches <marcos_sanches@gallup.com>
Subject:      Re: Frequency table
Comments: To: "Marks, Jim" <Jim.Marks@lodgenet.com>
In-Reply-To:  <442531134F379D43AB31B66530CC4BEB0523DF@Cheney.lodgenet.com>
Content-Type: text/plain; charset="iso-8859-1"

Try this

TABLES
  /FTOTAL $t 'Total'
  /FORMAT BLANK MISSING('.') /TABLES
  (LABELS) > (STATISTICS) + $t BY
  ( var1 + var2 + var3 )
  /STATISTICS COUNT ((F5.0) 'Count' ) .

HTH

Marcos

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Marks, Jim
Sent: Wednesday, January 15, 2003 7:08 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Frequency table


I want to produce a single frequency table for multiple variables:

Here is sample data:

DATA LIST FREE /var1 TO var3 (3f8.0).
BEGIN DATA.
1 1 1
0 0 0
2 1 0
0 0 0
1 1 2
0 1 1
0 2 0
0 1 0
0 0 1
END DATA.

What I want to get is:

Freq    var1    var2    var3
0       6       3       5
1       2       5       3
2       1       1       1

I can get the frequencies individually, or I can get  the combined
frequencies (via multiple response).

I can do this in excel (using countif), but I am trying to avoid  creating
hundreds of formulas in excel.

Any help appreciated

Jim Marks