https://communities.sas.com/t5/SAS-Programming/transpose-and-ascending-display-of-brand-name/m-p/47100#M9728 Just to clarify, what about the result data set is not what you want? The variable names in the new data set will be placed on the PDV in ascending order. Using sashelp.shoes I tried your code:<BR /> [pre]proc sort data= sashelp.shoes out=shoes;<BR /> by subsidiary product;<BR /> run;<BR /> proc transpose data=shoes out=wide2(drop=_name_);<BR /> id product;<BR /> by subsidiary;<BR /> var sales;<BR /> run; [/pre] Wed, 08 Dec 2010 20:02:05 GMT ArtC 2010-12-08T20:02:05Z https://communities.sas.com/t5/SAS-Programming/transpose-and-ascending-display-of-brand-name/m-p/47099#M9727 How to transpose and ascending display of brand name?<BR /> <BR /> proc sort data= cmopdod_v2_qunty;<BR /> by outlet _Brand_Name;<BR /> run;<BR /> proc transpose data=cmopdod_v2_qunty out=wide2(drop=_name_);<BR /> id Brand_Name;<BR /> by outlet;<BR /> var quantity;<BR /> <BR /> run; Wed, 08 Dec 2010 19:27:36 GMT https://communities.sas.com/t5/SAS-Programming/transpose-and-ascending-display-of-brand-name/m-p/47099#M9727 SASPhile 2010-12-08T19:27:36Z https://communities.sas.com/t5/SAS-Programming/transpose-and-ascending-display-of-brand-name/m-p/47100#M9728 Just to clarify, what about the result data set is not what you want? The variable names in the new data set will be placed on the PDV in ascending order. Using sashelp.shoes I tried your code:<BR /> [pre]proc sort data= sashelp.shoes out=shoes;<BR /> by subsidiary product;<BR /> run;<BR /> proc transpose data=shoes out=wide2(drop=_name_);<BR /> id product;<BR /> by subsidiary;<BR /> var sales;<BR /> run; [/pre] Wed, 08 Dec 2010 20:02:05 GMT https://communities.sas.com/t5/SAS-Programming/transpose-and-ascending-display-of-brand-name/m-p/47100#M9728 ArtC 2010-12-08T20:02:05Z