SAS QUERY EQUIVALENT TO SQL SERVER PIVOT

Binda — Mon, 30 Jan 2017 11:24:50 GMT

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.

Re: SAS QUERY EQUIVALENT TO SQL SERVER PIVOT

RW9 — Mon, 30 Jan 2017 12:14:55 GMT

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;