Proc Transpose case

[fabdu92]

Hi,

I have a table with three mains columns

*product

*type

*price

I want to transpose it in a way to have a new table with:

*product

*type1_price

*type2_price

...

*typen_price

Exemple:

Table Have

product type price
A Z1 32
A Z2 22
B Z1 24
B Z2 18

Table Want

product Z1 Z2
A 32 22
B 24 18

I don't get it with the common proc transpose

Do you have an idea to do it?

Thanks

[data_null__ · Accepted solution]

proc transpose data=product out=wide(drop=_name_);
   by product;
   id type;
   var price;
   run;

[fabdu92]

Thanks, it works! 🙂