topic Re: Proc Transpose case in SAS Procedures

Proc Transpose case

fabdu92 — Wed, 22 Feb 2017 12:03:12 GMT

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__ — Wed, 22 Feb 2017 12:12:40 GMT

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

fabdu92 — Wed, 22 Feb 2017 18:23:03 GMT

Thanks, it works! 🙂