Date: Sun, 5 Dec 2004 16:40:10 -0500
Reply-To: Raynald Levesque <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Raynald Levesque <firstname.lastname@example.org>
Subject: Re: Looping query.
Content-type: text/plain; charset=iso-8859-1
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.
/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".
COMPUTE filter2=1 - filter1.
FILTER BY filter2.
* Custom Tables.
/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".
Raynald Levesque Raynald@spsstools.net
Visit my SPSS site: http://www.spsstools.net
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Sent: December 2, 2004 5:47 AM
Subject: Looping query.
Was wondering if anyone could help me with looping. Appreciate any help
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
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
Lastly, is there a syntax command to change the font and size before the
report is generated out?
Thank you very very much.
p/s: As I am not able to attached any files, hence can't provide any data