Date:         Sat, 29 Mar 2003 22:13:11 -0500
Reply-To:     Art@DrKendall.org
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Arthur J. Kendall" <Art@DrKendall.org>
Organization: Social Research Consultants
Subject:      Re: Merging Files
Comments: To: jeff_hayes@stratalys.com
Content-Type: text/plain; charset=us-ascii; format=flowed

If the following does not address your problem, please post the syntax
and a small amount of data demonstrating the problem.

new file.
data list fixed /TYPE  1-9 (a)   ASSETS 10-12.
begin data
Ibm      150
Sun      200
end data.
save outfile = 'c:\temp\orgs.sav'.

new file.
data list fixed /NAME (a8)   ADDRESS(a11)    TYPE(a9).
begin data
John    Chicago    Ibm
Steve   NYC        Ibm
Ann     NYC        Ibm
Jack    Austin     Sun
Paul    NYC        Sun
Tim     Chicago    Xerox
end data.
list.
match file file=* /table= 'c:\temp\orgs.sav' by type.
list.

Hope this helps.

Art
Art@DrKendall.org
Social Research Consultants
University Park, MD USA
(301) 864-5570



Jeff Hayes, Ph.D. wrote:
> I have two files - organizations (ORGS) and individuals (INDS).  The files
> share one variable - TYPE.  I would like to merge the two files so as to add
> variables from ORGS to INDS, matching on TYPE.  So, for instance ...
>
> ORGS has ...
>
> TYPE     ASSETS
> Ibm      150
> Sun      200
>
> INDS has ...
>
> NAME    ADDRESS    TYPE
> John    Chicago    Ibm
> Steve   NYC        Ibm
> Ann     NYC        Ibm
> Jack    Austin     Sun
> Paul    NYC        Sun
> Tim     Chicago    Xerox
>
> The problem arises when I Merge -> Add Variables -> Match on TYPE with Both
> Files Provide Cases.  SPSS will create ASSETS in the INDS file, but only
> populate the first TYPE record with the proper value.  So, John has ASSETS of
> 150, but Steve and Ann show no data.  Matching on External File (ORGS) deletes
> all INDS records with no TYPE value in ORGS (i.e., Tim).  Is there a workaround
> for this?
>
> Thanks!
>
> Cheers,
> Jeff
>
> =====
> =======================================
> Jeff Hayes, Ph.D.
> Stratalys Research
> Washington, DC
> jeff_hayes@stratalys.com
> (tel1)202.234.7219  (tel2)202.468.7219
> (fax)202.234.7852
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> http://platinum.yahoo.com
>