| Date: | Sun, 14 Mar 2010 15:27:46 +0800 |
|---|
| Reply-To: | deli <21july@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | deli <21july@GMAIL.COM> |
|---|
| Subject: | z2.? |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Hi,
if txn_date is in date format...
mth=month(txn_date) then it shows mth =1;/* if txn_date mth =jan*/
mth=month(txn_date) then it shows mth =2;/* if txn_date mth =feb*/
mth=month(txn_date) then it shows mth =3;/* if txn_date mth =mar*/
mth=month(txn_date) then it shows mth =10;/* if txn_date mth =oct*/
mth=month(txn_date) then it shows mth =11;/* if txn_date mth =nov*/
mth=month(txn_date) then it shows mth =12;/* if txn_date mth =dec*/
then the order by mth will be
1
10
11
12
2
3...
how can i change mth's order back to jan, feb, mar...oct, nov,
dec from 1,2,3...10,11,12 or
how can i change mth's order back to jan, feb, mar...oct, nov,
dec from 200901,200902,200903...200910,200911,200912
tks.
deli
|
