Hi Reeza,   I want to remove the duplicates for my output table column names and want to make their corresponding values as columns.   proc sql; create table DSC.Team as select TEAM, from DSC.Scorecard order by Team; run;   proc sort data= DSC.TEAM NODUPKEY; by TEAM; run;   proc transpose data= DSC.Team out= DSC.Team_Trans; ID Team; run;   Here I have made the first row to column names and I am just wondering how to populate the table with its corresponding values   Thanks! ... View more