topic Merge dropping entries in SAS Procedures

Merge dropping entries

Gil_ — Wed, 18 Oct 2017 15:49:54 GMT

Im doing a merge table1 has 50. Entries and table 2 has 4. I do a proc sort on both tables by name
My merge table looks like this

Data report;
Merge table1 table2;
By name;
Run;

Output is 50 i expect 54

Re: Merge dropping entries

Gil_ — Wed, 18 Oct 2017 15:49:59 GMT

Re: Merge dropping entries

Astounding — Wed, 18 Oct 2017 16:34:37 GMT

In theory, the number of observations in the output could be anywhere from 50 to 54.

Why do you expect 54? What do you expect MERGE to do when the same NAME appears in both data incoming data sets?

Re: Merge dropping entries

Gil_ — Wed, 18 Oct 2017 16:40:26 GMT

I wanted to combine table1 and tab table2. To create table 3. I have 4 in table 2 and 50 from table1. 54 in new table 3

Re: Merge dropping entries

Astounding — Wed, 18 Oct 2017 16:51:12 GMT

For that, change the word MERGE to the word SET.

MERGE is actually a more complex process.

Expect that you will have more than one observation with the exact same NAME when you are done.

Re: Merge dropping entries

Reeza — Wed, 18 Oct 2017 17:42:26 GMT

If you’re tryimg to add rows it’s an APPEND.

If you’re trying to add columns it’s a MERGE.

READ the SAS chapter on Combining Data.

http://documentation.sas.com/?docsetId=lrcon&docsetTarget=p15jvywi5avt3cn1bee8r6c33ux1.htm&docsetVersion=9.4&locale=en