Here's the output for each of the four PROC SQL statements:   Table_A_Not_B Obs Code Test Value seq_num 1 1001 ABCD Above_average 1 2 1001 ABCD Average 2   Table_B_Not_A Obs Code Test Value1 seq_num 1 1001 ABCD Below_average 1   Want_Side_by_Side Obs Code Test Value Value1 seq_num 1 1001 ABCD Above_average Below_average 1 2 1001 ABCD Average   2   Want_Stacked Obs Code Test Value Row_Source 1 1001 ABCD Above_average Table_A_Not_B 2 1001 ABCD Average Table_A_Not_B 3 1001 ABCD Below_average Table_B_Not_A   ... View more