topic Reg:Sort in SAS Procedures

Reg:Sort

R_Win — Thu, 16 Apr 2009 06:41:41 GMT

i am running a dataset the sort out put is taking alphabetically
data x3;
input d$;
cards;
jan07
feb07
aug07
aug06
feb06
run;
proc sort data=x3;
by d;
run;

i want the output like this

feb06
aug06
jan07
feb07
aug07

but it is comming like this
aug06
aug07
feb06
feb07
jan07

can u give any idea

Re: Reg:Sort

Andre — Thu, 16 Apr 2009 07:52:39 GMT

you have to change your d a character variable into a dn a numeric date
like this

data x3;
input d $;
dn=input(d,monyy5.);
cards;
jan07
feb07
aug07
aug06
feb06
run;
proc sort data=x3;
by dn;
run;

Re: Reg:Sort

deleted_user — Thu, 16 Apr 2009 08:17:29 GMT

You read your values as characters, so SAS sorts them as characters...
You can import them as dates :
[pre]
data x3 ;
input d ANYDTDTE10. ;
format d MONYY. ;
cards ;
jan07
feb07
aug07
aug06
feb06
run ;

proc sort data = x3 ;
by d ;
run ;

proc print data = x3 noObs ;
title "Ordered Dates" ;
run ;
[/pre]