I have already created a table and the data looks like: product    col2          price A              456          5666 A              123          4000 B              333           2569 B              456          1500  Now, I want to transpose the result set in the following way: col2    A           B 456    5666     1500 123    4000     null 333   null        2569   This can be done easily in sql server using PIVOT function. I was trying to use PROC TRANSPOSE in SAS but could not get the proper result.    ... View more