Just run this query, data test1; input part_code$ miami la; cards; A_1 60000 38000 A_2 5000 2000 A_3 1000 60000 ; run; proc transpose data = test1 out = test2; by part_code; var miami la; run; data test3; input part_code$ city$; cards; A_1 Miami A_1 LA A_2 Miami A_2 LA ; run; proc sql; create table test4 as select distinct a.* from test2 a left join test3 b on a.part_code = b.part_code; quit;
... View more