topic Re: Merge or set for combining data? in New SAS User

Merge or set for combining data?

crawfjor — Wed, 02 Dec 2020 03:17:44 GMT

I am close to finishing a semester project working with loads of data sets together. Some needing to be combined vertically or horizontally, transposed, etc.

Anyway, I'm still at a point of not fully understanding the differences in a merge or set statement. I've combined data sets both ways but also have a tendency to cause issues I later have to deal with. Is it better to use a merge or set statement or what issues may I run into?

Re: Merge or set for combining data?

LinusH — Wed, 02 Dec 2020 06:57:46 GMT

Put simply:

Merge: combine data values into same record

Set: combine data into different records

Re: Merge or set for combining data?

Shmuel — Wed, 02 Dec 2020 06:59:51 GMT

Use MERGE when all data sets have the same key variables, same names and same type.

In case a variable X is numeric in one data set but char type in another you will have an issue,

either using merge or set.

To use MERGE all data sets should be first sorted by KEYs and finally you can merge them by KEYs.

Merging mean keeping the order of observations by KEYs.

By SET you concatenate the data sets (appending them) in the original order.

Finally you can sort it by KEYs to get same result as by using MERGE.