Help using Base SAS procedures

merge but keep distinct

Reply
Super Contributor
Posts: 395

merge but keep distinct

Hi, I'm trying to merge 2 sets, but keep them distinct .. better show what I mean:

HAVE

Data1:

CODECompanyA
A34
C23
D56
E78
F45
G99
H43

Data2

CodeCompanyB
A12
B65
C73
D56
E17
F33
J74

This is what I would like it to look:

WANT:

CodeCompanyACompanyB
A3412
B65
C2373
D5656
E7817
F4533
G99
H43
J74


Thank you..

Super User
Super User
Posts: 6,495

merge but keep distinct

data want ;

   merge data1 data2;

   by code;

run;

Super Contributor
Posts: 395

merge but keep distinct

Sometimes you forget the simple ways... I over 'thought' it Smiley Happy .. thanks

Ask a Question
Discussion stats
  • 2 replies
  • 122 views
  • 3 likes
  • 2 in conversation