Select values from many datasets

[Emma8]

Hi. I would like to select distinct values from 3 datasets without merging it,
For example,
Age variable from 3 datasets:
Data 1 data 2 data 3
1 4 7
3 5 8
5 7 9

[Patrick]

Would the desired result be a list of distinct values per data set or the list of distinct values over all data sets?

[Emma8]

District values over all datasets.—I would like to compare across column and rows so—it would nice if formatted as in my first message notes. Thank you.

[andreas_lds · Accepted solution]

The problem could be solved by using data-step merge without by ... why don't you want to use merge?

proc sort data=a out=a_sorted(keep=Age) nodupkey;
	by Age;
run;

proc sort data=b out=b_sorted(keep=Age) nodupkey;
	by Age;
run;

proc sort data=c out=c_sorted(keep=Age) nodupkey;
	by Age;
run;

data compare;
	merge
		a_sorted(rename=(Age = Age_A))
		b_sorted(rename=(Age = Age_B))
		c_sorted(rename=(Age = Age_C))
	;
run;