MERGE statement Questions

1

STAR JOIN command in SPSS
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 [...]

Answer Question   |  September 17, 2012  3:26 PM
MERGE statement, SPSS, star join statement, version 21
asked by:
20 pts.

SPSS v. 21 STAR JOIN
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 [...]

Answer Question   |  September 11, 2012  5:25 PM
MERGE statement, star join statement, version 21
asked by:
20 pts.

Merging Organizations in Oracle
How is the best way to merge two orgs in Oracle?

Answer Question   |  November 12, 2010  7:34 AM
MERGE statement, Oracle, Oracle administration
asked by:
15 pts.

Merge two datasets in a DO loop
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 [...]

Answer Question   |  September 21, 2011  3:44 PM
DO LOOP statement, MERGE statement, SAP Business Intelligence, SAS, SAS Business Intelligence software, SAS Data Analysis
asked by:
5 pts.

Use of multiple SET/WHERE clauses in the MERGE of 2 Oracle tables
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 [...]

Answer Question   |  December 23, 2008  3:49 PM
MERGE statement, Oracle Table, PL/SQL, SET/WHERE
asked by:
15 pts.

SORT/MERGE
Hello, Can anyone, provide sample programs for SORT/MERGE statements in COBOL/400?

Answer Question   |  September 9, 2008  7:06 AM
COBOL/400, MERGE statement, SORT statement
asked by:
0 pts.

1