Date:         Thu, 29 Sep 2011 12:57:35 -0400
Reply-To:     Statmanz <statmanz@earthlink.net>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Statmanz <statmanz@earthlink.net>
Subject:      Re: CTABLES request for assistance
Comments: To: Charley Trimble <charleytrimble@SBCGLOBAL.NET>
In-Reply-To:  <201109291518.p8TAl7WD019501@willow.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Can be done a couple of ways, perhaps more, with one being the creation of a
new variable but depending on SPSS version, it can happen right in CTables

W

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Charley Trimble
Sent: Thursday, September 29, 2011 11:18 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: CTABLES request for assistance

Your assistance will be greatly appreciated.

In the CTABLES below, how do I create adjoining columns corresponding to
each Fiscal Year (ordinal variable), where Revenues are set at 100% for each
fiscal year and the remaining variables are computed as a % of Revenues
underneath that respective column?  Is it even possible to do what I'm
wanting to achieve?

                                Fiscal Year
             2007     2008           2009            2010

Revenues 300,364,032 323,115,027 347,543,493 392,869,040 Total ops expns
297,380,465 320,471,263 352,999,124 377,575,764 Ops income 2,983,567
2,643,764 -5,455,631 15,293,276 Tot oth inc 29,666,852 32,131,839 22,346,896
33,201,754 Tot oth expns 6,557,787 5,662,330 9,310,657 1,399,420 Net in
(loss) 26,092,632 29,113,273 7,580,608 47,095,610

i.e.
Revenues        # (above) 100.0%     #  100.0%        #    %     #     100%
Total ops expns     "      99.0%     "   99.1%        "   1.02%  "    96.1%
etc.
etc.
etc.

(The size of this box limits my explanations..but I hope you understand my
goal).  Thanks.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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
LISTSERV@LISTSERV.UGA.EDU (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