Date:         Tue, 12 Apr 2005 11:07:52 -0500
Reply-To:     John Norton <jnorton@lumc.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         John Norton <jnorton@lumc.edu>
Subject:      Re: Stuck with the use of ANY
Comments: To: ssc1@westchestergov.com
Content-Type: text/plain; charset=US-ASCII

Hi List,

I've not been able to replicate the issue with the ANY() function,
namely that it didn't work. It worked just fine for me using the
following code:

DATA LIST FREE / x1 to x5.
BEGIN DATA.
0 0 0 0 0
0 0 0 1 0
0 0 0 0 0
1 0 0 0 0
0 1 0 0 0
END DATA.
EXE.

SELECT IF ANY(1,x1 TO x5).
LIST.

x1 x2 x3 x4 x5

.00 .00 .00 1.00 .00
1.00 .00 .00 .00 .00
.00 1.00 .00 .00 .00


Number of cases read: 3 Number of cases listed: 3


JN



>>> "Cho, Stanley" < ssc1@westchestergov.com > 4/12/2005 11:01 AM >>>

I hope they haven't de-activated the use of the ANY function in the
latest
versions of SPSS!!!

But this code has worked for quite a while for me:

IF (ANY(pfi2,1473,1737,1738,1740,1741,2968,3013,6251)=1) WCNYC=6.

Hope this helps
--Stan