Date: Fri, 2 Dec 2011 12:32:59 -0800
Reply-To: David Marso <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: David Marso <firstname.lastname@example.org>
Subject: Re: Advice for Simplifying Two-line Syntax?
Content-Type: text/plain; charset=us-ascii
Build 2 additional files A.sav, B.sav
A.sav: sorted by KEY VARIABLES [location and OldProductTitle: with data
B.sav: sorted by KEY VARIABLES [location and NewProductTitle: with data
GET FILE "your master file.sav".
SORT CASES BY location OldProductTitle.
MATCH FILES / FILE * /TABLE "A.sav" / BY location OldProductTitle.
SORT CASES BY location NewProductTitle.
MATCH FILES / FILE * /TABLE "B.sav" / BY location NewProductTitle.
*MUCH EASIER than maintaining a 800 line syntax file!!!*
FWIW: You *CAN NOT* condense your 2 liner into a one liner as it presumes
computing 2 new variables.
OTOH: Using the 2 tables will result in a low overhead aside from keeping
your tables up to date.
These would best be stored in some sort of central data base!
elle lists wrote
> I'm correcting product names and plugging-in product numbers in a data set
> by using the IF statement and two conditions based on "Location" and
> "OldProductTitle". (Location is used to verify the product title as
> variations occur throughout the data set because the info has been entered
> inconsistently.) The two-line syntax works (shown below) but is there a
> to condense the two or achieve the same effect in more efficient manner as
> the corrections number over 400 (which means 800 syntax lines)? I'd also
> like to maintain working with strings as this situation is likely to
> reoccur. Many thanks for your advice. ~elle
> SYNTAX EXAMPLE
> IF Location='Riverside' AND OldProductTitle='McAfee 2012'
> NewProductTitle='McAfee Total Protection 2012-3 Users'.
> IF Location='Riverside' AND NewProductTitle='McAfee Total Protection
> Users' ProductNo='B005AAWYR2'.
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Advice-for-Simplifying-Two-line-Syntax-tp5043095p5043158.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
For a list of commands to manage subscriptions, send the command