topic Query regarding merging two datasets in SAS Programming

Query regarding merging two datasets

manish_1 — Mon, 01 May 2017 08:57:14 GMT

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.

Re: Query regarding merging two datasets

PeterClemmensen — Mon, 01 May 2017 08:59:45 GMT

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.

Re: Query regarding merging two datasets

Kurt_Bremser — Mon, 01 May 2017 09:00:53 GMT

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.