BookmarkSubscribeRSS Feed
podarum
Quartz | Level 8

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..

2 REPLIES 2
Tom
Super User Tom
Super User

data want ;

   merge data1 data2;

   by code;

run;

podarum
Quartz | Level 8

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

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1396 views
  • 3 likes
  • 2 in conversation