BookmarkSubscribeRSS Feed
PriyaSaha
Calcite | Level 5

How could we  combine more than 2 data set like proc sql join statement like in data step merge statement.

Thanks,

Priya

2 REPLIES 2
KachiM
Rhodochrosite | Level 12

It is possible in data step but give some example data sets. Instead I make a guess of what you want, you provide small example data sets and the output data set you desire.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

data want;

     merge dataset_a dataset_b dataset_c;

     by idvar1 idvar2;

run;

But it depends on the type of join you want, left/right/inner/outer etc.  They all have differing requirements.

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

Watch Now →
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
  • 4104 views
  • 0 likes
  • 3 in conversation