LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2003)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SPSSX-L page