Date:         Wed, 21 Sep 2005 16:03:10 -0500
Reply-To:     "Oliver, Richard" <roliver@SPSS.COM>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Oliver, Richard" <roliver@SPSS.COM>
Subject:      Re: Create denominator from Frequencies
Comments: To: Arthur Aguirre <arthur.aguirre@INCEPTA-MI.COM>
Content-Type: text/plain; charset="us-ascii"

If you have SPSS 13 or later:

AGGREGATE
  /OUTFILE=*
  MODE=ADDVARIABLES
  /BREAK=country
  /freqVar=N.

If you have an earlier version, it requires a little more work, involving temporary files and MATCH FILES with a table lookup file.



-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Arthur Aguirre
Sent: Wednesday, September 21, 2005 12:20 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Create denominator from Frequencies

Hi group,

Say I have these data.

DATA LIST LIST /country.
BEGIN DATA
1
1
1
1
1
1
1
1
1
1
2
2
2
2
3
3
END DATA.

freq/var = country .


How can I create a variable equal to the frequency of variable country?
I would like to use this variable (frequency count) as the denominator in a calculation.

Denominator should be 10, 4, 2 for country 1, 2, 3, respectively.

Thanks.
Arthur


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________