difference between Set and Marge statement, why output table is different

mahossain — Mon, 20 Jul 2020 20:07:03 GMT

/* Concatenate (or Union) the two data sets*/
data GroupA;
input ID$ Product$;
datalines;
A Apple
B Grapes
B Orange
C Banana
E Apple
run;

data GroupB;
input ID$ Product$ Size$;
datalines;
B Shirt S
C Pants M
D Jacket L
E Tie M
E Wallet L
run;

data concat;
set GroupA GroupB;
run;
proc sort data=concat;
by ID;
run;
/* Merge the two data sets*/
data merged;
merge GroupA GroupB;
by ID;
run;

Re: difference between Set and Marge statement, why output table is different

Reeza — Mon, 20 Jul 2020 20:11:53 GMT

SET appends data, ie stacks the datasets on top of each other.
MERGE adds data in a side to side fashion, making you data wider.

You SHOULD NOT be expecting the same results from the different code.

All the different options and methods are explained here:
https://documentation.sas.com/?docsetId=lrcon&docsetTarget=n1tgk0uanvisvon1r26lc036k0w7.htm&docsetVersion=9.4&locale=en

@mahossain wrote:

/* Concatenate (or Union) the two data sets*/
data GroupA;
input ID$ Product$;
datalines;
A Apple
B Grapes
B Orange
C Banana
E Apple
run;

data GroupB;
input ID$ Product$ Size$;
datalines;
B Shirt S
C Pants M
D Jacket L
E Tie M
E Wallet L
run;

data concat;
set GroupA GroupB;
run;
proc sort data=concat;
by ID;
run;
/* Merge the two data sets*/
data merged;
merge GroupA GroupB;
by ID;
run;

topic Re: difference between Set and Marge statement, why output table is different in SAS Programming

difference between Set and Marge statement, why output table is different

Re: difference between Set and Marge statement, why output table is different