topic join two dataset by using two variables in SAS Programming

join two dataset by using two variables

freda — Mon, 13 Aug 2018 03:21:15 GMT

Hi, dear all,

I want to merge two datasets by using proc sql.

dataset A dataset B

id code price id ved price

1 a 15 1 af 15

1 f 13 2 cd 13

2 b 11 3 ed 8

2 a 13 4 ff 13

3 c 10 5 gs 15

4 d 10

4 b 13

I want to merge those two datasets on two variables id and price.

The expected result is

merged table

id price code ved

1 15 a af

2 13 a cd

4 13 b ff

I want to keep all the rest information in both datasets.

Thank you so much

Best,

Yanting

Re: join two dataset by using two variables

shahparth260 — Mon, 13 Aug 2018 03:39:52 GMT

Prof sql noprint;
Create table want as
select *
From datasetA as x right join datasetB as y
On x.id=y.id and x.price=y.price
Quit;

Note make sure price and ID should be same format either numeric or characters

Re: join two dataset by using two variables

shahparth260 — Mon, 13 Aug 2018 05:24:36 GMT

Thank you !!!