assigning value from another dataset

[KoVa]

Hi guys,

I have 2 datasets with one common value, let's call that value 'source'. 

set 1

source    file

1              A12

1              Ddd55      

56            C566

57            D684

so one source can have multiple files (source is not a unique column), l

let's assume the max files per source is 3. 

each file is unique.

set 2

source   code

1              A

1              B      

1              C

56            D

56            E

56            F

57            G

57            H

57            I

so in this dataset there are 3 codes for each source. all these codes are unique. 

I need to assign a code from dataset 2 to each source in dataset 1, 

keeping the unique character (so 1 code per file). 

so the result would have to be something like:

source    file             code 

1              A12          A 

1              Ddd55      B

56            C566        D

57            D684        G

I'm breaking my head because I believe the solution will probably be very simple???

[ghosh · Accepted solution]

data want;
  merge set1(in=a) set2;
  by source;
  if a;
run;