Does anyone know what the STAR JOIN command is doing in SPSS version 21? It is the new MERGE files command and I am having trouble with it. When a case from the active data set contains a value that is not in the keyed data set it just stops at that case and will [...]
I have just started with version 21 and I have run into a major issue. Merge is no longer the MATCH CASES command. It is now STAR JOIN. There is something different that this command is doing. When merging, the command just stops when it runs into a keyed variable that has no match in [...]
How is the best way to merge two orgs in Oracle?
I have two datasets like this: data1 : store sales1 sales2….sales52 1 2 3 . . 10 data2: Store sales1 sales2…..sales52 1 2 3 . . . 100 okay, now what I want is to take the first row of data1 merge it with data2, take the difference of sales between the observation from [...]
Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in an UPDATE of [...]
Hello, Can anyone, provide sample programs for SORT/MERGE statements in COBOL/400?





