CTABLES

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

CTABLES

Edward Boadi
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: CTABLES

Edward Boadi
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: CTABLES

Edward Boadi
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: CTABLES

Edward Boadi
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!
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: CTABLES

Nana Nadine
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: CTABLES

Edward Boadi
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.
Loading...