Date: Wed, 20 Jun 2007 10:50:43 -0400
Reply-To: chiu2 <chiu2@YAHOO.COM>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: chiu2 <chiu2@YAHOO.COM>
Subject: Re: Using INPUT PROGRAM to create a subset of datafile
Thanks a lot, Richard.
Unfortunately the version of SPSS-X in mainframe (release 4.1) is pretty old
which does not have the new DATASET features.
I got a SPSS 14 Syntax reference and read an example in the REREAD section
(p1532). That example merged 2 text files together using INPUT PROGRAM. I
tried to modify such that it fits my needs but was failed due to the fact
that my transaction file usually has multiple rows for the same ID. Once an
END CASE is issued, both the ID_list.txt and Transaction.txt roll to the
next row, hence all rows after the first ID are skipped (as ID from the
ID_list.txt is not retained).
There is a LEAVE command which could be useful, because it could help to
retain the ID from ID_list.txt. But I am not good enough to put all these
together to make it work. Any help is appreciated. Thanks in advance.