topic Re: proc transpose stopping auto sorting of var names in SAS Programming

proc transpose stopping auto sorting of var names

SachinRuk — Fri, 19 Nov 2010 01:11:32 GMT

Hi All,

This is what I want my table to end up looking like after a proc transpose.

Measure Mar 10 Aug 10
Month 10 11
Annual 12 13

but thanks to the way the proc transpose had been used it ends up like:

Measure Aug 10 Mar 10
Annual 13 12
Month 11 10

It sorts the variable names as well as the measures in alphabetic order :(.

Any thoughts?

Thanks,
Sachin

Re: proc transpose stopping auto sorting of var names

sbb — Fri, 19 Nov 2010 01:23:15 GMT

PROC TRANSPOSE will operate on your data as it is read up. Suggest using PROC SORT to put the data in the desired order before calling PROC TRANSPOSE. Suggest checking the DOC and also the SAS support website for technical references.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

proc transpose data order column site:sas.com

Re: proc transpose stopping auto sorting of var names

Ksharp — Fri, 19 Nov 2010 02:57:29 GMT

Hi.
Without view all of your code, It is hard to say something.
But I guess you can make an index variable to get the order you need.

Ksharp