SPSSX Discussion

CTABLES

Classic

List

Threaded

6 messages Options

Edward Boadi

CTABLES

Will be grateful if anybody can help resolve this :

Table 1 below was produced using the following syntax :

* Custom Tables.
CTABLES
/VLABELS VARIABLES=Var1 Var2 Var3 DISPLAY=DEFAULT
/TABLE Var1 > Var2 [COUNT F40.0, LAYERPCT.COUNT PCT40.1] BY Var3 .

Table 1
Var1 Var2 Var3
# %
a m 10 13.5
f 12 16.2
b m 23 31.1
f 8 10.8
c m 9 12.2
f 12 16.2
Total 74 100.0

From the table , we see that % = (10/74)*100 , (12/74)*100 ................ etc

My question is , what modification to the syntax above is needed to get Table 2

I have a winding way of getting to Table 2 but wondering if it is possible to use CTABLES to achieve same results.

Table 2
Var3
Var1 Var2 # %
a m 10 23.8
f 12 37.5
b m 23 54.8
f 8 25.0
c m 9 21.4
f 12 37.5
Total m 42 56.8
f 32 43.2

For Table 2 , % m = (10/42)*100 , (23/42)*100 , (9/42)*100

and %f = (12/32)*100 -------- etc

Regards.
Edward

Edward Boadi

Re: CTABLES

Nana,
your syntax gave me % as listed in column X of the table below , here % of M & F sum to 100 in each group of Var1.
This is not what I want. I want the output shown in column Y .
Here % of M is count of M in each group of Var1 divided total count of M in the population.

Table 1
Var1 Var2 Var3 X (From Your Syntax) Y(Expected)
# % %
a m 10 =(10/22)*100=45 (10/42)*100=24
f 12 =(12/22)*100=55 (12/32)*100=38

b m 23 74 55
f 8 26 25

c m 9 43 21
f 12 57 38

Total m 42 57 57
f 32 43 43

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 12:14 PM
To: Edward Boadi
Subject: Re: CTABLES

Try this and adjust it if you need to.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR00003 VAR00001 VAR00002 DISPLAY=DEFAULT
/TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CATEGORIES VARIABLES=VAR00001 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR00002 ORDER=A KEY=VALUE EMPTY=EXCLUDE.

Edward Boadi <[hidden email]> wrote:

Will be grateful if anybody can help resolve this :

Table 1 below was produced using the following syntax :

* Custom Tables.
CTABLES
/VLABELS VARIABLES=Var1 Var2 Var3 DISPLAY=DEFAULT
/TABLE Var1 > Var2 [COUNT F40.0, LAYERPCT.COUNT PCT40.1] BY Var3 .

Table 1
Var1 Var2 Var3
# %
a m 10 13.5
f 12 16.2
b m 23 31.1
f 8 10.8
c m 9 12.2
f 12 16.2
Total 74 100.0

From the table , we see that % = (10/74)*100 , (12/74)*100 ................ etc

My question is , what modification to the syntax above is needed to get Table 2

I have a winding way of getting to Table 2 but wondering if it is possible to use CTABLES to achieve same results.

Table 2
Var3
Var1 Var2 # %
a m 10 23.8
f 12 37.5
b m 23 54.8
f 8 25.0
c m 9 21.4
f 12 37.5
Total m 42 56.8
f 32 43.2

For Table 2 , % m = (10/42)*100 , (23/42)*100 , (9/42)*100

and %f = (12/32)*100 -------- etc

Regards.
Edward

Nadine Nana
404 805 6209

_____

Want to be your own boss? Learn how on Yahoo! <http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index> Small Business.

Edward Boadi

Re: CTABLES

In reply to this post by Edward Boadi

I appreciate your effort is trying to help resolve the issue.
When you say "Change the statistics from column to rows" , ------ what statistics should be changed from column to row.
I guess you don't mean I should change :

TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
to
TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, ROWPCT.COUNT PCT40.1]

I gave prototype chart with the notion that it may help to amplify the issue under consideration.

You mentioned that I should adjust it -------what should I adjust ??????

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 3:39 PM
To: Edward Boadi
Subject: Re: CTABLES

Adjust it as I said. I do not need to know your data, I'm just showing you wher to look for the results.
Change the statistics from column to rows.
Thanks

Edward Boadi <[hidden email]> wrote:

Nana,
your syntax gave me % as listed in column X of the table below , here % of M & F sum to 100 in each group of Var1.
This is not what I want. I want the output shown in column Y .
Here % of M is count of M in each group of Var1 divided total count of M in the population.

Table 1
Var1 Var2 Var3 X (From Your Syntax) Y(Expected)
# % %
a m 10 =(10/22)*100=45 (10/42)*100=24
f 12 =(12/22)*100=55 (12/32)*100=38

b m 23 74 55
f 8 26 25

c m 9 43 21
f 12 57 38

Total m 42 57 57
f 32 43 43

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 12:14 PM
To: Edward Boadi
Subject: Re: CTABLES

Try this and adjust it if you need to.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR00003 VAR00001 VAR00002 DISPLAY=DEFAULT
/TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CATEGORIES VARIABLES=VAR00001 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR00002 ORDER=A KEY=VALUE EMPTY=EXCLUDE.

Edward Boadi wrote:

Will be grateful if anybody can help resolve this :

Table 1 below was produced using the following syntax :

* Custom Tables.
CTABLES
/VLABELS VARIABLES=Var1 Var2 Var3 DISPLAY=DEFAULT
/TABLE Var1 > Var2 [COUNT F40.0, LAYERPCT.COUNT PCT40.1] BY Var3 .

Table 1
Var1 Var2 Var3
# %
a m 10 13.5
f 12 16.2
b m 23 31.1
f 8 10.8
c m 9 12.2
f 12 16.2
Total 74 100.0

From the table , we see that % = (10/74)*100 , (12/74)*100 ................ etc

My question is , what modification to the syntax above is needed to get Table 2

I have a winding way of getting to Table 2 but wondering if it is possible to use CTABLES to achieve same results.

Table 2
Var3
Var1 Var2 # %
a m 10 23.8
f 12 37.5
b m 23 54.8
f 8 25.0
c m 9 21.4
f 12 37.5
Total m 42 56.8
f 32 43.2

For Table 2 , % m = (10/42)*100 , (23/42)*100 , (9/42)*100

and %f = (12/32)*100 -------- etc

Regards.
Edward

Nadine Nana
404 805 6209

_____

Want to be your own boss? Learn how on Yahoo! Small Business.

Nadine Nana
404 805 6209

_____

Do you Yahoo!?
Everyone is raving about the all-new <http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo.com/handraisers> Yahoo! Mail Beta.

Edward Boadi

Re: CTABLES

In reply to this post by Edward Boadi

Hi Nana ,
Your table is very close to what I want.
How do I display same information but with f/m in same column.
Thanks for your patience.

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Wednesday, June 21, 2006 8:18 AM
To: Edward Boadi
Subject: Re: CTABLES

Hi Ed,
This is the syntax

* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR1 VAR2 DISPLAY=DEFAULT
/TABLE VAR1 > VAR2 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CLABELS ROWLABELS=OPPOSITE
/CATEGORIES VARIABLES=VAR1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR2 ORDER=A KEY=VALUE EMPTY=EXCLUDE.
This is The table you can obtain from this syntax

f
m

Count
Column N %
Count
Column N %

VAR1
a
12
37.5%
10
23.8%

b
8
25.0%
23
54.8%

c
12
37.5%
9
21.4%

Total
32
100.0%
42
100.0%

I was thinking that it was what you was looking for. I'm sorry if it is not try someone else.
Nadine

Edward Boadi <[hidden email]> wrote:

I appreciate your effort is trying to help resolve the issue.
When you say "Change the statistics from column to rows" , ------ what statistics should be changed from column to row.
I guess you don't mean I should change :

TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
to
TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, ROWPCT.COUNT PCT40.1]

I gave prototype chart with the notion that it may help to amplify the issue under consideration.

You mentioned that I should adjust it -------what should I adjust ??????

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 3:39 PM
To: Edward Boadi
Subject: Re: CTABLES

Adjust it as I said. I do not need to know your data, I'm just showing you wher to look for the results.
Change the statistics from column to rows.
Thanks

Edward Boadi wrote:

Nana,
your syntax gave me % as listed in column X of the table below , here % of M & F sum to 100 in each group of Var1.
This is not what I want. I want the output shown in column Y .
Here % of M is count of M in each group of Var1 divided total count of M in the population.

Table 1
Var1 Var2 Var3 X (From Your Syntax) Y(Expected)
# % %
a m 10 =(10/22)*100=45 (10/42)*100=24
f 12 =(12/22)*100=55 (12/32)*100=38

b m 23 74 55
f 8 26 25

c m 9 43 21
f 12 57 38

Total m 42 57 57
f 32 43 43

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 12:14 PM
To: Edward Boadi
Subject: Re: CTABLES

Try this and adjust it if you need to.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR00003 VAR00001 VAR00002 DISPLAY=DEFAULT
/TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CATEGORIES VARIABLES=VAR00001 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR00002 ORDER=A KEY=VALUE EMPTY=EXCLUDE.

Edward Boadi wrote:

Will be grateful if anybody can help resolve this :

Table 1 below was produced using the following syntax :

* Custom Tables.
CTABLES
/VLABELS VARIABLES=Var1 Var2 Var3 DISPLAY=DEFAULT
/TABLE Var1 > Var2 [COUNT F40.0, LAYERPCT.COUNT PCT40.1] BY Var3 .

Table 1
Var1 Var2 Var3
# %
a m 10 13.5
f 12 16.2
b m 23 31.1
f 8 10.8
c m 9 12.2
f 12 16.2
Total 74 100.0

From the table , we see that % = (10/74)*100 , (12/74)*100 ................ etc

My question is , what modification to the syntax above is needed to get Table 2

I have a winding way of getting to Table 2 but wondering if it is possible to use CTABLES to achieve same results.

Table 2
Var3
Var1 Var2 # %
a m 10 23.8
f 12 37.5
b m 23 54.8
f 8 25.0
c m 9 21.4
f 12 37.5
Total m 42 56.8
f 32 43.2

For Table 2 , % m = (10/42)*100 , (23/42)*100 , (9/42)*100

and %f = (12/32)*100 -------- etc

Regards.
Edward

Nadine Nana
404 805 6209

_____

Want to be your own boss? Learn how on Yahoo! Small Business.

Nadine Nana
404 805 6209

_____

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.

Nadine Nana
404 805 6209

_____

Yahoo! Sports Fantasy Football '06 - Go with the leader. Start <http://us.rd.yahoo.com/evt=33539/*http://football.fantasysports.yahoo.com?ovchn=YAH&ovcpn=Integration&ovcrn=Mail+footer&ovrfd=YAH&ovtac=AD> your league today!

Nana Nadine

Re: CTABLES

Ed,
That is the best i can do right now. I'm not saying that what you are asking is not possible.
I have tried this syntax but it give me the statistics within each category. That is not what you are looking for.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR2 VAR1 DISPLAY=DEFAULT
/TABLE VAR1 BY VAR2 [COLPCT.COUNT PCT40.1]
/SLABELS VISIBLE=NO
/CLABELS COLLABELS=OPPOSITE
/CATEGORIES VARIABLES=VAR2 ORDER=A KEY=VALUE EMPTY=EXCLUDE
/CATEGORIES VARIABLES=VAR1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER.
I Hope someone else will help you having what you are looking for.
Nadine

Edward Boadi <[hidden email]> wrote:
Hi Nana ,
Your table is very close to what I want.
How do I display same information but with f/m in same column.
Thanks for your patience.

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Wednesday, June 21, 2006 8:18 AM
To: Edward Boadi
Subject: Re: CTABLES

Hi Ed,
This is the syntax

* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR1 VAR2 DISPLAY=DEFAULT
/TABLE VAR1 > VAR2 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CLABELS ROWLABELS=OPPOSITE
/CATEGORIES VARIABLES=VAR1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR2 ORDER=A KEY=VALUE EMPTY=EXCLUDE.
This is The table you can obtain from this syntax

f
m

Count
Column N %
Count
Column N %

VAR1
a
12
37.5%
10
23.8%

b
8
25.0%
23
54.8%

c
12
37.5%
9
21.4%

Total
32
100.0%
42
100.0%

I was thinking that it was what you was looking for. I'm sorry if it is not try someone else.
Nadine

Edward Boadi wrote:

I appreciate your effort is trying to help resolve the issue.
When you say "Change the statistics from column to rows" , ------ what statistics should be changed from column to row.
I guess you don't mean I should change :

TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
to
TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, ROWPCT.COUNT PCT40.1]

I gave prototype chart with the notion that it may help to amplify the issue under consideration.

You mentioned that I should adjust it -------what should I adjust ??????

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 3:39 PM
To: Edward Boadi
Subject: Re: CTABLES

Adjust it as I said. I do not need to know your data, I'm just showing you wher to look for the results.
Change the statistics from column to rows.
Thanks

Edward Boadi wrote:

Nana,
your syntax gave me % as listed in column X of the table below , here % of M & F sum to 100 in each group of Var1.
This is not what I want. I want the output shown in column Y .
Here % of M is count of M in each group of Var1 divided total count of M in the population.

Table 1
Var1 Var2 Var3 X (From Your Syntax) Y(Expected)
# % %
a m 10 =(10/22)*100=45 (10/42)*100=24
f 12 =(12/22)*100=55 (12/32)*100=38

b m 23 74 55
f 8 26 25

c m 9 43 21
f 12 57 38

Total m 42 57 57
f 32 43 43

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 12:14 PM
To: Edward Boadi
Subject: Re: CTABLES

Try this and adjust it if you need to.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR00003 VAR00001 VAR00002 DISPLAY=DEFAULT
/TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CATEGORIES VARIABLES=VAR00001 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR00002 ORDER=A KEY=VALUE EMPTY=EXCLUDE.

Edward Boadi wrote:

Will be grateful if anybody can help resolve this :

Table 1 below was produced using the following syntax :

* Custom Tables.
CTABLES
/VLABELS VARIABLES=Var1 Var2 Var3 DISPLAY=DEFAULT
/TABLE Var1 > Var2 [COUNT F40.0, LAYERPCT.COUNT PCT40.1] BY Var3 .

Table 1
Var1 Var2 Var3
# %
a m 10 13.5
f 12 16.2
b m 23 31.1
f 8 10.8
c m 9 12.2
f 12 16.2
Total 74 100.0

From the table , we see that % = (10/74)*100 , (12/74)*100 ................ etc

My question is , what modification to the syntax above is needed to get Table 2

I have a winding way of getting to Table 2 but wondering if it is possible to use CTABLES to achieve same results.

Table 2
Var3
Var1 Var2 # %
a m 10 23.8
f 12 37.5
b m 23 54.8
f 8 25.0
c m 9 21.4
f 12 37.5
Total m 42 56.8
f 32 43.2

For Table 2 , % m = (10/42)*100 , (23/42)*100 , (9/42)*100

and %f = (12/32)*100 -------- etc

Regards.
Edward

Nadine Nana
404 805 6209

_____

Want to be your own boss? Learn how on Yahoo! Small Business.

Nadine Nana
404 805 6209

_____

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.

Nadine Nana
404 805 6209

_____

Yahoo! Sports Fantasy Football '06 - Go with the leader. Start your league today!

Nadine Nana
404 805 6209

---------------------------------
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.

Edward Boadi

Re: CTABLES

In reply to this post by Edward Boadi

Hi List Members,
I will appreciate if somebody could help resolve this issue on "CTABLES".

Thanks for your efforts Nana .

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Thursday, June 22, 2006 8:52 AM
To: Edward Boadi
Cc: [hidden email]
Subject: Re: CTABLES

Ed,
That is the best i can do right now. I'm not saying that what you are asking is not possible.
I have tried this syntax but it give me the statistics within each category. That is not what you are looking for.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR2 VAR1 DISPLAY=DEFAULT
/TABLE VAR1 BY VAR2 [COLPCT.COUNT PCT40.1]
/SLABELS VISIBLE=NO
/CLABELS COLLABELS=OPPOSITE
/CATEGORIES VARIABLES=VAR2 ORDER=A KEY=VALUE EMPTY=EXCLUDE
/CATEGORIES VARIABLES=VAR1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER.
I Hope someone else will help you having what you are looking for.
Nadine

Edward Boadi <[hidden email]> wrote:

Hi Nana ,
Your table is very close to what I want.
How do I display same information but with f/m in same column.
Thanks for your patience.

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Wednesday, June 21, 2006 8:18 AM
To: Edward Boadi
Subject: Re: CTABLES

Hi Ed,
This is the syntax

* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR1 VAR2 DISPLAY=DEFAULT
/TABLE VAR1 > VAR2 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CLABELS ROWLABELS=OPPOSITE
/CATEGORIES VARIABLES=VAR1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR2 ORDER=A KEY=VALUE EMPTY=EXCLUDE.
This is The table you can obtain from this syntax

f
m

Count
Column N %
Count
Column N %

VAR1
a
12
37.5%
10
23.8%

b
8
25.0%
23
54.8%

c
12
37.5%
9
21.4%

Total
32
100.0%
42
100.0%

I was thinking that it was what you was looking for. I'm sorry if it is not try someone else.
Nadine

Edward Boadi wrote:

I appreciate your effort is trying to help resolve the issue.
When you say "Change the statistics from column to rows" , ------ what statistics should be changed from column to row.
I guess you don't mean I should change :

TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
to
TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, ROWPCT.COUNT PCT40.1]

I gave prototype chart with the notion that it may help to amplify the issue under consideration.

You mentioned that I should adjust it -------what should I adjust ??????

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 3:39 PM
To: Edward Boadi
Subject: Re: CTABLES

Adjust it as I said. I do not need to know your data, I'm just showing you wher to look for the results.
Change the statistics from column to rows.
Thanks

Edward Boadi wrote:

Nana,
your syntax gave me % as listed in column X of the table below , here % of M & F sum to 100 in each group of Var1.
This is not what I want. I want the output shown in column Y .
Here % of M is count of M in each group of Var1 divided total count of M in the population.

Table 1
Var1 Var2 Var3 X (From Your Syntax) Y(Expected)
# % %
a m 10 =(10/22)*100=45 (10/42)*100=24
f 12 =(12/22)*100=55 (12/32)*100=38

b m 23 74 55
f 8 26 25

c m 9 43 21
f 12 57 38

Total m 42 57 57
f 32 43 43

Thanks

-----Original Message-----
From: Nana Nadine [mailto:[hidden email]]
Sent: Tuesday, June 20, 2006 12:14 PM
To: Edward Boadi
Subject: Re: CTABLES

Try this and adjust it if you need to.
* Custom Tables.
CTABLES
/VLABELS VARIABLES=VAR00003 VAR00001 VAR00002 DISPLAY=DEFAULT
/TABLE VAR00001 > VAR00002 BY VAR00003 [COUNT F40.0, COLPCT.COUNT PCT40.1]
/CATEGORIES VARIABLES=VAR00001 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES POSITION=AFTER
/CATEGORIES VARIABLES=VAR00002 ORDER=A KEY=VALUE EMPTY=EXCLUDE.

Edward Boadi wrote:

Will be grateful if anybody can help resolve this :

Table 1 below was produced using the following syntax :

* Custom Tables.
CTABLES
/VLABELS VARIABLES=Var1 Var2 Var3 DISPLAY=DEFAULT
/TABLE Var1 > Var2 [COUNT F40.0, LAYERPCT.COUNT PCT40.1] BY Var3 .

Table 1
Var1 Var2 Var3
# %
a m 10 13.5
f 12 16.2
b m 23 31.1
f 8 10.8
c m 9 12.2
f 12 16.2
Total 74 100.0

From the table , we see that % = (10/74)*100 , (12/74)*100 ................ etc

My question is , what modification to the syntax above is needed to get Table 2

I have a winding way of getting to Table 2 but wondering if it is possible to use CTABLES to achieve same results.

Table 2
Var3
Var1 Var2 # %
a m 10 23.8
f 12 37.5
b m 23 54.8
f 8 25.0
c m 9 21.4
f 12 37.5
Total m 42 56.8
f 32 43.2

For Table 2 , % m = (10/42)*100 , (23/42)*100 , (9/42)*100

and %f = (12/32)*100 -------- etc

Regards.
Edward

Nadine Nana
404 805 6209

_____

Want to be your own boss? Learn how on Yahoo! Small Business.

Nadine Nana
404 805 6209

_____

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.

Nadine Nana
404 805 6209

_____

Yahoo! Sports Fantasy Football '06 - Go with the leader. Start your league today!

Nadine Nana
404 805 6209

_____

Do you Yahoo!?
Everyone is raving about the all-new <http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo.com/handraisers> Yahoo! Mail Beta.