|
Hi,
You should use the order=internal on the ascending clause of your
sort sequence.
Example: define group/group order=internal ... ;
Regards,
Bernard Tremblay
\\\|///
\\ - - //
( @ @ )
+-----oOOo-(_)-oOOo-------+--------------------------------------+
| Bernard Tremblay | |
| La Capitale | Tel: (418) 646-2401 |
| | Fax: (418) 646-5960 |
| | Int: Bernard.Tremblay@capitale.qc.ca |
+-------------------------+--------------------------------------+
| Imaginasys enr | Res: (418) 658-1411 |
| | Int: bertrem@quebectel.com |
+--------------Oooo-------+--------------------------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~>>>
From: leonora dela cruz <lcdelac@pacbell.net>
>>>Subject: Formats
>>>
>>>Hi Sas-Lers,
>>>
>>>I remember someone asked about this but I could'nt find this in
>>>the archive. Anyway, how do I keep the rows in the
>>>order of the values of the formatted values? I am using
>>>PROC report and the group variable I am using is to be
>>>displayed with formatted values. For example,
>>>
>>>proc format '
>>> value $group
>>> '01' = 'Target Group'
>>> '04' = 'New Group'
>>> '05' = 'Old Group'
>>> '99' = 'Other Group';
>>>
>>>I want the rows in the report used as bygroup to be displayed as
>>>
>>> Target Group 99999
>>> New Group 99999
>>> Old Group 99999
>>> Other Group 99999
>>>
>>>and NOT as
>>>
>>> New Group 99999
>>> Old Group 99999
>>> Other Group 99999
>>> Target Group 99999
>>>
>>>Thanks in advance for any reply or suggestion.
|
