Sort cases by CaseDataSetID InvestigationId PerpetratorId ClientID StateName. Who are the Perpetrators(how is client perp related)\Working folder". The following is a more efficient version of your code, with the needed correction: cd "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. It seems you just need to switch what you used for file and for table. Who are the Perpetrators(how is client perp related)\Working folder\RelationshipFinal2017.sav". Save OUTFILE="C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. InvestigationId PerpetratorID ClientID StateName. Who are the Perpetrators(how is client perp related)\Working folder\RelationshipFinal.sav" /by CaseDataSetID 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\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". Save outfile= "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. 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". Who are the Perpetrators(how is client perp related)\Working folder\RelationshipFinal.sav". Save outfile="C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. Sort cases by CaseDataSetID(a) InvestigationId(a) PerpetratorId(a) ClientID(a) StateName (a). Who are the Perpetrators(how is client perp related)\Working folder\Relationship.sav". I tried doing a match files by key variables it didn't work Get file= "C:\Users\gaurelien\WRMA\APS-TARC - Documents\NAMRS DATA Reports\Report Redesign\2018 Structure\Archive\5. THe number of records should be the same as the RelationshipFinal.
Merge datasets in spss code code#
I tried to code it in spss but after the merge I am getting a different number of records. So basically I want to retain all records from Relationship Final and whichever records in Relationship final that are found in MaltPerpFinal20017 I want to merge them as well. I need to merge these two tables using a left join. One is called RelationshipFinal and the other MaltPerpFinal2017.