Prev: When Appending Where's the Wanted Comma?
Next: Putting the value of a %do loop every thousandth time?
From: "Terjeson, Mark" on 9 Dec 2009 16:09
Hi All,

On a v8.2 platform I have tried the following syntaxes
in PROC REPORT:


define my_date /group order=3Ddata descending 'MyDate';

or

define my_date /group order=3Dinternal descending 'MyDate';

or

define my_date /group descending 'MyDate';


(if my_date added to the BY statement and pre-sorted order
then you get a separate report for each my_date value, which
is not what is desired. I'm looking for only one report, that sorts
the all rows in descending order across all pages, and merely
paginates a header for each physical page size)


For example, if the dataset contains

31DEC1998
30JUN1998
31DEC1999
30JUN1999
31DEC2000
30JUN2000
31DEC2001
30JUN2001
31DEC2002
30JUN2002
31DEC2003
30JUN2003
31DEC2004
30JUN2004
31DEC2005
30JUN2005

with all of the above syntaxes I am getting two pages


HEADER page 1
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
31DEC2001
30JUN2001
31DEC2000
30JUN2000
31DEC1999
30JUN1999
31DEC1998
30JUN1998

HEADER page 2
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
31DEC2005
30JUN2005
31DEC2004
30JUN2004
31DEC2003
30JUN2003
31DEC2002
30JUN2002

now obviously, the rows are sorted in descending order
but as you can see the "pages" are in ascending order.
But what is desired is to have page one have 2005-2002
and page two have 2001-1998.

Is there a way to adjust the "pagination order" from
ascending to descending? or some other prep on=20
the dataset to trick it? or ???



> Mark Terjeson
Investment Business Intelligence
Investment Management & Research
> Russell Investments
> 253-439-2367
>=20
>=20
> Russell
> Global Leaders in Multi-Manager Investing
>=20
 | 
Pages: 1
Prev: When Appending Where's the Wanted Comma?
Next: Putting the value of a %do loop every thousandth time?