Date: Mon, 12 Dec 2005 10:37:50 -0500
Reply-To: Bob Walker <rwwalker-xl@spamarrest.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Bob Walker <rwwalker-xl@spamarrest.com>
Subject: Re: SPSS & EXCEL
In-Reply-To: <2E0C5581E6789542868090EAF994240D7B43DF@EBR02.EBRINC.LOCAL>
Content-type: text/plain; charset=US-ASCII
Angela,
UPDATE seems like it would be appropriate, since you are neither changing
variables nor cases, but are simply refreshing values in a master file.
UPDATE replaces values in a master file with updated values from transaction
files (in your case, the transaction files are Excel files, and they would
have to be read back in as SPSS files). The format is the same as MATCH
FILES...
UPDATE FILE="C:\MASTER.SAV" / FILE="C:\NEWDATA1.SAV" / BY ID.
SAVE OUTFILE="C:\MASTER2.SAV".
You can have multiple transaction files, but the last file takes precedence
should it contain data for variables updated in an earlier file.
Regards,
Bob Walker
Surveys & Forecasts, LLC
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Angela J. D'haene (AJD)
Sent: Monday, December 12, 2005 10:04 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: SPSS & EXCEL
Dear List,
I'm sure this may have been asked before, but this might have a
different twist. I have an SPSS database that I have transferred to
Excel using the "Send to Excel" command. Other people on my team who do
not have SPSS have then used the Excel format to input data & have sent
back to me to incorporate into the master SPSS file. Is there a way to
do this? I've looked at the help page about renaming variables & merging
files, but it doesn't seem to be working so I'm sure I'm doing something
wrong. What I've done so far is just opened data from Excel using the
first row of data as my variable so that the variable names are
identical. Thus, now I have two spss files w/ identical variable names &
I just want to put the smaller file into the master file. There are no
duplicates to worry about. Does anyone know how to do this?
Thanks!!
Angela D'Haene
Evidence Based Research, Inc.
1595 Spring Hill Road, Suite 250
Vienna, Virginia 22182-2216
(703) 287-0388 ~ Phone
(703) 821-7742 ~ Fax
dhaene@ebrinc.com
| 
