topic Re: Merging in SAS Programming

Merging

Sultana — Wed, 30 Dec 2020 06:42:05 GMT

I have two data sets in one data SSN zip code and address and city are provided and in other ssn and rank codes are provided after merging both the data sets I am not get all the zip code some are missing
My code is merge
Data 1(in=a) Data 2 (in =b)
If a;
I also tried with if b but that is not what I need
I need a code so that I can get all the zip codes from data 1

Please suggest

Re: Merging

Shmuel — Wed, 30 Dec 2020 07:19:21 GMT

Can you provide a sample of both datasets where the merge outcome result with a missing zip code?

Re: Merging

PeterClemmensen — Wed, 30 Dec 2020 07:19:26 GMT

Show us your data.

Re: Merging

Astounding — Wed, 30 Dec 2020 12:11:45 GMT

The code you posted could not possibly be your real code. If you want real help, post your real code.

Re: Merging

Tom — Wed, 30 Dec 2020 19:32:10 GMT

Sounds like you want to merge by SSN. Make sure to include the BY statement or else the MERGE statement will just match the observations in the order they appear, whether the SSN values match or not.