Re: Re : Count percentage of Break Variables

[Eric Black]

I used to create dummy variables for those categories - with 4 age
categories, that would be 8 dummy variables which are sysmis for men or
women if you have the age segments for women or men.  You can then use the
mean to aggregate

I am sure there are other ways to do it but this worked well for me.



On Tue, 21 Feb 2012 23:25:15 +0800, deepanshu bhalla
<[hidden email]> wrote:

>Let's say two variables age and gender . I want to compute percentage of
females who belong to

�20-24,25-29 ,29-34 and 34-above age categories.

Gender �Age
1 � � � � � 20-24
1 � � � � ��25-29
2 � � � � ��25-29
2 � � � � ��29-34�
1 � � � � ��29-34�
2 � � � � ��34-above
1 � � � � � �20-24�
1 � � � � � �20-24��
2 � � � � � �20-24
1 � � � � � �20-24


I know this can easily be done using Custom Table function in SPSS but i am
just curious to know whether this can be done using Aggregate function !


Thanks in advance!

________________________________
 From: David Marso <[hidden email]>
To: [hidden email]
Sent: Tuesday, 21 February 2012 6:51 PM
Subject: Re: Count percentage of Break Variables

Please define what
 you mean by "count percentage of break variables"
preferably demonstrating with a simple numeric example of inputs and desired
output!!
---

deepanshu bhalla wrote

>
> Hi Team,
> �
> I want to calculate count percentage of break variables� using Aggregate
> function.
> �
> Below the syntax which i used. In the syntax i  am calculating count of
> break variables .Is there any way we can calculate count percentage of
> break variables?
> �
> DATASET DECLARE demo003.
> AGGREGATE
> Â  /OUTFILE='demo003'
> Â  /BREAK=demo0003 QCL_1
> Â  /Num=N.
> �
> �
> Where demo0003 and QCL_1 are variable names.
> �
> Note : I know how to use PIN or FIN function but it works only on
> aggregated variables.
> �
> �
> Thanks in advance!
>

--
View this message in
 context:
http://spssx-discussion.1045642.n5.nabble.com/Count-percentage-of-Break-Variables-tp5501319p5502167.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD