transpose and ascending display of date

SASPhile — Wed, 29 Sep 2010 17:28:56 GMT

I use the following code:
proc transpose data=adhoc2 out=Out1;
by boutique_src_cd ph_name BN_NAME ;
id date;
var total;
run;

in the output the date is displayed in alphabetical order of the month i.e Apr_09,
Apr_10 ,Aug_09,Dec_09.
How to display the dates in asceding order instead?Mar_09 to Aug_10?

Re: transpose and ascending display of date

sbb — Wed, 29 Sep 2010 18:10:32 GMT

You will need to pre-sort your data using a SAS numeric-type DATE variable, even if you choose to transpose a character-formatted variable "date". As SAS encounters the input data, that event cause the transposed ID variables to get added to the PDV, so by pre-sorting your file, that takes care of column order in the output file.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

proc transpose id varibale order site:sas.com

..and from the search results...
Sample 25104: Maintain the order of ID variables in the output data set created by PROC TRANSPOSE
http://support.sas.com/kb/25/104.html

topic transpose and ascending display of date in SAS Programming

transpose and ascending display of date

Re: transpose and ascending display of date