Date:         Mon, 17 Sep 2001 06:35:10 +0800
Reply-To:     paul yeo <paulyeo11@YAHOO.COM.SG>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         paul yeo <paulyeo11@YAHOO.COM.SG>
Subject:      Re: How to using Text , Summarize and Table to display same data ?
Comments: To: Raynald Levesque <rlevesque@VIDEOTRON.CA>
In-Reply-To:  <LDEEKLGKNMECOPKLIGJNOELJCEAA.rlevesque@videotron.ca>
Content-Type: text/plain; charset=iso-8859-1

Thank you it work well , i have 3 question :-

The reasons i unable to use the summarise table , is
table report is support by many script , as i need to
run the wrap row to one line.

1) why you only put   /STATISTICS
 mean( ). and with out following :-
                mean(cur1 (dollar10)' ')
                mean(cur2 (dollar10)' ')
                mean(pc (PCT2.0)' ')
yet you can display all data ?

2) my second error , i am not able to correct , as
it's much complicated , can you pls email me the
complete modify syntax.

Tks

Paul Yeo


 --- Raynald Levesque <rlevesque@VIDEOTRON.CA> wrote:
> Hi
>
> Replacing the current TABLE by
>
> TABLES
>  /FORMAT BLANK MISSING('.')
>  /OBSERVATION profit sls_amt pm sls_pct cum_sls
> pro_pct cum_pft
>  /TABLES rank > (dep_key)
>  BY (profit + sls_amt + pm + sls_pct + cum_sls +
> pro_pct +   cum_pft)
>  /STATISTICS
>  mean( ).
>
> does print the table in the corerct order.
>
> The SUMMARIZE command is better suited to fit your
> requirement than the
> REPORT command.
>
> You have 2 errors in the current syntax (always
> check your log file to
> ensure that there are no errors):
>
> First error:
> LABELS SLS_PCT 'Sales %' etc
> needs to be corrected to
> VALUE LABELS SLS_PCT 'Sales %' etc
>
> Second error:
> The variable dep_key is numeric but you try to
> assign the string "Ot" to it.
> You should assign a number such as 99 and define a
> value label of "Ot" for
> 99.
>
> Regards
>
> Raynald Levesque rlevesque@videotron.ca
> Visit My SPSS Pages:
> http://pages.infinit.net/rlevesqu/index.htm
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion
> [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of Paul
> Yeo
> Sent: Sunday, September 16, 2001 10:34 AM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: How to using Text , Summarize and Table to
> display same data ?
>
>
> hi raynald and all spss list member , i have try to
> make use of three
> different report format to display same data set. my
> problem is when i using
> Table report format , it automatic sort the dep_key
> variable , which make
> the report not correct , Hope that you can help to
> modify the syntax , so
> that it will make all 3 different report display the
> sames result.
>
> Tks
>
> Paul Yeo
>
> Following are the syntax :-
>
> <snip>

__________________________________________________
Do You Yahoo!?
Yahoo! Y! Pages - Search or browse for business listings.
http://yp.yahoo.com.sg/