1. set the two datasets with two columns (name, income). 2. proc sql; avg(income) as income group by name OR merge the two datasets by name, with three columns. then calculate average.
... View more
libname folder1 '...' libname folder2 '...' proc sql; create table t1 as select memname from dictionary.tables where upcase(libname）=folder1 create table t2 as ...(the same here) quit; proc compare t1 vs t2;
... View more
