Date:         Sun, 5 Dec 2004 16:40:10 -0500
Reply-To:     Raynald Levesque <rlevesque@videotron.ca>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Raynald Levesque <rlevesque@videotron.ca>
Subject:      Re: Looping query.
In-Reply-To:  <001901c4d85c$393f7f30$bc02a8c0@spss.com.sg>
Content-type: text/plain; charset=iso-8859-1

Hi

I am not sure I understand the question.

Does the following example meet your requirements?

GET FILE='c:\program files\spss\employee data.sav'.

COMPUTE filter1=(bdate < DATE.DMY(1,1,1963)).

FILTER BY filter1.
* Custom Tables.
CTABLES
  /VLABELS VARIABLES=gender jobcat DISPLAY=DEFAULT
  /TABLE jobcat [COUNT F40.0] BY gender
  /CATEGORIES VARIABLES=gender jobcat ORDER=A KEY=VALUE EMPTY=INCLUDE
  /TITLES TITLE="Table for those born before 1/1/1963".

FILTER OFF.
COMPUTE filter2=1 - filter1.
FILTER BY filter2.
* Custom Tables.
CTABLES
  /VLABELS VARIABLES=minority jobcat DISPLAY=DEFAULT
  /TABLE jobcat [COUNT F40.0] BY minority
  /CATEGORIES VARIABLES=minority jobcat ORDER=A KEY=VALUE EMPTY=INCLUDE
  /TITLES TITLE="Table for those born on or after 1/1/1963".

FILTER OFF.

Regards

Raynald Levesque Raynald@spsstools.net
Visit my SPSS site: http://www.spsstools.net


-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Tans Family
Sent: December 2, 2004 5:47 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Looping query.


MessageHi List,
Was wondering if anyone could help me with looping. Appreciate any help

Query1:
I would like to run my reports (i.e. Custom Tables) by checking on
candidates who have taken a test before a date (i.e. 010804), then report A
should be generated

And if candidate take the test after a date (i.e.010804), report B should be
generated instead.

Is it possible to write a IF command to generate the report according by
checking on the "date" field, filter according and tabulating the right
report?

Query2:
Lastly, is there a syntax command to change the font and size before the
report is generated out?


Thank you very very much.

Regards
S

p/s: As I am not able to attached any files, hence can't provide any data
example. Sorry.