Solved: Merge

Jahanzaib · Posted 12-06-2016 09:38 PM

while merging data i got following error, can anyone look at it and tell me how to deal with it.

Astounding · Posted 12-06-2016 10:02 PM

This message is telling you that COMPANY is part of both data sets that you are merging. However, it has a different length in the two data sets. You would need to examine the length (probably running PROC CONTENTS on both data sets), select the longer length, and use that to define COMPANY. You would do that by adding this sort of statement (using the longer length rather than 20):

length company $ 20;

It has to go BEFORE the MERGE statement.

View solution in original post

Astounding · Posted 12-06-2016 10:02 PM

This message is telling you that COMPANY is part of both data sets that you are merging. However, it has a different length in the two data sets. You would need to examine the length (probably running PROC CONTENTS on both data sets), select the longer length, and use that to define COMPANY. You would do that by adding this sort of statement (using the longer length rather than 20):

length company $ 20;

It has to go BEFORE the MERGE statement.

mkeintz · Posted 12-06-2016 11:57 PM

Or if the first dataset in the merge statement (E1 in your case) has company with the longer length, it will prevail.

In general the first encounter with a variable establishes its attributes (length, format, label), while the last encounter establishes the value.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Merge

Re: Merge

Re: Merge

Re: Merge

Merge

Re: Merge

Re: Merge

Re: Merge

The 2025 SAS Hackathon has begun!

SAS Training: Just a Click Away