Hi Ricardo,
this example shows that "FILE /FILE" matches include all cases from
both files even when the BY variable does not match..
DATASET DECLARE left.
DATASET ACTIVATE left.
DATA LIST LIST /voterID var1 var2.
BEGIN DATA
55 1 2
66 3 4
END DATA.
DATASET DECLARE right.
DATASET ACTIVATE right.
DATA LIST LIST /voterID var1 var3.
BEGIN DATA
55 5 6
77 3 4
END DATA.
DATASET ACTIVATE left.
MATCH FILES FILE = * /FILE = right /BY voterID.
LIST.
Data List
╭───────┬────┬────┬────╮
│voterID│var1│var2│var3│
├───────┼────┼────┼────┤
│ 55.00│1.00│2.00│6.00│
│ 66.00│3.00│4.00│ .│
│ 77.00│3.00│ .│4.00│
╰───────┴────┴────┴────╯
If with FULL OUTER JOIN you mean "include all cases even if the BY
variable is missing" (strange scenario), then to achieve this I suggest
you assign some unique value to each missing case (for example: IF
(MISSING(voterID)) voterID = -$CASENUM.), then use ADD FILES to amass
all cases, then use AGGREGATE on the BY variable to eliminate duplicates.
On 1/5/25 18:58, Ricardo Mejias wrote:
------------------------------------------------------------------------
*From:* Ricardo Mejias <ricardomej...@hotmail.com>
*Sent:* Sunday, January 5, 2025 12:50 PM
*To:* pspp-users@gnu.org <pspp-users@gnu.org>
*Subject:* Re: Pspp-users Digest, Vol 221, Issue 2
This is my code, and it works fine for matching the left file to the
right, but only for VoterIDs that are in both files.
MATCH FILES
/FILE = "F:\External Drive for PSPP
Data\FloridaTotalsFiles\SelectedFields_20241112.sav"/File =
"F:\External Drive for PSPP
Data\FloridaTotalsFiles\VoterIDParty_20241022.sav"
/BY VoterID.
SAVE
/OUTFILE =
"F:\External Drive for PSPP
Data\FloridaTotalsFiles\SelectedFieldsWithLastMonParty_20241112.sav".
What is the syntax to make this be a totally open joint. That means
that blank records from both files are also selected when their
VoterID exists on the other file.
------------------------------------------------------------------------
*From:* pspp-users-bounces+ricardomejias=hotmail....@gnu.org
<pspp-users-bounces+ricardomejias=hotmail....@gnu.org> on behalf of
pspp-users-requ...@gnu.org <pspp-users-requ...@gnu.org>
*Sent:* Sunday, January 5, 2025 12:01 PM
*To:* pspp-users@gnu.org <pspp-users@gnu.org>
*Subject:* Pspp-users Digest, Vol 221, Issue 2
Send Pspp-users mailing list submissions to
pspp-users@gnu.org
To subscribe or unsubscribe via the World Wide Web, visit
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnu.org%2Fmailman%2Flistinfo%2Fpspp-users&data=05%7C02%7C%7C737f98acdd4c4f7fc16d08dd2daaaf91%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638716933282740987%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=aIe0Mw2nbRaoK2g0oSSpTnse1DXNvR39pXZcuyM%2FVEk%3D&reserved=0
<https://lists.gnu.org/mailman/listinfo/pspp-users>
or, via email, send a message with subject or body 'help' to
pspp-users-requ...@gnu.org
You can reach the person managing the list at
pspp-users-ow...@gnu.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pspp-users digest..."
Today's Topics:
1. Re: Questions of MATCH FILES (Phong Duong)
2. Re: Questions of MATCH FILES (ft gmail)
----------------------------------------------------------------------
Message: 1
Date: Sat, 4 Jan 2025 18:01:35 -0600
From: Phong Duong <phong_du...@yahoo.com>
To: Ricardo Mejias <ricardomej...@hotmail.com>
Cc: pspp-users@gnu.org
Subject: Re: Questions of MATCH FILES
Message-ID: <1dea2bee-7ae4-42e6-9a67-00e685cab...@yahoo.com>
Content-Type: text/plain; charset="utf-8"
An HTML attachment was scrubbed...
URL:
<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnu.org%2Farchive%2Fhtml%2Fpspp-users%2Fattachments%2F20250104%2Ff3b2f3b8%2Fattachment.htm&data=05%7C02%7C%7C737f98acdd4c4f7fc16d08dd2daaaf91%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638716933282758588%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=L0NFZLLOTfDS4eklwZTYG6Xcr9kS1uwo2uRdFCPaNGI%3D&reserved=0
<https://lists.gnu.org/archive/html/pspp-users/attachments/20250104/f3b2f3b8/attachment.htm>>
------------------------------
Message: 2
Date: Sun, 5 Jan 2025 13:56:49 +0100
From: ft gmail <public....@gmail.com>
To: pspp-users@gnu.org
Subject: Re: Questions of MATCH FILES
Message-ID: <99bbcb90-dd6e-4b1e-b3af-2fd96bafb...@gmail.com>
Content-Type: text/plain; charset="utf-8"; Format="flowed"
The list does not accept images, it is text only. So, to make us
understand your question please copy-paste your syntax.
Thanks.
Le 05/01/2025 à 01:01, Phong Duong a écrit :
> Perhaps there should be no period before /ByVoterID.
>
> Sent from my iPhone
>
>> On Jan 4, 2025, at 13:58, Ricardo Mejias <ricardomej...@hotmail.com>
>> wrote:
>>
>>
>>
------------------------------------------------------------------------
>> *When I run this code:*
>> *
>> *
>> *
>> <image.png>
>> *
>> *I get this error message. It happens with and without a period
>> after /ByVoterID. What do I have to change to avoid this error?*
>> *
>> *
>> *
>> <image.png>
>> *
>> *
>> *
>> *Also: What do I do to make the matched file include all the records
>> from both original files, and a blank for all of the fields that do
>> not match the other file, except for the VoterID field?*
>> *I read an IBM website that calls this and "a Full Outer Joint," but
>> does not explain how to accomplish it. And I searched for Outer
>> Joint on the PSPP documentation and did not find it. *
>> *
>> *
>>
*https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ibm.com%2Fdocs%2Fen%2Fcloud-paks%2Fcp-data%2F5.1.x%3Ftopic%3Doperations-merge-node*&data=05%7C02%7C%7C737f98acdd4c4f7fc16d08dd2daaaf91%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638716933282769964%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=%2FUMnWqKj5EavytmbSew%2BB00Z31mC0cKjgfydJBL8rgM%3D&reserved=0
>>
>> <image.png>
>>
>>
>>
>>
>> Merge node (SPSS Modeler) - IBM
>>
<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ibm.com%2Fdocs%2Fen%2Fcloud-paks%2Fcp-data%2F5.1.x%3Ftopic%3Doperations-merge-node&data=05%7C02%7C%7C737f98acdd4c4f7fc16d08dd2daaaf91%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638716933282781349%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=KP5np1iM66kjHWg%2FQfpgYUISXNH%2Fs9daSwrg0%2BeF%2FrQ%3D&reserved=0
<https://www.ibm.com/docs/en/cloud-paks/cp-data/5.1.x?topic=operations-merge-node>>
>> The function of a Merge node is to take multiple input records and
>> create a single output record containing all or some of the input
>> fields. This is a useful operation when you want to merge data from
>> different sources, such as internal customer data and purchased
>> demographic data.
>>
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ibm.com%2F&data=05%7C02%7C%7C737f98acdd4c4f7fc16d08dd2daaaf91%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638716933282792399%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=sEmqGd8lfk7U1YmlS%2BZimLwSlf7jI15EyiHcQe%2BbyBw%3D&reserved=0
<http://www.ibm.com/>
>>
>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnu.org%2Farchive%2Fhtml%2Fpspp-users%2Fattachments%2F20250105%2F27e921ea%2Fattachment.htm&data=05%7C02%7C%7C737f98acdd4c4f7fc16d08dd2daaaf91%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638716933282804284%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=57B3TcrkHFdqx815S9%2FM5IfFsCBFQKOOMo16jmRUzFI%3D&reserved=0
<https://lists.gnu.org/archive/html/pspp-users/attachments/20250105/27e921ea/attachment.htm>>
------------------------------
Subject: Digest Footer
_______________________________________________
Pspp-users mailing list
Pspp-users@gnu.org
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnu.org%2Fmailman%2Flistinfo%2Fpspp-users&data=05%7C02%7C%7C737f98acdd4c4f7fc16d08dd2daaaf91%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638716933282817993%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=D5B%2BckWorSOZjjSoZ2sa45BN%2Bv6z5GyjJjAHy7jhx%2B4%3D&reserved=0
<https://lists.gnu.org/mailman/listinfo/pspp-users>
------------------------------
End of Pspp-users Digest, Vol 221, Issue 2
******************************************
