topic Re: Select values from many datasets in SAS Programming

Select values from many datasets

Emma8 — Thu, 18 Jun 2020 02:44:59 GMT

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

Re: Select values from many datasets

Patrick — Thu, 18 Jun 2020 03:54:07 GMT

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

Re: Select values from many datasets

Emma8 — Thu, 18 Jun 2020 03:57:36 GMT

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.

Re: Select values from many datasets

andreas_lds — Thu, 18 Jun 2020 04:43:28 GMT

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;