在SPSS中使用left join合并两个数据集

Question

我有两张桌子。一个叫做RelationshipFinal，另一个叫做MaltPerpFinal2017。我需要使用left join合并这两个表。所以基本上我想保留Relationship Final中的所有记录，以及在MaltPerpFinal20017中找到的Relationship final中的任何记录，我也想合并它们。我试着用spss编写代码，但在合并之后，我得到了不同数量的记录。THe记录数应与RelationshipFinal相同。任何帮助都是非常感谢的。谢谢

我试着通过关键变量匹配文件，但不起作用

Get file= "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Who are the Perpetrators(how is client perp related)\Working folder\Relationship.sav".

sort cases by CaseDataSetID(a) InvestigationId(a) PerpetratorId(a) ClientID(a) StateName (a).
ALTER TYPE StateName(a28).
Save outfile="C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Who are the Perpetrators(how is client perp related)\Working folder\RelationshipFinal.sav".

Get file= "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\NAMRS Report Redesign\Exhibits Missing\Working Folder\MaltPerpFinal2017.sav".
sort cases by CaseDataSetID(a) InvestigationId(a)  PerpetratorId(a) ClientID(a) StateName (a).
ALTER TYPE StateName(a28).
save outfile= "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Who are the Perpetrators(how is client perp related)\Working folder\MaltPerpFinal2017.sav".

MATCH FILES file="C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Who are the Perpetrators(how is client perp related)\Working folder\MaltPerpFinal2017.sav" 
      /Table="C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Who are the Perpetrators(how is client perp related)\Working folder\RelationshipFinal.sav" /by CaseDataSetID
      InvestigationId PerpetratorID ClientID StateName.
Execute.

Save OUTFILE="C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Who are the Perpetrators(how is client perp related)\Working folder\RelationshipFinal2017.sav".

Answer 1

看起来你只需要切换一下你在file和table中使用的东西。以下是您的代码的一个更有效的版本，并进行了必要的更正：

cd "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Who are the Perpetrators(how is client perp related)\Working folder".

Get file= "Relationship.sav".
sort cases by CaseDataSetID InvestigationId PerpetratorId ClientID StateName .
ALTER TYPE StateName(a28).
Save outfile="RelationshipFinal.sav".

Get file= "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\NAMRS Report Redesign\Exhibits Missing\Working Folder\MaltPerpFinal2017.sav".
sort cases by CaseDataSetID InvestigationId  PerpetratorId ClientID StateName .
ALTER TYPE StateName(a28).
save outfile= "MaltPerpFinal2017.sav".

MATCH FILES file="RelationshipFinal.sav"
    /Table="MaltPerpFinal2017.sav"/by CaseDataSetID
    InvestigationId PerpetratorID ClientID StateName.
Execute.

Save OUTFILE="RelationshipFinal2017.sav".

还要注意，您不需要为了匹配文件而保存它们-您可以为打开的每个文件使用dataset name Some_name，然后在match命令中使用数据集名称，而不是文件名。