Query regarding merging two datasets

[manish_1]

I have two datasets bsas1 and bsas2. I want to merge these datasets by name, therefore i used the command 'by name' but it didn't worked although when i run command 'by id' it worked. Why is it so ?. 

Below is the attached jpg screenshot.

[PeterClemmensen]

Because your data is not sorted by name, but by ID. Run the code

proc sort data = bsas1;
	by name;
run;

proc sort data = bsas2;
	by name;
run;

and try again.

[Kurt_Bremser · Accepted solution]

A datastep merge with a by statement expects that the datasets are sorted in the order specified by the by statement. Use proc sort to achieve that.