topic Re: how to combine two dataset with different variables in New SAS User

how to combine two dataset with different variables

hjjijkkl — Wed, 10 Mar 2021 15:12:58 GMT

I have two dataset similar to the examples below, both datasets have different variables. i wanted to read only observations (IDs) that are in both data.

Dataset one Dataset two
ID   A   B ID C D
10   1   2 10   0 4
20   3   4 30   5 2
30   5   6 40   7 3

I want the output that looks like this

ID A B C D
10 1 2 0 4

30 5 6 5 2

Re: how to combine two dataset with different variables

PaigeMiller — Wed, 10 Mar 2021 15:16:47 GMT

data want;
    merge one(in=in1) two(in=in2);
    by id;
    if in1 and in2;
run;

In the future, please provide data as SAS data step code, so we can actually use it to test the code we provide. This helps all of us out, and gets you faster and more likely correct answers. Here are the instructions: https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/. Do not provide the data in other forms.