SAS QUERY EQUIVALENT TO SQL SERVER PIVOT

[Binda]

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. 

[RW9 · Accepted solution]

NOTE: Post test data in the form of a datastep.

This should be simple in proc transpose, what have you tried?

proc sort data=have;
  by col2 col1;
run;
proc transpose data=have out=want;
  by col2;
  var price;
  id col1;
  idlabel col1;
run;