Date: Mon, 4 Oct 2010 07:43:26 -0700
Reply-To: "Pirritano, Matthew" <MPirritano@ochca.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Pirritano, Matthew" <MPirritano@ochca.com>
Subject: Re: incomplete merge
In-Reply-To: A<4CA86C7B.6070208@DrKendall.org>
Content-Type: multipart/alternative;
For the sake of completeness I have to claim temporary insanity. What I
was trying to do was ill founded. What I was trying to do is impossible
in spss. I suddenly saw the light Sunday night as I sat reading. Let me
explain.
The full file looks like this:
Id Gender
1 M
2 M
3 M
4 F
5 F
6 F
The male file contains data for males on var1 thru var4.
And the female file contains data for females on var1 thru var4.
So what I was trying to do was bring in the data for males for var1 1
thru var4, and then bring in the data for females for var1 thru var4.
But of course after the variables were brought in for males the same
variables with the same names could not be brought in for females! Of
course I could have renamed the female variables and then transferred
the data to be in the same columns as the male data. But I didn't
realize what I was doing.
Thanks for the help over weekend. I apologize for my obtuseness.
Thanks
Matt
Matthew Pirritano, Ph.D.
Research Analyst IV
Medical Services Initiative (MSI)
Orange County Health Care Agency
(714) 568-5648
________________________________
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Art Kendall
Sent: Sunday, October 03, 2010 4:44 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: incomplete merge
Just curious.
How does survey monkey format the data it provides? Are there options
that would make it unnecessary to go through EXCEL? csv, fixed columns,
tab separated, pipe separated, etc.?
Art Kendall
Social Research Consultants
On 10/3/2010 1:05 AM, Matthew Pirritano wrote:
Exact same thing happens regardless if I use TABLE or FILE in my
matching syntax.
There is only one line per participant so FILE should work.
dataset activate full_file.
sort cases by id.
dataset activate male.
sort cases by id.
dataset activate female.
sort cases by id.
DATASET ACTIVATE full_file.
MATCH FILES /FILE=*
/FILE='male'
/BY ID.
EXECUTE.
DATASET ACTIVATE full_file.
MATCH FILES /FILE=*
/FILE='female'
/BY ID.
EXECUTE.
Matthew Pirritano, Ph.D.
Email: matthewpirritano@sbcglobal.net
________________________________
From: David Marso <david.marso@GMAIL.COM> <mailto:david.marso@GMAIL.COM>
To: SPSSX-L@LISTSERV.UGA.EDU; subscribe spssx-l Matthew Pirritano
<matthewpirritano@SBCGLOBAL.NET> <mailto:matthewpirritano@SBCGLOBAL.NET>
Cc: David Marso <david.marso@GMAIL.COM> <mailto:david.marso@GMAIL.COM>
Sent: Sat, October 2, 2010 10:02:19 PM
Subject: Re: incomplete merge
Hey Matt,
Please post your SPSS code.
Difficult to do ESP on this one.
Respects, David
On Sat, 2 Oct 2010 17:25:32 -0700, Matthew Pirritano
<matthewpirritano@sbcglobal.net> wrote:
>All,
>
>I am having a most vexing problem.
>
>I have done many merges in my day. But for some reason this one is not
working.
>
>I have three files. A male file, a female file, and a full file that
the male
>and female files are being added to.
>
>I've placed the id field from each file that I am matching on next to
each
other
>in excel and lo and behold they all match up. But when I run a match I
wind up
>with 145 missing fields. The fields are 10 character string fields. I
do
matches
>like this on ssn in my sleep. What in the world could be going on here.
>
>
>Since the full file has both male and female data I'm doing a table
look up
with
>the male or female file as the table. I actually don't think this
should
matter,
>since the full file should match up with only one line each from the
male and
>female file. I've tried it without the table lookup and get the same
results.
>
>I've also tried to trim each field, thinking there might be some
blanks. That
>didn't help.
>
>
>Please someone help me see what I'm missing.
>
>Thanks
>Matt
>
> Matthew Pirritano, Ph.D.
>Email: matthewpirritano@sbcglobal.net
>
===================== 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 SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command INFO
REFCARD
[text/html]
