Jon,
To automate this, use syntax. I see a couple options... one is to rename
your variables as they are slurped in from your SQL database using GET DATA.
I perform a similar task for an MS Access database... you can generate SQL
strings using the GUI, then paste them into a syntax job.
GET DATA/TYPE=ODBC/CONNECT=
"DSN=MS Access Database;DBQ=C:\saf\Master_DB.mdb;DriverId=25;"
"FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"
/SQL="SELECT `OldDistrict` AS `NewDistrict` FROM
`C:\saf\Master_DB`.`SalesData`".
Another would be MATCH FILES, in which old and new names are put into a
lookup table, that table is then matched to the SQL dataset using old names,
then old names are deleted and new names retained.
Regards,
Bob Walker
Surveys & Forecasts, LLC
www.safllc.com
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of Jon
Erik Ween
Sent: Wednesday, September 23, 2009 8:02 PM
To:
[hidden email]
Subject: SPSS factor label look up tables
Hi
New to the list! Thanks for any help!
I have datasets that frequently update (from MySQL). Every time I import a
fresh update, I have to re-
code all my factor labels. Does anyone know if SPSS can read these from a
look-up table? I've also
seen people delete and re-paste data to existing structures, but when you
have >5000 records, that
gets a bit tedious.
Any other suggestions would be appreciated.
Thanks
Jon
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
